Thanks to both you and Ramamoorthy.  After a break and some more tinkering I was able to come up with something similar to Andrew's query.  However, both work for what...

Now remember it may not have been from Enterprise Manager, you do have a T-SQL statement called "SHUTDOWN" that you can execute from Query Analyzer or you can issue it...

We have used Red-Gates SQL Backup for some time and it works great. They just release v4.0 with some new enhancements.

With our large databases, we reduced backup...

Here is a rough outline for what we have one of our clients do.

1. They click on a button on a web page.

2. This button is...

Hello Paul,

The security features are better in my opinion. It sounds to me that the person is using the addage that for a MS product you wait until the...

Been using SQL Compare and SQL Data Compare from Red-Gate for some time and really like it. Actually it saved us quite a bit of time once when our...

Also, don't forget to make sure that the domain account has the proper permission on the network drive where you are trying to write the file.

SJ

What version of DoubleTake are you using? After we switched to 4.4 most of our problems went away.

In the Connection Manager, what are your settings on the...

We also had to move a 40GB and a 25GB database over a very slow WAN connection (actually a slow VPN). We detached the database, zipped it with Winzip...

Simon is the marketing director at Red Gate. I am sure it is just a joke but it does prove a point.

If you run any native SQL...

It all depends on your business and the type of data you will be collecting. In our business, we have many instances where Unicode is necessary (nvarchar, nchar, and...

What version of MS Outlook are you using?

If you are using something other than the base Outlook 2000 version or newer, you will experience this. As I understand,...

We do something very similar for the comments for our surveys. We do a cross join with our table of bad words. Also we have a field called...

The setup program detects what OS you are using and will only allow you to install the proper tools. If you are trying to install SQL 2000 Enterprise or...

Yes, Application Roles will get around most of this behavior but are not perfect. The best way is to go with Stored Procedures.

The drawback to Application Roles...