The 2048 bit is what SQL Server is setting behind the scenes when you disable a trigger. So the sql is checking to make sure this is not set...

Alot of times NOT EXISTS is used to check if certain schema exists in order to avoid fatal errors when running a script. There isn't really a more efficient...

This sounds a bit scary to me... I plan on upgrading to SP2 on my cluster soon.

Did you install SP2 on the primary node first?

Are there any MDAC files on...

If you have more than one Drive or Raid array that it could be split across, then it would be worth splitting up the IO by placing it onto all...

This should work for you:

ALTER TABLE table_name DISABLE TRIGGER trigger_name

This statement should print out the commands you need to run for all active triggers in the database:

select 'ALTER TABLE '...

This should work for you:

ALTER TABLE table_name DISABLE TRIGGER trigger_name

This statement should print out the commands you need to run for all active triggers in the database:

select 'ALTER TABLE '...

I believe will only be able to use AWE if you are running Windows 2000 Advanced Server and SQL 2000 Enterprise. To allow SQL Server to allocate more than...

If you are worried about disabling functionality on other parts of your server then you could handle this programatically on each trigger. This would be an example on how...

Let me know how it goes...

I read into this when I was setting up a similar site. If you enable AWE on a box that does not have enough RAM to support it (3GB...

It sounds like there are potentially two ways to handle the situation:

A) They need to setup the IUSR Account as a guest domain account, then you can create a...

Antares,

What I was trying to say is in a full recovery model these are not redundent. If you wanted to have redundent data, then you would have to make...

This is how I would handle this... I am assuming that you can join on the empid column here... if not you should change the last statement to join...

I agree that it shouldn't cause any issues but I disagree that it's a redundant process. Running a tranlog backup before your full backup will preserve the tranlog and...

Batch file could look like this:

start isql -S servername -d databasename -U Username -P password -Q "create index index1 on table (column)" -o Index1.log

start isql -S servername -d databasename...