I was doing something similar yesterday

UnzipCommand = "%comspec% /c Bin\7za.exe e -y  " &  File2

OBJShell.Run(UnzipCommand) ,1,TRUE

The /c after comspec tell it...

You don't say what RAID level you are running at. Generally I try to put my data on a RAID 5 and put the log on a RAID 1 (Mirrored)...

If you want to allow NULLS in a table then you need to alter the table definition to allow this. If you want to ensure the SELECT is not outputing...

Collation can be a pain. It's definateley better to chose the right collation at install time because changing it later is painfull. The default collation for a database can be...

I think the FTP task only does get, it does not do put. Thereare 3rd party FTP tasks available that support both..

Alternatively yo can use an Activex script task and...

I can think of a couple of things to check.

1. Check the file is not currently open by you or anyone else.

2. Does the Account SQL is runing under have...

Yeah - pity it's not there on the mouse menu.

You can ALTER DATABSE <DBname> SET OFFLINE

BOL recomends you use ALTER DATABASE instead of sp_dboption (supported for backward compatability).

ALTER DATABASE <DB Name> SET SINGLE_USER

I don't think you have to be in master?

I can ping that IP so it's probably coming from outside your network. On your firewall you should be blocking port 1433.

Generally when I have seen this done in repro scripts and the like you just code some INSERT statements with your fixed valuess. If you have lots of data you...

To change collation on existing tables you neeed to run ALTER TABLE statements like GilaMonster wrote.

You can generate these up from sysobjects and syscolumns.

Alternativeley you can alter collation on the...

use TOP 100 and ORDER BY DESC?

I have asked this before and never found an answer that satisfies. The best I got was from an MVP who said that essentially they are abstract and can only...

My gut feeling is to re-start SQL but that seems a bit drastic.

Anyone with a less intrusive suggestion?

- Just saw your post above - let the restore complete if...

If replication cannot be removed try taking the database offline and then try dropping it.