Nicer & no trailing ',' - why did I go down the case route!

Lets hope it works!

HTH

In EM right mouse the DB in question -> Properties -> Options Tab -> Auto Shrink.

You may need to do this on all DB's

If you make new DB's check...

something like ..

create table tblTest

(Name char(20),

state1 char(2),

state2 char(2),

state3 char(2),

state4 char(2))

insert into tblTest values ('Fred',NULL,NULL,'CA',NULL)

insert into tblTest values ('Bill',NULL,'AZ','NY',NULL)

insert into tblTest values ('Joe',NULL,'CA',NULL,'WA')

SELECT Name +

CASE WHEN State1 IS NULL THEN...

I have had big problems doing SQL backups over the wire. Sql 2000 and Win Server 2003. There was an issue with SMB (Server Message Blocks?) where it looked like...

I would just sit back and wait until you notice the laptop getting hammered and then see what/who is hitting it.

I think you want

if EXISTS (select userid from main where userid=@userid) begin -- remove 'userid'

 update statement goes here

end

else begin

 insert statement goes here

end

OK so its definately SQL. Next step would be to put a trace on through SQL Profiler and see whats running on SQL.

I think you need sp_helpdb '<your db name>'

On the Complete Backup tab there is the option 'Remove files older than ..'. this relates to retention of the Complete Backup.

This same option also appeaers on the Transaction Log...

I've not had this problem but I think you specify the retention period for the Complete Backup and Transaction Log Backup seperately. Have you set both?

I think I have seen this before when trying to backup the transaction log on a db set for simple recovery.

(slow day watching dts)

Thanks Vladen - I did'nt know that.

Tasks are stored in the system database msdb. I'm not sure how you would transfer them from one server to another other than by restoring msdb to the other server...

How do you know it's SQL?