Stupid question here :

What happens when a row is deleted or when the previous row is updated??

How do you propagate the changes to the next row?

This link might be usefull to you.

Dynamic Search Conditions in T-SQL

What are you trying to do exactly?

Thanx for clarifying... good thing this wasn't started in the newbie forum .

Thanks.

At school I had :

ms sql server

mysql

vb6

vb net

office

php

msdn

+15 more I forget

never had a problem

Is to grant create foreign keys access only or the users can do more than that with this?

and what??

Did you try?

Are you having problems doing that?

I don't see why they couldn't work together (assuming it's a testing/dev environement... an sql server should be use just for that).

Can you post the trigger code?

Looks like you are deleting rows from the same table in the said trigger and that it is being refired everytime.

backup msdb and restore it to the new server.

Exists is not a subquery, it only returns true or false, so no data ia actually fecthed from the clustered index (besides the minimum it takes to make sure you...

Yup... but that's almost a given, I guess ?!?!

Can you tell us what those questions are.

I think this is more readable.. especially if you have only 1 pinned table out of 3000 .

SELECT id, name, OBJECTPROPERTY(id, 'TableIsPinned') Pinned

FROM dbo.sysobjects

WHERE XType...

"As a rule of thumb: 80% of the performance improvement can be reached by TSQL tuning (right SQL, table, index design) and only 80% by HW tuning."

Did you mean 20%...

It can be done... but it's the job of the presentation layer.

Just declare a int and increment it in the while not MyRs.EOF() and format using that variable.