Why no RAID 5? Are you comparing speed only to disc mirroring? Or are you comparing it to RAID 10?

I always figured that RAID 5 was...

Log in with the application on another machine then pull up Current Activity in Enterprise manager.

Look for the machine name in the list and then verify the which login is...

Do you have access to the source of the application? Can you make any modifications to the system?

I never really thought of licensing on QA. I just figured that what they were concerned with was how many of the database engine you installed.

But if it's really...

I have this setup to script ALL of my databases to text files nightly. I then zip the files and archive them. That way I have a snapshot...

Even if the data is related, unless all of the applications are hitting the same data, setup seperate databases. You can simulate having the tables in multiple databases by...

Try to setup a schedule for your job like this :

1. go into DTS

2. right click on job to schedule

3. click on Schedule Package

4. Don't make any changes to the...

My first guess off the top of head is that you have SQL Agent login account different than the SQL Server login account. I would check permissions between the...

You don't need to even have excel in the equation.

If you read BOL about BCP you will see that you can set the comma as a field delimiter and load...

The tables are small (less than 10,000 narrow rows) and the delete/insert takes less than a sec or two. I just wanted to hear that the table would be...

Do a search for BCP in Books online and you should have all the info you need.

Also a very helpful aid is to just do a Google search...

I'm not trying to do anything special inside the START command.

My command inside my procedure is:

declare @CMD CHAR(100)

SET @CMD='START DIR C:\*.* /S'

exec master..xp_cmdshell @CMD

START DIR C:\*.* /S takes about 1...

I think I have the seeds to my solution.  Thanks. 

I am still curious as to why the xp_cmdshell won't work with the START command in DOS.

Ok, how can I get a start a stored procedure in a script and not have the script wait for the stored procedure to finish before continuing?

Can't you break the sql into chunks, send each chunk and then tell it to execute through ASP?