What about for migrating data from an old database into a new database? If a cursor is not the best solution, please by all means let me know what is....

Mark Markov (2/28/2008)

Jeff Moden (2/28/2008)

I suspect they're really meant to find out if you actually know SQL...

Awesome!

If I were you I would add the package to the project as a test. You can always remove it later, and cleanup the directory the project is in. I...

Wow! That was a pretty accurate re-cap up to the last part. My setup is the following:

Active Directory server hosting CRM as well as the reports. CRM automatically installed RS...

PS - the dbcc checkdb does not return any errors.

Ok.. well now youve scared the frik out of me. I did not know what else to do! The database was modified when we tried to do the reportingservices upgrade...

Today has just been hell... I have not ran that. I actually stumbled onto what looks like it may be at least part of the issue, but I have restarted...