What version SQL Server? NT or Windows 2000?

And how have you tried to get SQL Agent to run the batch command?

My technical controller is pushing for us to use the SQL backup part of Veritas for our SQL Server backups, despite my demonstrating that I could do all kinds of...

Hope you have a good christmas too!

I have found this site to be excellent for getting help when you don't know what you are doing and can't find help...

To move model do the following

right click the SQL Server in EM and click properties

click on startup parameters

add new parameter -T3608

Stop SQL Server via control panel, Services

Restart SQL Server via...

Not too sure if it is the same in SQL2000, but in SQL 7 the following moves master:

Take a backup first!

right click the SQL server in Enterprise manager and click...

I totally agree, I made sure all the sa accounts on the servers I was responsible for had passwords, everyone here thought I was being a control freak, but the...

Thanks guys, I have passed the info onto our technical controller. All SQL Servers under my control do have a password for SA, but we have one that was set...

I have managed it! I did the restore and everything just fine.

The only odd thing I have is that when you look at the database information on the user...

I have come to a radical decision! The server that I am restoring from will eventually be re-used as a development machine and the replication that is set up on...

SQL Server Agent, along with MSSQLServer and MSDTC all run under a domain account QHDOMAIN\SYSSQL. I am logged in as QHDOMAIN\PGlover. Until I did the restore from the other server...

Cheers, I did it, then discovered I had to restore the database from another server which already had the dbowner as sa, so I needn't have bothered - but hey,...

Steve, Thanks for the advice, it worked fine once we had disbled the Anti virus software!

(It took a bit of persuading to get our techie to let...

Cheers, Will try that today.

We are trying to install SQL Server 7.0. The only difference between this and all other installs we have done is that this particular server has NT4.0 with service pack...

No, or maybe yes. At present, with the databases and the data files on the remote servers we can create the attachments with no problem. When we try to create...