Viewing 15 posts - 2,431 through 2,445 (of 7,631 total)
us_dba (5/13/2009)
Thanks, Noel.Yep, this is one of the options.
Here is the solution I was looking for:
Why were you asking if you already knew what you were looking for?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 13, 2009 at 3:02 pm
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...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 13, 2009 at 2:51 pm
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...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 13, 2009 at 2:32 pm
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...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 13, 2009 at 2:14 pm
jliu (5/12/2009)
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 13, 2009 at 1:27 pm
Let us know if you find a way around it.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 13, 2009 at 1:25 pm
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;'
+'...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 13, 2009 at 11:52 am
Glad I could help.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 13, 2009 at 11:19 am
Shawn Therrien (5/13/2009)
When I turn on Package Configurations (and use a variable) I start getting an error: DTS_E_PRODUCTLEVELTOLOW.
In what context are you getting this error? When you open/edit the...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 13, 2009 at 11:17 am
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...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 13, 2009 at 11:10 am
Great! Glad it worked for you then.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 13, 2009 at 10:50 am
kevin.kinsella (5/13/2009)
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 13, 2009 at 7:49 am
Joe (5/13/2009)
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...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 13, 2009 at 7:38 am
nabeelmukhtar (5/13/2009)
So...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 13, 2009 at 7:34 am
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...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 13, 2009 at 7:30 am
Viewing 15 posts - 2,431 through 2,445 (of 7,631 total)