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.
| Author |
Topic |
|
jung1975
Aged Yak Warrior
503 Posts |
 Posted - 2005-08-29 : 12:33:22
|
| When I run sp_helpdb command to see the size of each database, I keep getting error says:Server: Msg 515, Level 16, State 2, Procedure sp_helpdb, Line 53Cannot insert the value NULL into column 'owner', table 'tempdb.dbo.#spdbdesc___________________________________________________________________________________________________________000100004225'; column does not allow nulls. INSERT fails.The statement has been terminated.Do I have to have a DB owner privilage to run this command? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-08-29 : 13:22:03
|
From SQL Server Books Online for sp_helpdb:quote:
PermissionsExecute permissions default to the public role.sp_helpdb must access the database(s) on the server to determine the information to be displayed about the database. Therefore, for each database on the server, one of these must apply: The user executing sp_helpdb must have permissions to access the database.The guest user account must exist in the database. If a database cannot be accessed, sp_helpdb displays error message 15622 and as much information about the database as it can
So you probably don't have access to one of the databases.Tara |
 |
|
|
|
|
|
sp_helpdb error