I've seen something like this before. What appears to happen is that SSMS works down the list of registered servers and if it comes to a server it can't contact...

I've used a combination of these two products with great success to run backups and maintenance to schedule for Express edition:

ExpressMaint Utility: http://www.sqldbatips.com/showarticle.asp?ID=29

SQLScheduler: http://www.lazycoding.com/products.aspx

Thanks for your reply Paul. Much appreciated.

Thor is correct - use DVDs or CDs, not tape. Tape deteriorates over time. Mainframe tape libraries normally have an annual process where archive tapes are re-written to overcome this,...

I get this occasionally on new servers. When it happens I go to a command prompt or the 'run' box and type 'mmc'. Then select"Add/Remove Snapin" from the File menu....

Try this. It may not be the best way but it works:

Create table users (PK int, varchar (20))

create table roles (fk int, role varchar (20))

insert into users select 1,...

I wouldn't normally use both /PAE and /3GB. If you use /3GB you leave only 1Gb for the OS. If you are also using PAE, then out of that 1Gb...

Run OSQL from your batch file. That should do what you want.

A few other points in favour of backing up to disk ...

Everywhere I've worked as a DBA, doing backups this way neatly mirrors the departmental structure in that the DBA...

Thanks guys.

Are you still in England Steve? I'm about 50 miles from Cambridge. Great weather we're having today. Hey, it's summer!

Run OSQL (or SQLCMD) from the batch file and have it execute an SQL statement which calls sp_start_job.

A method I've used in the past to do this is to have one of the jobs have no schedule and to have a step in the other job which...

In earlier versions you can get this from the sysprocesses table but you would have to set up an agent job to query it frequently. As always caution should be...

I've got a similar issue at the moment - new to company, server sprawl, trying to get a handle on things. As a result of this thread I tried out...

Steve,

I do something very similar but find that index rebuilds done from maintenance plans change the version numbers. Do you know if there is any way round this (other than...