Top "Ssms" questions

Microsoft SQL Server Management Studio is a graphical tool for configuring, managing, and administering all components within Microsoft SQL Server.

How to connect to LocalDb

I installed LocalDb using the SqlLocalDb.msi package and I can connect to it using SSMS using the server name (…

ssms localdb
How to type a new line character in SQL Server Management Studio

In the "datagrid" view of an open table of data, how can I type a new line character into an …

sql-server character-encoding ssms
How to see the values of a table variable at debug time in T-SQL?

Can we see the values (rows and cells) in a table valued variable in SQL Server Management Studio (SSMS) during …

sql debugging ssms table-variable
How to edit one specific row in Microsoft SQL Server Management Studio 2008?

In Microsoft SQL Server Management Studio 2008, is there a secret to be able to edit one row based on a …

sql-server-2008 ssms
Convert SSMS .rpt output file to .txt/.csv

I want to export my big SSMS (SQL Server Management Studio) query result (2.5m lines, 9 fields) as .csv or comma-delimited .…

sql-server sql-server-2005 character-encoding ssms rpt
How get the T-SQL code to find duplicates?

MS Access has a button to generate sql code for finding duplicated rows. I don't know if SQL Server 2005/2008 Managment …

sql-server-2005 tsql ssms
SQL Server Management Studio - adding foreign key confusing?

I always find it confusing to add foreign keys to primary table in Management Studio. Lets say I have a …

sql sql-server ssms
Management Studio default file save location

Open a new query window. Write some SQL. Save the script, the Save File As dialog box opens - but …

sql-server ssms
How can I automate the "generate scripts" task in SQL Server Management Studio 2008?

I'd like to automate the script generation in SQL Server Management Studio 2008. Right now what I do is : Right click …

sql-server visual-studio-2008 automation ssms sql-server-2008
SQL Server. How to refresh the intellisense?

Possible Duplicate: Lost the IntelliSense SQL Server 2008 Intellisense problem I'm new to SQL Server, so this is probably an easy …

sql-server sql-server-2008 ssms