Hi

Before answering your post could you please giver reply to these

How can u taking username from active dir?

How to find the all the username from sql server?

How to...

i am using the above query any performance issue come in future

Hi Guys Thanks A lot

here we are using two table so we can use join right

update employeetable set passportcode A employeetable, B Passport table

where a.employeeID=b.Employeeid could any give me the correct query the above query is giveing error it will not updated.

hi every body

Thanks u for your effor

I want a query for delete every half an hour.

my condition is i am not schedule an job for this i am not use...

Hi Could any body help me how i can solve this temp db in Production server

yes i can do the same thing but againg that job is failing.

1st One backup Job is running at 6:00 Pm

2nd job is running at 7:000 pm i can...

Thanku for response

could plz tel me is there another way to find out dead lock

How can i rectify this deadlock

Which situvastion it will occure

Blocking and dead lock which situvastion...

Hi Friend Thanku for response

i am using SQL profiler but where it is exactly iam not understanding could plz tel me the step wise plz

T&R

ms