sqlguru (7/9/2009)

---

It was an example.

Also, primary key values should be non-volatile. Actually, they shouldn't change at all once...

Problem is that datetime2 is not a recognized data type in SQL Server 2005. That pushes the conversion to SQL Server 2008 side.

Jack Corbett (7/9/2009)

---

Lynn Pettis (7/9/2009)

---

Unless you have a field that tracks the order that records are inserted )and is used to help order) and the columns you are sorting on...

Try the attached code. Once again, I can't seem to post the code directly in this thread.

Okay, I saw this earlier this morning before I left for work, and I want to give them a shot, then I will look (Q1 and Q3) to see if...

Sorry, I'll fix that. It should have been sample. Guess there was a little issue between the chair and keyboard.

We had them out to do on-site training last year on SQL Server 2005. Can't say I was that impressed. Most of what was covered in the class...

A startup stored procedure. You can create a stored procedure in the master database and set it to run on startup.

You should be able to find thin in BOL.

Running a server side trace is not too intrusive, depending on what you are capturing and can be left running while SQL Server is up and running. Using Profiler,...

Sounds good, no hurry.

The points showing in forum posts is accurate where as the points on the Member scores and standings page are inaccurate. Will these be properly synced?

Unless you have a field that tracks the order that records are inserted )and is used to help order) and the columns you are sorting on are duplicates, there is...

Being based on SharePoint should actually make it browser independent, at least that is one of the things I got out of our training a couple of weeks ago.

I'll check...

I'd look at building a view over the code table in SQL Server 2008 that casts the dates from a datetime2 value to a datetime value, then use that view...

Try running this command where is the path (without the angle brackets but possibly double quoutes if there are spaces in any of the directory names) to your backup...