It just is another bullet point on a long list proving that relying on 'implicit' conversions (sloppy coding) will always get you in the end.

We have instituted the defaults across the board initially. Now on SQL we've set overrides to initiate notifications at the 'Warning' level for starters. It seems that what MOM considers...

What 'Recovery Model' are you using ?

If you are using 'Full', do you have a Maintenance Plan to backup the transaction log at a regular interval (somwhere in the neighborhood...

Just curious as to ...

1) How big is the database backup ?

2) Why the aversion to a network copy of the backup ?

Good day. We have had MOM 2005 implemented for around 2-3 months now (still working out the finer points of events and such). Our setup is a separate application server,...

I've a mixed environment here as well. Servers are Win2K SP3, MDAC 2.6 and 2.8; Win2KSP4 MDAC 2.6 and 2.8; and Win2K3 MDAC 2.8. My client is Win2K3 Server, MDAC 2.8;...

Below is the query executed locally in QA:

exec master.dbo.xp_cmdshell '"C:\Program Files\Support Tools\setspn.exe"'

and the resulting output from a remote production server:

output                                                          

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

Usage: C:\Program Files\Resource Kit\setspn.exe [switches data]

  Where "computername" can be the...

I run 2K3 server on my desktop with 2 local named sql instances. I will install the setspn utility on a remote server and re-execute just to verify things for...

two things:

1) double quotes since the directory path needs spaces.

(your installation path may be different)

2) .exe at the end of setspn

Here's an example and it's output from QA

exec master.dbo.xp_cmdshell...

There are ETL products available out there ... many are budget busters (expensive). In the past I have used a product called Informatica.

I believe that '[' + @servername + ']' is what you are looking for. This will handle named instances for you in your script.

Are you using dual paths (2 fiber channel HBA's) ? Talk to your SAN Admin and have him check the SAN performance stats. Ask him about blocksize (the term changes...

All of my servers are up to hot fix 818 ... here's the link ...

http://www.microsoft.com/downloads/details.aspx?FamilyID=9814AE9D-BD44-40C5-ADD3-B8C99618E68D&displaylang=en

Just to add to the fun here ... Try this little code snippet in QA ... it's totally self contained ...

set nocount on

go

declare @gender char(1)

select @gender='F'

---

--- this looks like a...

To minumize hardware 'waste' due to clustering we do the following:

Primary node --> HP DL-580, Quad CPU, 4 Gb RAM

Secondary node --> HP DL-380, Dual CPU, 4 Gb RAM

The thought...