I have just installed SSMS 2014 Express on a brand new Windows Server 2012 (x64) so I connect to the SQL Server 2014 instance running on a different Windows Server 2012. This is working without issue and I can connect to the instance no problem. The installation also appears to have included Visual Studio 2010 Shell (Isolated) which has made file associations with all my ASP.NET files (.aspx, .ascx, web.config, etc). Now when I try and open any ASP.NET files via Windows Explorer, I get the infamous error message from "Visual Studio 2010 Shell" ... > Invalid license data. Reinstall is required. I've seen hundreds of messages on the internet about this infamous message, but I cannot find a single straight answer about how to fix it. The most prominent one is about how this can happen on when you upgrade from a "higher beta to a lower RC"... such as this MSDN Blog . But this is not the case for me, as this is a vanilla installation. I have also tried installing the SQL Server Data Tools as per this post on Experts-Exchange , but that did help either, and just cause me more confusion. I have uninstalled/reinstalled SSMS 2014 3 times now (which can't be a good thing in itself). Can anybody please point me in the right direction? If this is not strictly a DBA question, please let me know where I should have posted it

Visual Studio 2010 introduces database projects and a whole array of related features that supposedly facilitate database development. I've used SQL Server Management Studio (SSMS) for many years to do my database development without issue. - Why should I bother with VS2010 when SSMS works for me? What, specifically, does it do better than SSMS? - But perhaps my premise is incorrect and SSMS still trumps VS for database development. If so, in what specific ways is that true?

myconn.Open() Dim command As New SqlCommand("Select * from Food where Food List = @list", myconn) command.Parameters.Add("@list", SqlDbType.VarChar).Value = txtbox1.Text Dim adapter As New SqlDataAdapter(command) Dim table As New DataTable() adapter.Fill(table) the error i get will show at the adapter.fill(table) saying i have non boolean type at(Food List) how do i fix this any idea?beginner at vb

I have a number of SSIS Packages I am trying to locate a table that is populated by one of the SSIS Package is there an easy way to find in the project where database.dbo.tabledata has been used in a script within the project please help team

I am having the following issue of SSIS AND XLSM load time issue Visual Studio 2010 I want to speed this up I am reading a .xlsm as my excel source I have noticed its loading / reading every row of the excel...even though they are blank e.g I only have 300 + rows of data at the moment, but it loading every row even though they are blank e.g going pass the 400 row where there is no data yet I don't want it reading 200,000+ rows before it actually loads the 300 how do I stop this please team

I am using reporting services to generate a list of families in my database. After the first family member in the list, I want to put the family's address: family, First 123 la la lane Somewhere, Ca 90210 famliy, Second family, Third two, first 345 zippy st Nowhere, UT 85763 two, second two, third At first, I thought my expression would be: =IIF(First(Fields!person_id.Value) = Fields!person_id.Value, Fields!last_name.Value & " " & Fields!person_suffix.Value & ", " & Fields!person_title.Value & " " & Fields!nick_name.Value & " (#" & Fields!person_id.Value & ")" & vbcrlf & Fields!address.Value & vbcrlf & Fields!city.Value & ", " & Fields!state.Value & " " & Fields!postal_code.Value, Fields!last_name.Value & " " & Fields!person_suffix.Value & ", " & Fields!person_title.Value & " " & Fields!nick_name.Value & " (#" & Fields!person_id.Value & ")" ) This is generating a "Overload resolution failed because no accessible 'IIf' accepts this number of arguments." I am guessing my First() does not evaluate properly. How would I craft this expression to achieve the above output?

I try to build plpgsql_check extension by @PavelStehule (Erwin Brandstetter recommended it to me in this answer ) on Windows XP 32bit with Visual Studio 2010 (I used this article as a manual ). However, I got following errors: error LNK2001: unresolved external symbol _exec_get_datum_type error LNK2001: unresolved external symbol _plpgsql_compile error LNK2001: unresolved external symbol _plpgsql_build_datatype error LNK2001: unresolved external symbol _plpgsql_stmt_typename error LNK2001: unresolved external symbol _plpgsql_parser_setup In addition, there are two IntelliSense errors: expected a ')' in plpgsql.h (lines 923 and 953 - both in datum-related functions) - I expect these to be false alerts (if they are important, how to solve them?). After some googling I found that someone had a similar problem on OS X . The problem was that plpgsql.so either wasn't linked or didn't work. I have no plpgsql.so on my computer, but I have plpgsql.dll which should correspond to it. So I linked it and the error changed: error LNK1107: invalid or corrupt file: cannot read at 0x2A8 This dynamic library is part of the PostgreSQL distribution, so it shouldn't be corrupt. However, I'm afraid that what Pavel wrote in the linked discussion applies here: > It needs link against plpgsql.so. I didn't test it against clang - I > remember a talk with Tom Lane, he was surprised so this code works and > probably on some platforms can be unavailable. > > ... > > Nobody expected so plpgsql will be used from other extensions - and > environment is not prepared for it :( The worst case would be that plpgsql checker extension is simply not available under Windows, because it is too low-mana area for such a mighty magic. :-) If I just need a different approach, please point me to it.

Visual Studio 2010 Isolated Shell has the infamous "Invalid License Data. Reinstall" error. I have SSMS 2014. I have tried reinstalling several times, I installed Visual Studio 2013 but SSMS doesn't recognize it. When I attempt to open SSMS, it says something like components missing, reinstall. So when I repair it installs the same VS 2010 with same issue. We have an application with a SQL Server backend database. We have a vendor catalog and then import items to our item database. However, it fails and gives this error code below. So my question is: Could this VS 2010 error be causing this error or is this likely an unrelated issue? > mscorlib 06/18/2016 8:20:42 PM LoadSettings Object reference not > set to an instance of an object. > at PosBeData.Settings.LoadSettings() PosBeData 06/18/2016 8:20:43 PM Time > > Update To: 06/19/2016 12:20 AM 06/18/2016 8:32:47 PM frmImportAdd > String or binary data would be truncated. The INSERT statement > conflicted with the FOREIGN KEY constraint "FK_UPC_Item". The conflict > occurred in database "PosBe", table "dbo.Item", column 'Item_ID'. The > INSERT statement conflicted with the FOREIGN KEY constraint > "FK_VendorPartNo_Item". The conflict occurred in database "PosBe", > table "dbo.Item", column 'Item_ID'. The statement has been terminated. > The statement has been terminated. The statement has been terminated. > > Server stack trace: at > System.ServiceModel.Channels.ServiceChannel.ThrowIfFaultUnderstood(Message > reply, MessageFault fault, String action, MessageVersion version, > FaultConverter faultConverter) at > System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime > operation, ProxyRpc& rpc) at > System.ServiceModel.Channels.ServiceChannel.Call(String action, > Boolean oneway, ProxyOperationRuntime operation, Object[] ins, > Object[] outs, TimeSpan timeout) at > System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage > methodCall, ProxyOperationRuntime operation) at > System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage > message) > > Exception rethrown at : at > System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage > reqMsg, IMessage retMsg) at > System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& > msgData, Int32 type) at > PosBeData.PosBeService.GetAddCatalogItems(dtoV_VendorCatalog[] > VendorCatalogItems, String Import_CD, Int32 Category_ID, Int32 > Sub_Category_ID, Boolean CreateInventory, Boolean CreateCase, String > Default_Mfg, UserAuth ua) at > PosBeData.V_VendorCatalogCollection.AddSelectedItems(String Import_CD, > Int32 Category_ID, Int32 Sub_Category_ID, Boolean CreateInventory, > Boolean CreateCase, String Default_Mfg) at > PosBe.frmVendorCatalog.AddItemsThread() mscorlib

The initial setup contains two scripts: - stored_procedure.sql - stored_procedureV2.sql What I did is: - Remove stored_procedure.sql - Rename stored_procedureV2.sql to stored_procedure.sql When I perform a schema compare in SSDT between a .dacpac not containing this change and my project the action it proposes is to just remove stored_procedure.sql and do nothing else, whilst it should remove stored_procedureV2.sql and update stored_procedure.sql to its new content. As I assume this is where schema compare gets its information: The .sqlproj of the source: ... On On On On ... The .sqlproj of the target: ... On On ... Is this a known issue? Do I need to perform this in two steps? Is there a way to make SSDT behave the way I want?

I want to install Business Intelligence Development Studio for doing report development in Visual Studio 2010, however in my installation process, I cannot find BIDS in the feature selection. What I have done is: - Install Visual Studio 2010 - Upgrade Visual Studio 2010 to SP1 - Installed SQL Server Data tools - Lastly, tried to install SQL server 2008 for BIDS feature. But it is not in the feature selection list What is the matter for this problem? Is there anything that I need to install before I install SQL server 2008? If there is, can I have the link?

I had to modify a report that was assembled entirely within table (with 1 column and 10 rows). After my modifications, the report now spans multiple pages and I need it to break naturally at one point (i.e. beginning of Row 8). Is there a way to add a page break in the middle of a table? Note, I've tried adding a "Rectangle" and applying the page break with no luck (in the desired Row and then tried in the Row above). Additional Info: - using Visual Studio 2010 - DBMS = SQL Server 2012 R2 Any assistance would be greatly appreciated.

Where can I find a link to install SSIS 2010 ( SSDT 2010 or Business Intelligence 2010) I have VS 2010 on my machine.

I am trying to install **SQL Server 2012 Enterprise** with SQL Server **Data Tools** included. I understand that SQL Server Data Tools is part of what was formerly known as BIDS. The installation for SQL Server 2012 prompts me for the **ms_setup.msi** installation file from Visual Studio **2010**. However, I am using Visual Studio **2012** currently only. The equivalent file in VS 2012 is called vs_professionalcore.msi and is located in Visual_Studio2012_Pro\packages\professionalcore\Setup\. **How can I install SQL Server 2012 with Data Tools having only Visual Studio 2012 given the setup?** Is there a download or registry entry I need to make? Thanks for any pointers.

I encountered a very weird thing. I added in my DWH table 2 new columns but when I refreshed the DSV after adding this to my multidimensional project I saw that more (3) columns have been "changed". I did not touch these 3 columns(Marked in red ) they were already in my database before and have been handled . Someone have an idea why this happened? Can I know what "changed"? Also you can see each "changed column appears twice. Here Is the PrintScreen After I refresh the DSV. Marked In blue - the columns I added Marked In red - the Columns I did not touch and was existing in the Table.

Running SQL Server 2012 SP1 and SSDT from same distribution. (VS2010) When I display a report in SSDT the date selector on a date parameter is dynamic or responsive. When you click on the date (month/year) the date picker can zoom in/out. Or drill in/out (Apologies if I'm using the wrong terminology). However looking at same report in SSRS, the date picker doesn't have the same functionality. You can click left and right arrows to get last/next month but clicking on the date does nothing. Does this only work in SSDT? or should it also work in SSRS? If it should work in SSRS, any suggestion of where to start looking would be greatly appreciated. Is it report setting? an SSRS setting? a browser setting? If there is a better description of this feature please let me know and I'll update my question. Thanks Peter

Public Class Form1 Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load Dim SumberDb As String = "Data Source=c:\users\ogieuntung\documents\visual studio 2010\Projects\Local Database Daftar Kontak\Local Database Daftar Kontak\DB.sdf" 'SumberDb akan menunjukan Alamat Database Dim Ogieuntung As New System.Data.SqlServerCe.SqlCeConnection(SumberDb) Dim TransaksiDb As System.Data.SqlServerCe.SqlCeTransaction Ogieuntung.Open() TransaksiDb = Ogieuntung.BeginTransaction() 'Setelan Koneksi "Ogieuntung".BeginTransaction berarti anda telah berhasil membuka Database 'MsgBox("Database telah Terbuka..") Dim TugasDb As New System.Data.SqlServerCe.SqlCeCommand("inser into anggota (nama,password) values ('Nabil','1234')", Ogieuntung, TransaksiDb) **TugasDb.ExecuteNonQuery() 'ERROR HERE!** TransaksiDb.Commit() MsgBox("Data anda telah dimasukan ke Database!") End Sub End Class

I am using SQL Server CE 4.0 SP1. I am using Web Developer 2010 Express to connect to database and perform operations like creating table, modifying column etc. But we cannot connect a database in a network share which is not allowed. I tried with the SQL Server CE Toolbox and Visual Studio add-in these tools allow us to access database present in network path but does not allows us to edit columns directly. It only creates script which we need to run again. So it's not a simple tool. Is there any other tool which allows us to directly edit columns and perform all database operation for the database (.sdf) in network share ?

I have a database with two columns: 1)Word 2) Times Used When the user enters a word it find the combination of words already typed (ex: combo = hello world) and updates the database using a dataset The query is as follows: SELECT TimesUsed, Word FROM Predictions WHERE (Word LIKE @partialWord) ORDER BY TimesUsed DESC In my application I am calling it as follows: PredTable = PredTA.GetDataByPartialWord(combo) If PredTable.Count > 1 Then MsgBox("problem") If PredTable.Count = 1 Then PredTA.Update(PredTable(0).TimesUsed + 1, combo) If PredTable.Count = 0 Then PredTA.Insert(combo, 1) When I debug it is taking 0.15 seconds to just do this query Is there anyway that I can quicken this up?

I have an Excel connection manager which should write to a file which does not exist prior to runtime but rather is created during execution. I have an expression set for the connection string property of the excel connection manager which points to the file that will be created. The problem I am having is that since the file does not yet exist (prior to execution), when I go to run the package it is giving me an error since it can not find the file. If i create a dummy file and place it where the excel connec manager is pointing the package will run ok. What I have tried to do is point the excel connection manager to an existing file prior to run time since it will not give an error and then hopping it will then pick up the new Path (excel connection string) from the Expressions but what is happening is that since I have an expressions set for the connection string property it will not let me overwrite the connection string property, it keeps defaulting to the value of the expressions which contains other variable that are populated during run time so that is where I am getting my error. The expressions string prior to runtime is not pointing to an actual file because it does not yet exist but mainly because the expressions is not fully populated until runtime since it also contains variables. As of right now it seems like I might have to just point to a dummy template file (without using any expressions) prior to runtime and then maybe use a Script to change the connection string property of the excel connec manager to = a variable containing an expression containing the path to the file.... Does this sound like the way to go or am I over complicating things?

I am using SQL Server 2008 R2, when I looked into the services for SQL Server I saw there are two different services with different instances. 1. SQLEXPRESS 2. MSSQLSERVER Can anyone help me to get clear the difference between #1 and #2? Thanks in advance