Solved

Running T-SQL statements in SQL Management console

Posted on 2010-08-23
1
270 Views
Last Modified: 2012-06-27
I'm using the SQL management console to have a GUI on an SQL Server 2005 database.  I would like to run some T-SQL commands eg. ALTER TABLE.... directly in a window in the GUI and see any errors generated.
How do I do it simply ?
0
Comment
Question by:AndyAinscow
1 Comment
 
LVL 10

Accepted Solution

by:
Jini Jose earned 500 total points
ID: 33501575
just press ctrl + N this will open the query analyser window
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
ASP.NET 5 Templates 2 66
Updating a table from a temp table 4 29
SQL VIEW 7 23
SSRS Dynamic Column Names - Last 8 Weeks 3 16
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now