If you don't need to show the password ever, you can use a one way hash with pwdencrypt()

http://blogs.msdn.com/lcris/archive/2007/10/31/sql-server-undocumented-password-hashing-builtins-pwdcompare-and-pwdencrypt.aspx

What is a URL box?

You haven't really explained what you are trying to do. Your subject line doesn't make sense in English and it is hard to deduce what exactly...

Moved and closed.

http://www.sqlservercentral.com/blogs/steve_jones/archive/2009/01/18/the-hassles-of-travel-part-2.aspx

You've got SQL 2005 installed, the image shows that.

I'd connect with SSMS to each instance separately (browse for them) and then run select @@version. That will show you what you...

No values there?

What SQL Server services do you see? (In the Control Panel/Admin tools/Services

Any subjects are fine. Beginner articles always get reads, nichey ones look great and make the site wider.

If there's something you see a lot, write about it. If you're interested...

Moved to administration. Please post in the appropriate forum.

You can trace this with Profiler and capture information. Once you track down the statements that are causing issues, you can look...

There are a lot of changes. Go to BOL and look at the What's New section

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

http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/

There are lots of scripts on this site (See the scripts link on the left) that you can moidfy.

I hadn't thought about the repetitive motion thing. I guess long term it could be, but for presentations, they're an hour or two. I wish I could have swiped at...

It's not quite clear what you are doing here, or how you want to use this. We also like to see you do some work, show some effort in T-sQL...

T-SQL doesn't have a way to do a conneciton. You can use T-SQL to set up a Linked server, which then you can query through, but you can't open directly...

Closed to prevent replies