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
Go to Top of Page

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
Go to Top of Page
   

- Advertisement -