In fact, Jacks solution is better, except for the isnull testing.

There it depends if your columns are allowed to contain nulls or not.

And you should still perform :

if @@ROWCOUNT =...

you should directly move the data into your varriables:

ALTER PROCEDURE [dbo].[getSchedule]

-- Input

@facility char(2),

...

did you try this ?

Declare @weight as char(25)

Declare @output as numeric(18,2)

SET @weight = '2*5+2*5*4'

declare @TheSQL nvarchar(1000)

Set @TheSQL = 'Select @theoutput = ' + @weight

--OutPut should be 50.

exec sp_executesql @stmt =...

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...