Check the ARITHABORT setting on each server/database. I bet on the one that is failing - this setting is ON.

SQL Server 2000 Standard Edition can only use a maximum of 2GB of memory (or 3GB if you enable the /3GB switch in the boot.ini).

No matter what - that is...

What this is is an...

You are welcome.

After each operation, you can issue the statement CHECKPOINT. You can review BOL at:

ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_0evalplan/html/98a80238-7409-4708-8a7d-5defd9957185.htm

Basically, when you issue a checkpoint - all dirty pages are written to disk and the...

Well, that is true - but to...

That is perfectly fine - because every one of us has been there before. :w00t:

You can start with these tables:

msdb.dbo.sysjobs

msdb.dbo.sysjobschedules

msdb.dbo.sysjobservers

msdb.dbo.sysjobsteps

msdb.dbo.sysjobstepslogs

You can use the column 'is_system_named' in the tables:

sys.default_constraints

sys.foreign_keys

sys.key_constraints

sys.check_constraints

Not sure where you can find the same thing for indexes that are not constraints. I do know that you can...

Can't say that I have seen that kind of issue before. I know this is a stupid question, but have you verified that you are connected to the right...

I'm sorry for being a bit dense - but,...

Grant Fritchey (12/9/2008)

---

Instead of shrinking the database at the beginning of the process, I'd suggest growing the log out to the necessary size and making sure that it's cleaned out...

ISNULL (or COALESCE) is only required if the columns allow nulls. If the columns do not allow nulls, then you don't need it. For a column that contains...

Alan Vogan (12/9/2008)

---

Good morning,

I'm running a similar script and yes, it is WAY better to write your own optimizations. How do you handle the exception when the index contains one...

Jerry Hung (12/9/2008)

---

It will work for SQL 2005 as well if we change

Select db_name()

,object_name(s.object_id) As ObjectName

--,object_schema_name(s.object_id)...