I think T-SQL is relatively easy to read as well, once it's formatted the way I see it.

At least as easy to read as some of the C++ I've seen,

The MVP certainly isn't a ton of knowledge. It's a community contribution award.

Arguably I haven't contributed anything substantial to the SQL knowledge base in quite some time. Instead I think...

The master database controls the function of the server. It is not designed to emulate a SQL 2000 server, and all the structures in there will not necessarily work. It's...

I think you're always trying to reduce risk. Even if you want to tackle a new venture, or make a new risk in an area, you want to reduce the...

Not sure which version of risk that was. It looked liked the best picture 🙂

We have a new version here with metal horses, kind of a pain compared to the...

You are welcome. Glad it's working for you.

You can't disable trusted connections. you can disable a login, which has a status tab, but that's not the server. If you call...

Sorry, that was a 2008 link.

http://msdn.microsoft.com/en-us/library/aa905184(SQL.80).aspx

There is frustration at times, and rudeness as well (possibly together). It's part of the package when teaching.

I've been thinking about this a bit. I think that those that want...

There's a DBcreator role

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

Thanks for the update.

FYI, you cannot disable trusted authentication. You can disable SQL Authentication, but Windows is always enabled.

So you want the column names and types in T-SQL.

i.e, if I queried for metadata from the proc uspMyProc, you'd want something like

name varchar(20)

id ...

I'm guessing that you want to get only that row that corresponds to the max date.

first, I'd suggest you write using ANSI joins. That would be something like:

select A.CUST_ID,A.NAME1, B.ADDRESS1,...

I wasn't aware that the timestamp could be parsed into datetime. It's supposed to be a versioning value, not related to when something occurred. It's updated with every change to...

Are you restoring a user database? And are you restoring to the RTM level?

I wouldn't expect this, but perhaps if you're restoring a system database.

No, and why would you want to. The master contains information specific to the operation of a 2005 server.