I recently went through a test of exactly this configuration. SQL Server on Windows 2003 on VMWare ESX running on a blade, with SAN disk support.

I ran into many odd...

I'm doing a 'roll your own' log shipping. A WMI/Javascript program backs up the logs every 10 minutes and restores them onto the standby server automatically. I'm also taking...

Thanks, Remi and Steve! Mystery solved.

Steve G.

Nope. They all had the name of the table prefixed with a lower case 't'. Did a little more digging and found that the script actually pulled out about 30...

I was checking this script out (really neat script btw!) and came accross something odd. Of the 4 indexes that were called out as needing to be rebuilt, 2 of...

If you have a column ID that is a unique row identifier (either through identity/rowguid/your own algorithm) you can get rid of duplicates by doing something like:

----------------------------------------------

create table duptest

(

id...

Do the "External" machines all fall within the same IP range? (Most VPN devices work this way, but ya never know...)

Steve G.

Have you tried the following?

In Enterprise Manager, select "Management" -> "SQLServerAgent" -> "Jobs", then right-click on the job to get the pop-up menu and select "View Job History". When the...

SueB - you're absolutely right. The "ECHO" statements start a hidden CMD process, waiting on your response. I.e. it hangs up if you uncomment out the "Echo" statements and run...

1) Open Enterprise Mangler, navigate through Management->SQL Server Agent->Jobs and locate your failed job.

2) Right click on the failed job, and select "View Job History ..."

3) In the Job History...

We're in exactly the same boat. We're a Lotus Notes shop, and I'm not allowed to install windows email clients on our server. To get around this, we use a...