Please provide sample data.

Also needed is an example showing what your desired result should look like.

http://msdn.microsoft.com/en-us/library/ms187928.aspx

You can do it - but data can be truncated, only partially displayed, or an error returned because the result is too short to display. Use the link provided...

Alvin Ramard (2/13/2010)

---

CirquedeSQLeil...

For tempdb structure, check Kimberly Tripps article in my sig below. She has a few articles that are helpful in that area.

Try using OBJECT_Name(object_id)

or you could join back to sys.objects for the table name.

I bet you could find a youtube video of one 😀

Tim Januario-145496 (2/13/2010)

---

Based on the name of your column and the name of your table, this sounds like it should probably be the primary key. If it is, and...

The restore will take longer. A restore will "zero" out the data file and grow it if necessary. Due to this kind of IO it should take longer...

lmu92 (2/13/2010)

---

Under the "given circumstances" (XXI. Olympic Winter Games...

Utilities

As in utility companies need real dba's.

The thread needs redirection.

Please no more plumbing in the thread.

Or do you mean:

How to get alerted when SQL Server is restarted?

When do the tickets go on sale? I would like to attend.

When I registered, the price was under 1k and it was listed as being 1900 (they said 50% off).

I would look especially to the networking. The information is good,...

Thanks