Thanks, i tried doing that, it works perfectly, it only gives error once it is inside a trigger, thats what it confusing me 🙂

There are 10 indices out of which one is clustered, no trigger, does this affect deleting???

there is also s discussion going on here

http://www.sqlservercentral.com/Forums/Topic517259-361-1.aspx

i am using VM for my production server, i am using SQL 2005 (64 bit), plan carefully accroding to ur requirements and it works without any problem, it have got...

Hi Jaykay

I am using nolock to access data, and then store this on a temp table, index the...

Thanks Jeff

Its supposed to take only a few seconds, since the table is continusly accessed by applicaitons, this is taking me 3 minutes to delete on a Quite time, i...

Hi Jeff

This is a nice way, but i cant block the table for this time, since the table is accessed by application via...

exactly , it changes every second, it is heavy updating, thats the problem i am facing

I haven't done table partition, but i guess this cant be done on this case, since they are moved according to certain range flag say 1 to 10, i cant...

I have the same settings as well, i am using 3rd party software to do log shipping and backups, i am using virtual machines for my servers, RAID 1...

I Agree with you, if you want SQLMS on Production server then you can have them with minimum rights, it really depends upon personal requriments of the organization, in my...

Thanks Wilts, 🙂

Thanks Gial :D:)

its with service pack 3, will this be a problem ??

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright 1988-2005...

Thanks Gial, i got a small doubt, MS says that it is secure to allow users to login into SQL using Windows account, what do you recon? is it good...