Yes Jack, that worked. Thanks. The table definitions etc would be huge so I'm glad we didn't need that much detail.

Thanks that sounds easier. Our project is this coming weekend and if we have to abort we'll roll back to Friday night's normal full backup. I'm actually...

In the past when creating log shipping with the wizard ( sql 2005 ) I saved the scripts, but have never tried using them. Had any luck using those...

Thanks Lynn. I have difficulty getting the resources to install sql on a test box and actually having it "exercised." Also, our systems team is not used...

If installing a sql service pack has the potential to break things, then it should be installed in Dev and tested first. Perhaps this is no longer a big...

Thanks. This makes me wonder what the percentages...

Still waiting to hear if this is only for sql 2008. Some of us are dealing with sql generated by objects, not stored procedures. Glenn Berry...

Is this only for sql 2008?

This tool demonstrates Response time analysis at the session or statement level including waitstats using the new Extended Events infrastructure in SQL Server 2008

I get a lot of requests from customer reps where they send me a spreadsheet with hundreds or thousands of values ( motor vehicle vin numbers generally ) and they...

Has sql server been restarted since the last memory configuration change?

Yes thanks that worked. I used a while loop with counter to populate a number table. Initially I only put 3000 records in it even though the length of...

32GB of memory? Have you configured AWE to use about 29GB ( leaving some for the operating system)?

First, Add the “Lock Pages in Memory” option to the account...

I may get the values in a spreadsheet or text file but was trying to avoid using any of the tools such as BCP, SSIS or the data import wizard....

John Esraelo (4/24/2009)

---

Like one of the replier indicated, backup and restore.. Or, backup, detach, copy detached to the new destination and attach.

You can not just copy the drives...

Our systems team has done this numerous times with servers that don't house sql server. Almost all are windows 2003 server OS. If this will work for sql...