Error Message - SQL Server Forums

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

Error Message

Author

Topic

ett9300
Starting Member

12 Posts

Posted - 2011-04-04 : 16:22:07

We are running SQL 2000. In Query Analyzer, We got this error message when we ran this query "DBCC SHRINKDATABASE databasename

Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'database name'

Do you have any suggestions how to fix this error message?

Thanks.

Diane

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-04-04 : 16:26:19

Well you have to fix the syntax. Here's an example of the syntax which I grabbed directly from Books Online:

DBCC SHRINKDATABASE (UserDB, 10);
GO

But why do you want to shrink it? Do you really it could cause more problems than what you are trying to solve?

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

Subscribe to my blog

ett9300
Starting Member

12 Posts

Posted - 2011-04-04 : 17:36:15

Thanks for your prompt response and information, Tara. Your suggestions work!!!. I won't shrink the database per your suggestions.

Thanks again.

Diane

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources