Tag: ssms

SQL LocalDB Open in SQL Mgmt Studio Run Script

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 […]

SQL Server Management Studio cannot connect using Windows Authentication

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 […]

SQL Server 2008 R2 SSMS Default Login Username

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?

SQL Server Management – Index propertiers keyboard shortcut?

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 […]

Export SQL Server database with everything related to it such as logins

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 ?

SQL Server 2008 Management Studio Not Showing Database

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 […]

How can i get all my sql server managment studio activite on my database as a executable tsql log?

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 […]

SSMS localized output windows – not be turned off

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 🙁

How to set 'available databases' to a default one that you are using?

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 […]

Understanding SSMS error messages, regarding an INSERT error:

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 […]

MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.