I can't imagine of having 0 downtime for migrating from server A to server B.  There are ways in which we could pull disk out from the array and have...

Just a silly though, have you try to reboot it? 

mom

I wonder if it takes the copy of your model database. 

mom

you could change dbo to sa for a moment and then clean out the other user.

sp_changedbowner 'sa'

after this is done, check your user by querying sysusers table.

You could delete that...

If you continue to have that problem it is probably best to rebuild your server.

mom

I got it.  incase you are lost like me, here it is.

SQL Server Management Studio->object explorer->server->management->database mail->right click to "Configure database Mail"

mom

attach the database to the new server and you should be able to use them.

mom

your sql server service account.

mom

This is a strange, I don't think anybody or job could beable to set database user mode while there are lots of connection open.  You could change it only when...

This is very strange... Why would you want to give permission to a login who has no permission to start a job that was owned by sa?

If it is own...

sorry I am not a vb person, but do you know that you could do exec master..xp_readerrorlog to read your current log

you could even specify if you want to read...

I though I got the same error as well when we rename 7.0 server.  We fixed it by runing setup again on this server but it doesn't do the full...

To my though, there is no magic that makes it works.  I think you or your coleage accidently re-import the data without knowing it or similiar effect.

mom

Tell him to create table like create table dbo.tablename

osql -SServername  -ddatabaseName -Q" create table dbo.tablename ..." -E

it should work fine.

mom

We have a database that keeps track of servers, databases and anything we want for monitoring and reporting purposes.  We don't have front end support though, but since it is...