SQL Server Management Studio Archives - Page 48 of 48

SQL SERVER – 2005 Query Editor – Microsoft SQL Server Management Studio

September 30, 2007

SQL Server Management Studio, SQL Utility

This post may be very simple for most of the users of SQL Server 2005. Earlier this year, I have received one question many times – Where is Query Analyzer in SQL Server 2005? I wrote small post about it and pointed many users to that post – SQL SERVER…

SQL SERVER – 2005 – SSMS – Enable Autogrowth Database Property

August 8, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Data Storage, SQL Server Management Studio, SQL Utility

We can use SSMS to Enable Autogrowth property of the Database. Right-click on Database click on Properties and click on Files. There will be column of Autogrowth, click on small box with three (…) dots. Reference : Pinal Dave (https://blog.sqlauthority.com)

SQL SERVER – 2005 Change Database Compatible Level – Backward Compatibility – Part 2 – Management Studio

May 31, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database Compatible Level, SQL Server Management Studio

I have received quite a few request about post I have two days ago SQL SERVER – 2005 Change Database Compatible Level – Backward Compatibility, if this can be done using SQL Server Management Studio. It is very simple to do this using Management Studio as well but I still…

SQL SERVER – 2005 – SSMS Change T-SQL Batch Separator

May 18, 2007

Pinal Dave

SQL Tips and Tricks

SQL Server, SQL Server Management Studio, SQL Utility

I recently received one big file with many T-SQL batches. It was a very big file and I was asked that this file was tested many times and it can run one transaction. I noticed the separator of the batches is not GO but it was EndBatch. I have followed two options to run the whole batch in one transaction. Let us learn how to change T-SQL Batch Separator.

SQL SERVER – 2005 Query Analyzer – Microsoft SQL SERVER Management Studio

April 23, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Management Studio, SQL Utility

Following may be very simple to some and helpful to other type of question. I have seen this in my server log as well as this has been always first question in my Developer Team. Where is SQL SERVER 2005 Query Analyzer? SQL SERVER 2005 has combined Query Analyzer and…

SQL SERVER – Query Analyzer Short Cut to display the text of Stored Procedure

January 30, 2007

Pinal Dave

SQL Tips and Tricks

SQL Server, SQL Server Management Studio, SQL Shortcut, SQL Stored Procedure

This is quick but interesting trick to display the text of Stored Procedure in the result window. Open SQL Query Analyzer >> Tools >> Customize >> Custom Tab
type sp_helptext against Ctrl+3 (or shortcut key of your choice)