The one I provided should stress it pretty good with read and writes. Set it for a dozen+ iterations and run several copies should slow your system down fairly good...

Got same error as you. If you are trying to stress test a system with SQL 7 or greater then you really need to use the SQL70IOStress.exe application, the one...

quote:

---

I want to transform each table or set of 120 into one (single)column for eventual exporting into a new table. The data...

This will help.

SELECT

p.name,

p.id,

p.versionid,

p.createdate

FROM

msdb..sysdtspackages p

WHERE

p.name = 'whateveryoulookforgoeshere'

ORDER BY

id,

createdate DESC

-----------------------------------------Seperate Code--------------------------------------

EXEC msdb..sp_drop_dtspackage 'Packagenamegoeshere', 'package_id_value_goes_here', 'package_versionid_goes_here'

-----------------------------------------Example Code---------------------------------------

Example I have a package "New Package" so I run

SELECT

p.name,

p.id,

p.versionid,

p.createdate

FROM

msdb..sysdtspackages p

WHERE

p.name = 'New Package'

ORDER...

Brian's right, found what I was looking for, go here http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/distsql_8lmb.asp for details. And here for some additional information http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql7/html/deploybus_depdbsol.asp.

"Don't roll your eyes at me. I will tape them in...

Yes, but it was a real pain I eventually shot in the head. Your better off using DTS due to permission issues you will run into with replication unless you...

Ok I'll try it tomorrow and see what happens and what I can figure out.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Try this, I have had some issues getting it to work but, shut down SQL server on the original bo and the new box and copy replacing all files, the...

First I believe when you perform EXEC ('anythinghere') the anythinghere part actually runs outside th scope of the current code (like it was written as a seperate unrelated piece of...

Check these to see if they fit your problem

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q310834

Or if you have AWE enabled

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q309093

Or could be a SQL 7 problem that somehow got put back in on 2000

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q276499

If none...

This KB Article should answer your question http://support.microsoft.com/default.aspx?scid=kb;en-us;Q246255

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Unfortunately Microsoft does not have anything that says V7 SP3, you have to go and get the list of release versions and compare to version string to determine.

"Don't roll your...

Where did you get this utility, sorry I cannot find?

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

I use Transactional replication on serveral DBs with SPs replicated over. Only issue is making sure all views, accounts and permissions are moved over. Also I don't replicate the constraints,...

All XP versions work just fine.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)