You are welcome and thanks for the kind words.

Steve

There are arguments either way. It's obfuscation at best, and will fool some automated tools. If you expose to the Internet, I'd do it.

Internally, easy for someone to port scan...

I somewhat like the solution above, but honestly this is something you'll run periodically to check on space, files, sizes, etc.

I'd schedule this to run on each server, make it...

Not sure if this is still true, but once I had edited maintenance plans in pre-SP2 servers with SSIS, I couldn't open them in the maintenance plan designed and had...

Thanks for the update and glad things are working.

As an FYI, auto close isn't recommended in production because it causes delays when accessing the database. Typically the resource savings isn't...

sp_change_users_login is a way to sync logins to users.

If you are moving databases, typically you move the logins once, then each time you restore, you might have to re-sync things.

I might agree the question is vaguely worded, but arguing that once you supply a seed you don't have to supply one the second time seems nitpicking.

Also, getting multiple records...

Exams are given at Prometric or VUE testing centers. There's no real difference between them.

Why would adding a select or a parameter seem like a bad idea? Does the extended property somehow imply less resources are used? It's likely a select in and of...

Please don't cross post.

Discussed here: http://www.sqlservercentral.com/Forums/Topic541955-146-1.aspx

You'd have to use firewalls/routers to handle this at a network level. I'm not sure that SQL Server can do anything here. hostname/IP can be easily spoofed.

Can you explain what you are trying to do or what your scenario is?

This seems like an interview or test question. Please show some effort to work on the problem...

Good explanation. OLEDB is newer and superceeds ODBC. You should aim to use OLEDB connections where possible. I believe there's an OLEDB provider that encapsulates all ODBC functionality.

SP2 had changes to maintenance plans, and I believe removed the need for SSIS to be installed on the server. However both the client and the server need to be...

I believe the Microsoft touted that in some early marketing for SQL 7. I've have to go research the exact wordings, but I had a lot of friends asking me...