LOL

alen teplitsky (4/28/2010)

---

see it now

only has a modified date though. a DDL trigger will have the actual SQL of the change. we have it in the tickets opened for the...

Tom.Thomson (4/28/2010)

---

That's right.

And you got in fast there Jason, before I corrected...

And why the differential backup now? It is apparent that the tlogs are being used as the diff and loss of data is permissible.

I would consider revising the entire...

You may want to start here.

Tom.Thomson (4/28/2010)

---

The simplest way of getting a visit count is to count the number of...

I think you'll find this useful (for the sql server backup piece).

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

Please post your question here. You will get a better response in that case.

In Fortune 500's I see the number of databases and instances getting very large quite easily. I worked for one where we had ~6000 instances in production (that excludes...

You're welcome.

WayneS (4/28/2010)

---

Marv-1058651 (4/28/2010)

---

I am executing a cursor that is taking about 40 seconds to insert into a temp table. When I execute the sql as a new query, the results...

Change the following line

FROM dbo.TIMEI_DOC_HDR tdh, dbo.TIMEI_DOC_LINE tdl

To use an explicit join.

The best way is to grant the permissions to a user role. Add the user or group to that role.

D.Oc (4/28/2010)

---

I think it got something with the "DBCC Timewarp" but I leave this to...

No negative side effects. I have 2000, 2005, and 2008 installed. I will note that I prefer to use the 2008 tools though.