Additional advantage of implementing changes on each database is that if you expand you application for customer usage, soon some customers will host it on-site so they woul need your...

It is really very important in the regulated environment to protect data, in your case probably patient's privacy. What makes a difference is whether the web server is outside...

Or yah,

the error message that is in the original post refers to WINZIP while Jim's script says "WinZip32.exe"

Please, post the error message. If it is Integrated authentication and the message "Login Failed for User NULL" or Login Failed for User "Dude'sComputer\IamTheAdmin" then they are not logging in...

Management Studio or SQL Server installation with the client toools have to be installed on the computer for the first place.

I used WZUNZIP plug-in to WINZIP to unzip files in a batch. You have to install this plug-in from WinZIP website. It says requires version 10. I am running...

Should not be 1 and 2 and 3 ?

BOL says:

"...It applies the initial snapshot to the Subscriber and moves and reconciles incremental data changes that occur. Each merge subscription has...

I always notify my manager and I always tell the requestor that the manager will be informed. We have procedures for that.

I was surprised at the logic:

"....This link also contain CLR Triggers but they can also be a DDL trigger that is why they cannot be count under the pur DML...

I do think that the config files are the best, but a lot of people prefer DNS aliases for the server names. This way you have to make a change...

You probably have to buy the new hardware compatible with 64 bit OS, then install 64 bit Windows 2003 server, install 64 bit SQL Server software and move the databases.

@@version shows an SQL Server version.

To see the version, use sp_dbcmptlevel

If name is specified without version, the SQL Server 2005 Database Engine returns a message displaying the current compatibility...

Yah, don't post.

Just give me an outline of the main idea, you may use a "Private Message" feature

When you say Encrypted Column you mean encryption with symmetric key or something...

Brian and Dave,

these are good points and we do have SOX and FDA auditors. I am not sure they will be happy if we have uniformed SA passwords or SA...

Hi Dave,

Is there a reason you want to change passwords on 100+ servers? The password change is a unique event individual for each users.