Here's a script I use for RC4 encryption....

for what its worth....I don't remember where I even got....maybe it will be useful for you.

If Exists (Select * From sysobjects Where name...

With a little planning, and fiber connections only, I've seen it done in an active/active configuration and work well. Network bandwidth became the biggest issue, but was addressed by creating...

I wouldn't say a major cost, but yes there is some cost associated with the connection. We use LMhosts (rather than DNS or Wins) and sql authentication (rather than Windows...

I have a similar situation where I recieve a lot of excel files from remote offices and needed to import them.

I created a proc to walk a directory and dynamically...

I experienced the same issue on a couple of different servers I've worked with. The answer we came up with was setting up linked servers to attatch to a SqlNet...

Placing the dynamic sql in a variable is fine if the dynamic sql is short enough to fit. If you need to be able to execute longer Sql than Nvarchar...

I have a lot of scripts that perform functions such as zipping or rar'ing files and then deleting the old files after verification.

The answer from Greg above would be the...

We alias Server Connections where I work, as we have Dev, Stage, QA, and Prod enviroments. It works well for us, and provides consistency throughout all coding for the databases,...