A valid point, however this particular prod server is not an OLTP and doesn't have high tx throughput, although available memory and CPU are low. My main concern by using...

A valid point, however this particular prod server is not an OLTP and doesn't have high tx throughput, although available memory and CPU are low. My main concern by using...

Thanks Dave, I'm running Profiler from a different, non-prod box and connecting remotely to the target, so little resources being consumed on the prod. I'm using Profiler for ease,...

Yes, execute:

xp_cmdshell 'eventvwr.msc', no_output in a new query window.

If this fails prefix with c:\windows\system32.

Looks like the error about Firewall being an invalid object is because the script is connecting to SQL Server as a user with the wrong default database.

You need to either:

1)...

How was the SQL Server instance configured at build time? If it's using a dedicated account i.e. YOURDOMAIN\MSSQLSERVER rather than NT SERVICE\MSSQLSERVER then ensure the account is a member...

Thanks Mike, just what I was looking for. If anyone else has suggestions too they would be greatly appreciated.

Can you post the command(s) you are sending to accomplish this, please? First thoughts are that you are specifying the existing .ndf and if the DB is attached to...

Agree with other posters here but more specifically on the VS problem, it's likely because SP1 is a requirement. I've seen this from time to time, upgrading your VS...

Right, something like...

bcp myTable format myFormatFile.fmt -Sservername -T -ddbname -t, -E -k

Should create your format file, do bcp /? to take a look at all the options.

To import, something like:

bcp...

My preference would be to use bcp. Create a format file first then use the format file and put multiple bcp calls into a batch file, one for each...

I'm OK with VBScript and I know what your script is trying to do. What's the error you're receiving, please?

Maybe I'm missing something but surely you just run it as a batch or SP?

I.e.

CREATE PROCEDURE myProcedure AS

BEGIN

insert into table1 (column1, column2,column3)

select column1,column2,'0' as Column3 from...

Very good summary article with some condensed information that's useful to know - thanks! Although I'm familiar with RAID and the effect on SQL Server I didn't know that...

I've located and hosted SQL Server 6.5 with documentation, see main thread post here -> http://www.sqlservercentral.com/Forums/Forum1437-1.aspx?Update=1

As usual, thanks to everyone who went out of their way to help...