Test this out first, have full backups handy and also make sure you run upgrade advisor before you do the upgrade.

Thanks...

You can import the packages from BI studio if there are only a few of them.

For a large number of packages, you can import the data from [msdb].[dbo].[sysssispackages] on 2005...

Being on SSC, I would say use RedGate SQL Backup, which I haven't used yet but, plan to in the future.

Quest Litespeed is one good tool too, and I...

You can query the INFORMATION_SCHEMA.TABLES view and see if there is a difference in the count which would mean tables having been dropped. Not sure if you can exactly pin...

You can export the mdb to a text file and then use BCP from Command line

Thanks..

Hawkeye_DBA (1/13/2010)

---

Please voice your opinion on the following backup strategy - I am currently reviewing this process...

Virtual Server

Disk Set Data and Logs are on SASS disks (SAN) (logical partitions E...

ZeeAtl (1/13/2010)

---

Is there a way to verify the integrity of SQL Server service startup files at startup? Make sure no modification (hacks) or other malicious changes or replacements to...

The above code from Gsquared creates a Profiler Trace at the location specified. Also, you do not have to pass any values to the variables declared.

Just change the name of...

You can read this and this to find what's new in SQL 2008

RSage (1/13/2010)

---

I didn't get it where the columns were indexed. I got that the columns were a date and a unique identifier. But perhaps the indexs for table...

What kind of errors are you getting?

OK, the article http://support.microsoft.com/kb/953200 is correct! 🙂

If you are not doing an in-place upgrade,I fail to understand how you are going to have the old databases on...

Check if the source and destination table data types are same. Also, sometimes trailing spaces or invalid characters can cause these issues and when addressed properly, you should be able...

This might help you to figure out issue

Also, check BOL for sp_repldone which might help you shrink your log

HTH...

If you were to script what a Modify column in GUI is, the you would something like below.

Alter Table MyTable

Alter Column MyColumn NewSize()

When you are done with modifying the column...