Yikes, haven't worried about stdin or stdout in years.

I like being a specialist. It's been good to me (and profitable), but it certainly has helped to be a generalist overall...

There are definitely some strange behaviors in 8.0 mode. Andy Warren reported a few issues with some 9.0 features "bleeding" through into the dbs when in 8.0 mode. I...

Very strange.

Are you sure the data is the same? How have you verified? I don't mean to be difficult, but "test" environments often are shared and I've seen people change...

You'd think they'd make it easy. I had to double check, too 😉

Log size is a good indication because this data is what's being sent by database mirroring.

However it's sent as it's written to the primary log, so if you have...

TJ,

Old Hand is a rating based on posts, not the name. The name is above that in bold, so it's Adam you were responding to.

Second, RAM isn't related to...

The SQL Server name needs to match the Windows server name.

Sp_dropserver

go

sp_addserver (new name), local

will fix the naming. For clients, they'll need to repoint to the new name unless they are...

You definitely have to get along and share information to get things to work smoothly.

But I'll disagree with you. Social activities are a way to do team building, not just...

You need to install the SQL Server services. If this is 2005, then you need to install the Developer Edition, Workgroup edition, or Express edition. You will have a SQL...

I agree with Andras that it looks ok from a code perspective, but I'd format it to make it read a little better.

I'd do it like this:

CREATE TRIGGER [Prorogation] ON...

I think my generalist mistake in sticking this in the author discussion and not the editorials messed up some of the discussion 😛

How many people know how to redirect output...

Actually, CHECKDB should include CHECKCATALOG and CHECKALLOC.

NEWALLOC is included for backwards compatability and is the same as CHECKALLOC.

http://msdn2.microsoft.com/en-us/library/aa258278(SQL.80).aspx

http://msdn2.microsoft.com/en-us/library/aa258809(SQL.80).aspx

You can open the Structured Storage file in Notepad Or Visual Studio. It's just text, VB code. Look through it and you should figure it out.

However, if it only fails...

Don't forget to send a video in 🙂

We'll use Popcorn in the editorial one morning! Don't worry Popcorn, it's painless!

Building in formatting, like carriage returns, is a horrible use of SQL Server resources. You're asking for a lot of work from a limited, shared resource. As mentioned above, whatever...