I created a new LocalDB database from Visual Studio in my WPF project. Now I’d like to run a SQL Script to create all the tables in it. But I can’t find how I can open the database with SQL Management Studio? Is it supposed to work like an .sdf file where you can browse […]
I have installed SQL Server 2008 Management studio ONLY. When I tried connecting to my local server using Windows Authentication, I am not able to connect. I don’t remeber the instance name. How to know the instance name of my SQL Server? Secondly, i tried connecting using but there is an error: A network related […]
I recently created a few test accounts on my server and logged into them using SSMS. When I start SSMS, my default login is now one of the test accounts. How do I clear the login drop down list or reset my account as the default login username?
While doing development in SQL Server Management Studio (SSMS), I frequently want to check the properties of a number of index on a specific table from within the Object Explorer: Pulling up the index properties to see the columns included in the index, one can double-click the index name in Object Explorer, or alternatively use […]
How can I export a SQL Server database with everything related to it such as Logins/Users to use/import on another server? I think Generate Scripts… might be a good idea but what options should be set to TRUE to backup everything? or is there any other options to achieve this ?
I’ve got a fresh install of Windows Server 2008 R2 SP1 and just installed SQL Server 2008 R2, including SQL Server 2008 R2 Management Studio. When I go into Management Studio, it does NOT show the SQL Server instance that was created during setup. It only has (local) and won’t let me connect to it […]
We have a large Database (Many Table, SP, Function and…) and our database programers are over 10 person. All of theme can use the database on our main server computer or on his local system. Our requirements: we want each db programmer can apply his definitions (create table, triger, sp, fn &…) and modifications (on […]
You can turn off location in output window of SQL Server Management Studio? I can not ever find it. My language is Slovak. I want to back English 🙁
Is there a way to set the ‘available databases’ in the dropdownbox of SQL Server 2012 toolbar to a default database that you are using? I know you can use the following in the query: USE databasename GO or just select the right database in the dropdownbox, and all will be well, but sometimes if […]
When I run an SSMS command to insert data, I get this error: Msg 206, Level 16, State 2, Line 1 Operand type clash: int is incompatible with ntext What is ment by Level 16, State 2 My insert is a standard insert: insert into surveys values (18964, ‘CD9E8ACE-0D22-4969-B324-620DAFF06F97’, 19959, 486, etc etc How do […]