It just means that the connection is open but is running no queries at this point in time. It's not a problem.

Leap years are vastly overrated.

Which column(s) are the primary key of this table?

This should be easy enough to fix with some straightforward updates, but need the pk (or unique column) to identify the row....

Backup/restore, detach/attach will have the same result, a database in SQL 2008 format.

database engineer said,

that this error occurs...

Yes.

Lynn Pettis (3/15/2010)

Grant Fritchey (3/15/2010)

Lynn Pettis (3/15/2010)

Grant Fritchey (3/15/2010)

GSquared (3/15/2010)

What year? (My birthday was yesterday, so I'm curious as to...

Bad idea. Using the profiler GUI at all on a production server is a bad idea.

http://scarydba.wordpress.com/2008/12/18/profiler-research/

http://scarydba.wordpress.com/2009/10/28/snags-with-profiler-gui/

Rather use the server-side trace and save the trace to a fast local drive.

I'm going to assume you didn't read the article.... Please do so.

Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

That's a bit of a vague question. Can you be more specific as to what you're looking for? Also, is this a 24x7 uptime DB or do you have large...

By 'indexing' do you mean index creation? Rebuilding indexes? Something else?

Change the backup so it goes to a local drive, will be much faster. Once the backup has completed then copy it remotely. That should decrease the time that the...

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic882719-360-1.aspx

What error were you getting when trying to query that on SQL 2000?

That was an undocumented table and looks like it's not in SQL 2005.

You shouldn't be trying to use it anyway. Rather use one of the system views (depending what you're...