If you mean through exchange for example then I believe the mail account can be set to ignore incoming email.

If you mean the xp_xxxxxx  mail procs then either remove...

If you rebuild all the indexes you'll get a large transaction log, one of the downsides. - you could try putting the database into simple recovery model during the index...

hmmm .. the thought of even wider tables < grin >  guess you'll need to normalise !

so is tempdb local or on the NAS ? - I have system databases on SAN but I'm not too sure about NAS - no experience, sorry.

If you have the...

with windows 2003 I don't use the /3gb switch - 2003 handles memory without intervention - you might want to remove that statement - enable awe in sql server and...

procs called with sp_  and not qualifying owner names for objects will cause performance problems, I'm actually surpised you can see this happening, which is worrying as I can image...

Although I never had any problems with this patch I might observe that I've had a few problems with the /3gb switch enabled. I'd try using /PAE but no /3Gb...

When a procedure is run it will generate a query plan based upon the current stats ( etc ) for the underlying tables and so on. This plan is stored...

I've no idea on your error but I always do an insert using a sp as a rpc call - not sure if this is your answer?

Interesting, I ran NT4 ent servers for periods of over 6 months without problems.

I generally don't reboot servers unless forced.

as far as I remember you will need to add extra resource groups ( disks ) for the new instance and then it's just install sql.

why would you want to reboot the server anyway ?  I sort of understand that you might want to check the failover of a cluster but to generally reboot a...

you can simply replace the contents of sysxlogins and sysusers - I usually make backups of these tables as part of my DR stuff anyway.

I also have a proc to...

We did this at a company to calculate fixed expenses etc. for sales visits.  We applied a multiplication of just over 1.25 to the straight line distance to allow for...

Hmm it was a long time ago - I think the issue was that the perfmon counters had stopped working after a failover and I hadn't noticed the failover at...