Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag Management Studio (SSMS) Rss

Search for any content tagged management studio (ssms)

<< Newer    Items 21 to 40 of 52    Older >>
 

Hiding System Objects in Object Explorer in SQL Server Management Studio

While looking through the new features and improvements in SQL Server Management Studio (SSMS) we found a potentially interesting one to Hide System Objects in Object Explorer in SQL Server Management Studio. In this tip we will take a look at how to Hide System Objects in Object Explorer.  Read more...
By Additional Articles 2011/03/09 | Source: MSSQLTips.com | Category: management studio (ssms)
Rating:  Rate this |   Briefcase | 3,888 reads

RegEx-Based Finding and Replacing of Text in SSMS

So often, one sees developers doing repetitive coding in SQL Server Management Studio or Visual Studio that could be made much quicker and easier by using the Regular-Expression-based Find/Replace functionality. It is understandable, since the syntax is odd and some features are missing, but it is still worth knowing about.   Read more...
By Additional Articles 2011/02/04 | Source: SimpleTalk | Category: management studio (ssms)
Rating:  Rate this |   Briefcase | 3,483 reads

Display More Than 8000 Characters (SQL Spackle)

SQL Server MVP Jeff Moden shows us a quick and dirty bit of SQL Spackle to display the content of VARCHAR(MAX) and NVARCHAR(MAX).  Read more...
By Jeff Moden 2013/06/28 (first published: 2011/01/27) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 18,735 reads

Check that what you expected is actually what you got - DB's and SQLCMD

I feel that it is wise move for a script to actually check itself that the database connection that is...  Read more...
By Martin Catherall 2011/01/20 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,466 reads

Get script for every action in SQL Server Management Studio

I am always conscious to keep a record of all operations performed on my database servers. Operations through T-SQL in an SSMS query pane can easily be saved in query files. For table modifications through SSMS designer I have predefined setting to generate T-SQL scripts. However there are numerous database and server level tasks that I use the SSMS GUI and I would like to have a script of these changes for later reference. Examples of such actions through the SSMS GUI are backup/restore, changing compatibility level of a database, manipulating permissions, dealing with database or log files or creating/manipulating any login/user. I am looking for any way to generate T-SQL code for such actions, so that it may be kept for later reference  Read more...
By Additional Articles 2010/12/20 | Source: MSSQLTips.com | Category: management studio (ssms)
Rating:  Rate this |   Briefcase | 4,078 reads

Rebuilding Indexes using the SSMS Database Maintenance Wizard

Index fragmentation can cause problems with query performance. Indexes therefore need to be occasionally rebuilt. the Rebuild Index task of the SSMS Database Maintenance Wizard drops and rebuilds every index in a database. It is effective but an off-line activity that is resource-intensive, so it not always the best way of avoiding index fragmentation in a production database. Brad explains..  Read more...
By Brad McGehee 2010/09/06 | Source: SimpleTalk | Category: management studio (ssms)
Rating:  Rate this |   Briefcase | 3,047 reads

Import and Export Registered SQL Servers To Other Machines

I need to setup other computers the same way that are used to manage my SQL Servers. Instead of having to manually add the registered servers on each computer in this tip I show you how you can import and export registered servers between computers.  Read more...
By Additional Articles 2010/06/07 | Source: MSSQLTips.com | Category: management studio (ssms)
Rating:  Rate this |   Briefcase | 2,819 reads

Manipulating Multiple Objects in SQL Server Management Studio

Every now and then, I see someone doing repetitive tasks in SQL Server Management Studio such as dropping a stored procedure one by one when they need to remove ten or scripting out a single object at a time because they can't select multiple objects from the Object Explorer. I have even seen people create elaborate scripts to perform tasks that involved manipulating multiple database objects to avoid these mundane tasks. In this tip I will show you how this can be done simply by using SQL Server Management Studio.  Read more...
By Additional Articles 2010/01/11 | Source: MSSQLTips.com | Category: management studio (ssms)
Rating:  Rate this |   Briefcase | 5,301 reads

SQL Server Management Studio and SQL Azure

A new article from Steve Moore shows us how to use SQL Server Management Studio with your SQL Azure databases in the cloud.  Read more...
By Steve Moore 2009/12/09 | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 5,996 reads

Auto generate change scripts in SQL Server Management Studio (SSMS) for tables

This tip shows you an option that exists within SSMS to automatically generate scripts for all table changes when using the table designer.  Read more...
By Additional Articles 2009/04/14 | Source: MSSQLTips.com | Category: management studio (ssms)
Rating:  Rate this |   Briefcase | 3,018 reads

Creating and Modifying Tables in SSMS - SQL School Video

Learn how to use the SSMS GUI to modify tables in this SQL School video.  Read more...
By Andy Warren 2009/03/03 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 2,952 reads

New Features in SQL Server 2008 Management Studio – Part 2

This article is the final article in a series that explores new features that are available in SQL Server 2008 Management Studio  Read more...
By Additional Articles 2009/02/19 | Source: SQL Server Performance | Category: sql server 2008
Rating:  Rate this |   Briefcase | 3,280 reads

New Features in SQL Server 2008 Management Studio – Part 1

This article shows the new features that are available in SQL Server 2008 Management Studio   Read more...
By Additional Articles 2009/02/17 | Source: SQL Server Performance | Category: sql server 2008
Rating:  Rate this |   Briefcase | 4,776 reads

Guest Editorial: In Praise of Templates

Phil takes us through one of the best kept secrets of SSMS - Templates. Even for a 'plain-screen' man like Phil, Templates are an excellent tool, and a major reason to use SSMS.  Read more...
By Phil Factor 2009/02/06 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 251 reads

Advanced new features in SSMS 2008

SQL Server Management Studio 2008 has several new features, including the T-SQL Debugger for easier debugging and a new Object Explorer Details window that's easier to use.  Read more...
By Additional Articles 2009/01/19 | Source: SearchSQLServer | Category: sql server 2008
Rating: (not yet rated)  Rate this |   Briefcase | 3,138 reads

SQL Server Management Studio 2008: New features, part 2

SQL Server Management Studio 2008 has several new features, including the T-SQL Debugger for easier debugging and a new Object Explorer Details window that's easier to use.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 4,467 reads

SQL Server Management Studio for Beginners - SQL School Video

Learn the basics of how to work with Management Studio in this SQL School video.  Read more...
By Brian Knight 2009/01/01 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 7,494 reads

Creating a Maintenance Plan in SSMS - SQL School Video

Maintaining your database server is something every DBA or developer needs to do. This video shows how to setup a basic maintenance plan.  Read more...
By Brian Knight 2008/11/11 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 6,073 reads

Restoring a Full Database in SSMS - SQL School Video

This SQL School video will show you how to use Management Studio to restore a database in SQL Server 2005.  Read more...
By Brian Knight 2008/10/28 | Source: SQLServerCentral.com | Category: video
Rating: |  Discuss |   Briefcase | 3,839 reads

SQL Server Management Studio customized startup options

SQL Server Management Studio (SSMS) is now the primary tool that we all use to manage SQL Server. Whenever I open up SSMS I always go through the same steps to connect to a server and open certain query files. Are there any shortcuts or alternative ways of starting SSMS?  Read more...
By Additional Articles 2008/10/27 | Source: MSSQLTips.com | Category: management studio (ssms)
Rating: (not yet rated)  Rate this |   Briefcase | 4,321 reads
<< Newer    Items 21 to 40 of 52    Older >>