That was exactly my thinking when I started answering questions here. My thinking was that I was going to learn more by trying to figure out the answers to people's...

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/Topic850417-291-1.aspx

No need for two updates or two triggers. That's just doubling the work SQL has to do.

ALTER TRIGGER [dbo].[trAddressCreateDate] ON [dbo].[Address]

FOR INSERT, UPDATE

AS

UPDATE Address

SET Created=getdate(),

...

Defaults only apply on...

Killing a process will not cause database inconsistencies. SQL will...

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/Topic849572-338-1.aspx

Do not ever delete the log file. It's not an optional component of the database. If you delete it, there's a good chance that the DB will not come online.

Was...

The resource database on SQL 2008 is not stored with the other system databases. It's stored with the binaries, as if it were a dll or exe.

You haven't given the most important information - the SQL error log. It's just a text file, no need for SQL to be running to access it. Find the error...

talltop-969015 (1/20/2010)

---

I have gotten people fired in the past who say "it depends" all the time. Either give me a straight non-convoluted answer, or keep quiet or just say I...

No....

Please rather post new questions in new threads. Thanks

Tom Carnahan (1/19/2010)

---

Would either of you know what BOL is talking about when it says that for SS2K, the max row length is 8060 bytes? I clearly saw that by...

Use the NTEXT data type. It's stored out of row and the maximum is somewhere around 2 billion characters.

Doesn't matter what you're running it in. You are connected to a SQL 2000 server, that's why the maximum compatibility you can set is...