In this case by "context" I mean the calling application - some parts of SQL Server 2005 on X64 run 32-bit (like Visual Studio designers, parts of SSIS, ?) and...

I was going to go with monkey with a wrench in the power room...

Couple I've seen / have...

SAS/Sata/SCSI? How many physical controllers?

You aren't by any chance running on X64 are you? In that case you need to watch "context" carefully, some parts of SQL 2005 on X64 run 32-bit other...

Actually the problem is that you're specifying both SQL Server credentials and Integrated Security - Integrated Security will use the identity of the configured application pool, in your case I...

I'm sorry but I've got to ask what you're trying to say here and what relevance it has to SQL Server, all of the tips in your posting are application/IIS...

Given that we're talking about SQL 2005 there are various encryption options available to prevent exactly what the original poster was asking about - the risk that someone could get...

Ooooh fun!

Initial of thoughts - single database, not 200, files in the file system/on a shared volume or clustered shared volume, database is a pointer to the file system...

Next thought...

Get some performance counters running as well, it sounds likely that you're I/O bound (duh!). The question is whether you're overrunning your HBA(s?) or SAN. What kind of...

If you're scripting your changes manually I'd take a good look at some of the tools available from Redgate, Apex, etc. which will identify the differences between database A and...

Hmm... I wasn't aware that there's a 10 disk version of the 2900, may be but the rack mount and tower versions I've seen all take a maximum of 8...

That's a pretty broad question, when you say "server goes down" are you talking about the server physically going down, O/S halts/blue screens, SQL Server crashes, or SQL Server becomes...

You aren't by chance using Exchange server as your SMTP server are you? Exchange will ignore/rewrite reply-to/from addresses if the reply-to/from address you're using is not on the list...

You may need to upgrade to a more recent version of the Oracle drivers, MSDORA was written to support Oracle 8, you may well have run into a compatability issue...

Brandie -

Sounds like you may need to move to the Phillipines, in my younger days used to buy all kinds of things "on a stick" there and Bat was definitely...