Why were you asking if you already knew what you were looking for?

Hmm, I don't recall any mention in your original post that you were trying to Rollback actions in the trigger without rolling back the action that invoked the trigger.

Naming the...

Can you post the Trigger code?

I think that you need to cathc the error and suppress it. You can also read this article[/url] by some really smart guy who...

Then this error eithe indicates that the run-time environment does not have SSIS installed or that the installed edition is too low (ie., Express when you need Standard, or Express...

jliu (5/12/2009)

---

Thank you both for your replies. I randomly checked a few tables between the publisher and the subscriber, they seemed to match. I will run the sp to validation...

Let us know if you find a way around it.

Sorry, I missed that @tbCueUp was a table variable instead of a string variable. Try it like this:

...

Declare @sql as Varchar(MAX)

Select @sql = 'DELETE FROM '+@WE_ClientCode+'_ReEnrolment;'

+'...

Glad I could help.

In what context are you getting this error? When you open/edit the...

Managing, executing, ect. can be granted through the SQLAgent roles. However, only sysadmin members can edit Jobs other than their own.

From BOL on "sp_update_job" (the procedure that must be...

Great! Glad it worked for you then.

kevin.kinsella (5/13/2009)

---

HI I would agree, but i have been doing some investigations and if i reference an already populated field (by the web page previoulsy) as the input to the...

Joe (5/13/2009)

---

RBarryYoung

Thanks for your reply; Can you know of any software you experience with;?

RBarryYoung

Thanks; even if I get in table thru win service; I still need to do something extra...

nabeelmukhtar (5/13/2009)

---

Just found out that both sys.dm_exec_sessions and sys.dm_exec_requests return incorrect total_elapsed_time for parallel queries (requests with parallel execution plans). Is this a defect or a misunderstanding on my part?

So...

Like this then:

Create proc spMyAccessProc

AS

UPDATE TblNoRent

SET TblNoRent.Add1 = Left(Add1, Charindex('.',Add1,1)-1 )

+ Right(Add1, Len(Add1)-Charindex('.',Add1,1) )

WHERE ((TblNoRent.Add1 Like ("%.%")

And (TblNoRent.Add1) Not Like ("%[0-9].[0-9]%")));

-- not sure if...