Paul,

Well that would certainly be one way to do it. Thanks

Thanks for the suggestion but do you know if there is an equivelant syntax that shows all the servers on...

Michael Valentine Jones (1/31/2011)

---

I go with "Don't ask, don't tell".

We have about 300 instances of SQL Server Express/MSDE/etc. that I know of, so I just leave them alone.

I have enough...

GSquared (1/27/2011)

---

Like Gail, I'd be inclined to split the triggers up. SQL Server will want to have execution plans for them, and multiple internal branches generally result in expensive...

Thanks for clarifying that Gail for I did have it partially wrong; good to know.

That said I just now have to hope that the explcit setting of these fields to...

Elliott Whitlow (1/27/2011)

---

GilaMonster (1/27/2011)

---

Elliott Whitlow (1/27/2011)

---

I am torn on whether it is the apps job to fill in these fields in the first place. I'd end up with triggers...

GilaMonster (1/27/2011)

---

Elliott Whitlow (1/27/2011)

---

I am torn on whether it is the apps job to fill in these fields in the first place. I'd end up with triggers to make...

Well the AFTER INSERT/UPDATE actions will both plug in a date/time value in the Inserted/added row when the field that holds the date/time is left NULL.

The table in...

Somehow I missed this one when it first came around and so I'm more than a month late to the debate.

There's not much truer then what Steve said in this...

GilaMonster (1/25/2011)

---

If you're doing...

Sevral have made good ponts about how daily reboots requires the recompiling of plans and loss of other data and i had not thought about that since its been like...

Thanks for the tip. I do wish Microsoft would provide more T-SQL like options for this kind of thing though. I know the 'sp_msForEachDB' and 'sp_msForEachTable' are popular...

UPDATE:

This finally worked. Let me finsih so the peopl can get backj to using this DB/server and I will follow up with more on what went wrong.

Thanks

No need for...

David Benoit (12/3/2010)

---

So I am assuming if you just try connecting to the server using the following that OSQL will not work?

D:\MSSQL\Binn>osql -SYourServer -E

If it does, can you run...