Tag: ssms

How can I view full SQL Job History?

In SQL Server Management Studio, when I “View History” for a SQL Job, I’m only shown the last 50 executions of the Job. How can I view a full log of every execution of a SQL Job since it was created on the server?

How do I get SQL Server Management Studio to stop processing on an error?

This seems like an incredibly dumb question to have to ask, but how do I get SQL Server Management Studio to stop processing a SQL script when it encounters an error? I have a long script and if there is an error at the start SSMS reports it and then blindly carries on, screwing up […]

SQL Server Management Studio – using multiple filters in table list?

In Management Studio, you can right click on the tables group to create a filter for the table list. Has anyone figured out a way to include multiple tables in the filter? For example, I’d like all tables with “br_*” and “tbl_*” to show up. Anyone know how to do this?

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 Table1 { ID int, — Primary Key Table2ID int, — Refers to Table2’s ID } Table2 { ID int, — Primary Key SomeData nvarchar(50) } I am adding a foreign key to Table1 by Right […]

How to view the stored procedure code in SQL Server Management Studio

I am new to SQL Server. I am logged into my database through SQL Server Management Studio. I have a list of stored procedures. How do I view the stored procedure code? Right clicking on the stored procedure does not have any option like view contents of stored procedure. Thanks.

Error Invalid prefix or suffix characters in SQL Server Management Studio

When I try to edit table data in SQL Server Management Studio 2008 R2 (right click in table object, Edit Top 200 rows) I receive this error: “Invalid prefix or suffix characters. (MS Visual Database Tools)”.

Sql Server Management Studio Object Explorer dissapeared – missing – vanished

The SQL Server Management Studio Object Explorer menu disappeared. The shortcut F8 and the view->object explorer method neither do anything. I have clicked everything on the keyboard, googled around, but nothing… I really need this back, its a massive hassle having to navigate through the summary window without the object explorer tree view!

Why can't I find SQL Server Management Studio after installation?

So I downloaded Microsoft SQL Server 2008 R2 on a new computer I have to be using and when I go to Start -> Programs -> Microsoft SQL Server 2008 R2 I don’t see SQL Server Management Studio. I followed the step by step installation and configuration. Why can’t I find the program? What am […]

Quick way to grant Exec permissions to DB role for many stored procs

Consider the scenario where a database has a SQL Database Role or Application Role. The task is to grant Execute permissions to n stored procedures. When using SQL Management Studio, there’s a nice screen to help apply permissions to objects for a Role. SQL Management Studio http://i26.tinypic.com/2r5g6c3.png Here are the steps to apply permissions: select […]

SQL Server Management Studio won't let me add an index to a table

When I right click on the indexes folder in the table the “New Index” menu item is grayed out. I don’t understand why. I’ve deleted all data in the table just in case, and refreshed and restarted SSMS, but no luck. I’m using SQL Server 2012 Business Intelligence SP1 CTP.

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