How to show more verbose information when running

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

How to show more verbose information when running

Author

Topic

jadeite100
Starting Member

5 Posts

Posted - 2010-08-27 : 13:04:21

Hi All:

I am using Microsoft Sql 2005. I ran my ddl scripts in "Microsoft SQL Server Management Studio" and when the script
is completed and successfull, all I get is the following messages:

If DBCC printed error messages, contact your system administrator.

Is there a way to ask "Microsoft SQL Server Management Studio" to show more information or verbose?

Yours,

Frustrated.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-08-27 : 13:24:42

What DBCC command did you run in the script?

You would add PRINT statements to your script if you want output to be returned. The fact that nothing was returned except that message means it completed successfully.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources