or

do the proprietary update:

UPDATE a

SET AccountStatus = 'Enabled'

FROM User a

INNER JOIN sheet1$ b

ON a.emailaddress = b.Emailaddress

We enable deadlock detection at all our instances using:

startup parameters -T1204 and -T3605

so it gets recorded in the sqlserver errorlog file.

/* to start deadlock detection and recording without stop/start...

I would perform a checkdb on that db, just to be sure that is OK.

If it is ok, the cause will be your backup drive

Thanks for this valuable feedback. (with kb refs) :smooooth:

If you still have the occasion ... apply the latest tested cumulative update .

Did you find a reason for your clusterdb to...

If you want a user only to be used from a certain address, you should first create your UserId_to_IPAddress table and then use a logon trigger (you need at least...

halifaxdal (10/17/2008)

---

But all the records have been...

- it is a client setting. But that setting is used for any object at create time, so the object will use that setting.

- Script the ddl for your tables...

halifaxdal (10/17/2008)

---

Thanks for your hint, that's what I am trying. Can you provide more instruction on SSIS?

I did the following in Access:

I export the table to mdb, I tried...

- which schema do you expect your object eventstatus_bek_IGA to belong to ?

- do you have the needed grants to be able to insert into that object ?

- What's your ANSI padding set to ?

- use datalength in stead of LEN !

You need to configure the security settings for MSDTC at the server to accept the type of connections you want.

This gui is different, depending on the service pack of the...

You don't.

If you want to pass a rowset, just perform a select statement in your poc as...

A proc's return value is to be used more like an execution return code (ok or not ok)

However you can return a row set !

Just run the select statement within...

how about the MSDTC settings server side ?

Is MSDTC running ?

Is it configured to accept your time of server-server connection ?

I'm sorry. I noticed I pointed you to my service broker article and scripts.

Must have been a twist of mind :crazy:

The mirror testing I was on Two clients with dev-edtn...