it should be developers or enterprise edition

Insufficient information provided i would say.

1) Check the error log

2) the processid is basically spid , so you could have checked that with "sp_who2 59" and "sp_lock 59"

and also...

there is no precise solution/approach for this.

following are the things you can try.

1. use nolock( Warning :if possible)

2. do it in...

separation is being done with some kind of Sql job ?

Then you can use sp_send_dbmail.and use the query parameter

this links contains many scripts , see which one can help you.

http://www.sqlservercentral.com/search/?q=transfer+the+logins

Is the database mail configured...

try this

/*******************************************************

* SQL 2005 Extract Logins

* Hugh Scott

* 2010/01/06

*

* Description:

* Modified from the original to remove dependency on sp_VarbinaryToHex

* stored procedure. Other minor modifications as well.

*

* Modification History:

*...

Thanks

then what are the task/operations can be performed with disabled "sa" and with enabled "sa".?

this is new to me. are you sure for...

declare @deptid int

SEt @deptid = 24

if not exists ( select * from department where deptid = @deptid )

print 'department Doesnot Exist dude'

ELSE

update .....

Where deptid = @deptid

WHat, ...

i also tried it . datatime --> varchar ---> int . it worked because sql server allows varchar to int conversion only incase when column contains null values but...

ipeepay (7/16/2010)

---

Hi Everyone ,

First of all I have to apologize for my English. It's my second language. I have a problem to do with my sql server 2005.

As...