One last thing I'm having problems with... When I try to create my SELECT statement into a stored procedure, it gives me an incorrect syntax error. Is there...

Ok, I was able to get it to work using the FOR XML EXPLICIT clause. Everything I read said to name the column as [marker!1!infowindow!cdata], but I couldn't get...

Thanks for the replies. Yes, it was an all or nothing deal. I changed it to an INSTEAD OF INSERT trigger which first verified the record, then inserted...

It will prompt you, just select the SQL 2000 instance during the setup wizard. Before you upgrade, back up everything and make sure your upgrade path is supported. ...

Your SQL 2000 databases are upgraded automatically if you upgrade the SQL 2000 instance. If you opt to install a SQL 2005 instance from scratch, you can either attach...

Thanks so much for all help, DB_Andrew. Both the Open XML and XQuery methods work perfectly.

I didn't know the procedure call took such a significant fraction of...

Thanks to everyone for all of the helpful information. Here's where my situation stands:

The problem turned out to be with the stored proc that called the views, not with...

I was able to resolve the consistency errors, but I had to jump through a few hoops to do it. My problem was a few entries in sys.columns were...

We already take daily backups from the primary, but our disaster recovery site is 700 miles away. I'm just looking for an extra layer of redundancy just in case...

DBCC CHECKTABLE on dtproperties returns the error:

Server: Msg 2501, Level 16, State 1, Line 1

Could not find a table or object named 'dtproperties'. Check sysobjects.

However, sysobjects returns a valid record...

Yes, we're going to need to update the data as well.  How would you set up staging tables in DTS? 

Thanks again for all the help everyone.

Duplicate data.  I have a single database with data that will be gradually migrated to a new database.  I need to continually migrate all of the data from the original...