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.

Powershell is being built into Windows and Exchange as the admin language for systems from Microsoft. I bet that you'd find tons of people using it in other areas with...

Well, I'm lost in this thread.

I'd hope it would be a good debate, but it looks like it's gotten confused with bad feelings between participants.

At this point, I'm going to...

It's possible, but you'd need to know what type of database, have credentials, a drive or service for access, etc.

Your question kind of leaves a lot of information out. It's...

Nice list, Meredith.

Feel free to use the "report button" to let me know about misposted items. Also dups, I tend to close them out if I see them.