actually i got it finally

by changing the status, mode and category in the sysdatabases table

quote:

---

Have you used Enterprise Manager and looked...

sorry guys that sp i use all the time but that creates the passwords and users. If the user already exists with database rights

Example:

John doe password hello

initially

set to john...

right idea but needs category set to 0 and mode set to 0 that work

thanks

quote:

---

You may be able to modify the STATUS...

that took it out of loading but now it cant be dropped because of replication and when you try to drop replication it says cant because it is loading

Actually that is what i thought too, but the particular app only uses the select statement

once and locks up. The database it is on is only .5 gb altogether....

are your jobs using xp_sendmail

if you are sending mail and the mail server or job fails you must reboot the server in order for the jobs to work again

There is an article about this on the knowledge base. Basically you cannot kill a job that is sending email if the eamil is where it died. Since that...

restore database with recovery takes care of it

I have called microsoft about a similar situation. In my situation the SQLSERVER AGENT login name does not have rights on the other domain. I generally get around...

I use linked servers to manage my other servers. You can use linked servers on one server to run sp' into a local temp table

Most SP's will allow you...

when i find the spid that is blocking all others this is the networkio is the lastwaittype. And the enduser is actually waiting. So it comes from sysprocesses

quote:

---

where are you getting this information? profiler?

---

I have done something very similiar setting up a staging server. I know where the backups are but not what they are called.

use xp_cmdshell 'dir c:\filename*.*'

SET @sqlcmd='master..xp_cmdshell '+char(39)+'dir \\'+@primary_server+'\backup\*.bak...

DTS is the most user friendly but you need to make sure you take care of rights, indexes and such. If it is an empty table you can script...

i talked to the vendor about pricing and for over the wan it is very reasonable. As for the disk space the documentations says three times the size of...