Not sure, if this will help you, but do a search on my site for "Windows XP". That is the textbox in the upper right corner close to the date....

You can also have a look here:

http://www.microsoft.com/technet/community/scriptcenter/user/default.mspx

Not sure if they have your script there, however this should save from reinventing the wheel anew, when it is unnecessary.

http://www.yohz.com is worth a visit.

Storing a password in a table, isn't the best solution, IMO. however, if you need to, consider doing the encryption at the application level. Can find the thread right now, but...

Speaking for myself:

I committed myself to do the MCDBA this year. My employer will sponsor this. I think it's not that expensive. Just about $150 per exams, when I remember...

To read this from one person whose postings here and on the newsgroups I really appreciate makes me kinda proud!

Thank you, Adam!

That's interesting. Thanks for answering!

Please refrain from posting the same question multiple times here!

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=161542

First of all, welcome on board here!

Now, please do a search in the fora here. You've asked a FAQ that has been discussed...

I'm not sure if I understand you, but see if this goes in your direction:

http://www.sqlservercentral.com/columnists/mcurnutt/datadictionaryfromwithinsqlserver2000.asp

I bet you'll also find something ehre in the script section. Finally here is script...

Just for the records: You can also use SET ROWCOUNT to limit the resultset. You can also use this with a variable.

I bet you'll find something useful here in the script section.

http://www.sommarskog.se/arrays-in-sql.html is really worth reading on this topic.

See if this helps

http://www.sommarskog.se/error-handling-II.html

http://www.sommarskog.se/error-handling-I.html

If you are planning to move upward in your company - to become one of the DBAs

Just out of curiosity: Does this mean, that a DBA is higher ranked...