start from scratch !

create a new windows account with no privileges at all ( none on windows, none on sqlserver)

Then grant that account only the needed auth on your sqlserver...

btw there is a sql7/2000 version posted in this forum thread:

http://www.sqlservercentral.com/Forums/Topic512777-338-1.aspx

Vinay Thakur-585143 (12/29/2009)

---

Thanks ALZDBA,

can you please brief about:

"Maybe one of your processes keeps a permanent lock on one of your objects."

also how can be "deadlock happen" as reindex is run...

restart your rebuild index process and monitor for (dead)locking .

Maybe one of your processes keeps a permanent lock on one of your objects.

We have had such a case a long...

cfr "don't need to understand code in a object oniented programming language, just use it"

You'll still need to desing your objects, but in the cloud, you shouldn't need to worry...

Keep in mind with a trigger you can use the "inserted" and/or "deleted" objects !

You could just store that info in an audit or logging table an work it out...

With that kind of messages, I would first run a

DBCC CHECKDB

It checks the allocation and structural integrity of all the objects in the specified database.

DBCC CHECKDB ( 'database_name'...

We always perform full maintenance after any migration.

i.e.

rebuild all indexes (explicit)

exec sp_updatestats or UPDATE STATISTICS table / view WITH FULLSCAN

dbcc updateusage(0) with count_rows

Jeff's advise is indeed the best starting place.

Clustering (a/a - A/p) can be used to host clustered sqlinstances.

Load balancing isn't in scope for sqlserver yet ( I didn't check this...

I would suspect your connection isolation level to be more intrusive than the one SSMSexp uses (read committed).

What isolation level are you using ?

Indeed with 64 bit you should always set the max memory configuration or it may actually eat up all your physical ram.

IF you want to get control of processor %...

Great! You figured it out yourself AND posted the valuable feedback.

Happy holidays

With SQL2005 and higher, simply use the OUTPUT clause to be 100% sure of the value assigned to your row(s).

There are a number of articles at SSC regarding the identity...

AFAIK If the current sqlserver would have distributed databases to support your load balancing, only a single one would be in read-write state, the others would be in read-only mode...

did you try this ?

SELECT index_id

, name AS index_name

, STATS_DATE(OBJECT_ID, index_id) AS statistics_update_date

FROM sys.indexes

-- WHERE OBJECT_ID = OBJECT_ID('dbo.Objects')

order by Index_id;