Solution of Hans should work, but beware that you don't kill processes like cbcc checkdb and backup / restores....

Another option is to use the query governor setting (see BOL). I've...

and last but not least

(8) reserve lots of time

Hi

Before you create a clustered index, allways ask yourself -

1 - oltp or olap ?

2 - are there many range lookups?

3 - how big (datatype) is the column that...

you're lucky if you're looking for the primary key indexes... That's in the sysobjects...

JP

Hi,

Had this once myself. Turned out to be a distributed tran. Stopped and restarted ms DTC and problem solved.

hth

JP

Hi all,

Just shrinking won't do you any good. You're having the issue of the active log pointer being in the end of the transaction log file. (see my script

Ton

Almost forgot: if you have more questions: just ask.

JP

Hi,

At our company we also use Exact Software (I agree with you - this kind of software is strange!) and for backups we use the SQL Backup command, performed by...

Placing a column on a single line is easier when you're developing new queries. You can easily place a remark BEFORE the field or AFTER the field (esp. if you...

About formatting: please do write neat statements. In my job as a DBA I do a lot of DB & app optimizing and it's nice to have good formatted statements....

you're right! Got confused with vb & vbscript

JP

Hi,

You declare variables as int, which can hold 32768 as maximum number.

Declare maxID and CurentID as bigint (or numeric) and you're fine!

JP

make sure it's the only command in your batch.

hth

JP

try this:

http://www.tech-archive.net/Archive/SQL-Server/microsoft.public.sqlserver.dts/2004-06/0609.html

JP