January 15, 2007 at 10:29 am
hi i am trying to run this
USE master
GO
EXEC sp_helpdb
in my sql server master database but i keep getting this error message...
Server: Msg 515, Level 16, State 2, Procedure sp_helpdb, Line 53
Cannot insert the value NULL into column '', table ''; column does not allow nulls. INSERT fails.
The statement has been terminated.
any ideas why?
January 15, 2007 at 11:46 am
Odd error.
What happens if you run the select at line 53?
DECLARE @dbname sysname
SET @dbname=NULL
select name, suser_sname(sid), convert(nvarchar(11), crdate),
dbid, cmptlevel from master.dbo.sysdatabases
where (@dbname is null or name = @dbname)
Which servicepack does the server have?
January 16, 2007 at 8:22 am
thank you for your help!!! ok so i run your code and for some databases in the columns that saays (no column name) only for a couple i have null. we recently changed the domain, so we recreated all our logins in sql server... humm maybe this is the problem?
so i used this code to add owners to all my databases...
sp_changedbowner 'new owner'
and now when i right click on the database, the owner does come out.
question when i changed the owner , when i go to security in em , logings and go to the user i added as owner and i check in the databases tab , in the tab it says dbo as the name of the user instead of the user's name. when i click on the row then i get the error message 15405:cannot use the reserved user or role name 'dbo'... then i changed the owner to sa and it works fine. .. but i don't want the owner to be sa... am i missing something i run the code sp_changedowner?
January 16, 2007 at 10:06 am
The securitydescriptors in master can be out of sync with a restored database. If you look in a database the login for a certain user is Null instead of user...
I don't have the url at hand, will try to post it later.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy