As of SQL Server 2012 you no longer have to go through the hassle of deleting the bin file (which causes other side effects). You should be able to press the delete key within the MRU list of the Server name: drop-down in the Connect to Server dialog. This is documented in this Connect item … Read more
This is commonly reported as an error due to using the wrong version of SSMS(Sql Server Management Studio). Use the version designed for your database version. You can use the command select @@version to check which version of sql server you are actually using. This version is reported in a way that is easier to … Read more
Go into Tools -> Options -> Designers-> Uncheck “Prevent saving changes that require table re-creation”. Voila. That happens because sometimes it is necessary to drop and recreate a table in order to change something. This can take a while, since all data must be copied to a temp table and then re-inserted in the new … Read more
SQL Server Profiler: File → New Trace The “General” Tab is displayed. Here you can choose “Save to file:” so its logged to a file. View the “Event Selection” Tab Select the items you want to log. TSQL → SQL:BatchStarting will get you sql selects Stored Procedures → RPC:Completed will get you Stored Procedures. More … Read more
Open the design table tab Highlight your two INT fields (Ctrl/Shift+click on the grey blocks in the very first column) Right click -> Set primary key
Open up SQL Server Configuration Manager (search for it in the Start menu). Click on SQL Server Services. The instance name of SQL Server is in parenthesis inline with SQL Server service. If it says MSSQLSERVER, then it’s the default instance. To connect to it in Management Studio, just type . (dot) OR (local) and … Read more
If the table is already created in the database, then you can add a unique constraint later on by using this SQL query: ALTER TABLE dbo.User ADD CONSTRAINT ucCodes UNIQUE (fcode, scode, dcode)
127.0.0.1,6283 Add a comma between the ip and port
So your C# code is sending an ad hoc SQL query to SQL Server, using what method? Have you considered using a stored procedure? That would probably ensure the same performance (at least in the engine) regardless of who called it. Why? The ARITHABORT setting is one of the things the optimizer looks at when … Read more
SSMS only allows unlimited data for XML data. This is not the default and needs to be set in the options. One trick which might work in quite limited circumstances is simply naming the column in a special manner as below so it gets treated as XML data. DECLARE @S varchar(max) = ‘A’ SET @S … Read more