take the database offline and then take out the mdf

i found error if i put "paul" repetitively

declare @t table ( name nvarchar(30), num int)

insert into @t

select 'paul1', 10 union

select 'paul2', 5 union

select...

three permissions categories

1. sysadmin

2.sql agent login

3.proxy account

what changes have you made ? please share with us

At server/databae level , no idea about that additionally didnt that issues resolve from that link ?

check why following SPID creating dealock use sp_who2 for it

SELECT distinct spid

FROM ::fn_trace_gettable('C:\Documents and Settings\bkumar\Desktop\TraceAllDeadLocks\TraceAllDeadLocks.trc',0)

where textdata like '%deadlock%'

A bit starnge requirement , anyways for that you need to put some lookup table which will store different...

try this

declare @t table (amt int, p int)

insert into @t select 40000, 10 union select 4000, 30

select amt , p , ((amt*p)/100 + amt) as total from @t

Also post some sample output based on the data you posted above

See if this can help you http://support.microsoft.com/?scid=kb;en-us;310426&x=12&y=11

Few findings

1. There is no sargable clause/filter which leads to SCAN.

2.

select A.emp_code

from TBL_EMP_MST A...

Another approach

SET statistics profile on

exec SP

SET statistics profile off

Check whether you have required access or not ? additionally can...

Neepa (5/24/2010)

---

you can start deleting records in batches using some selection criteria with indexed column values, If you are using starttime/endtime like columns, make sure you create an index on...

i dont know about the sequence but few other operations are also got performed here like

@sql variable assignment.

excecution of dynamic sql , displaying results , different type of...