Viewing 15 posts - 1 through 15 (of 23 total)
I think both are correct.
To solve the problem, all you need to do is use raiseerror in step 1 within the sql statement and then use step 2 to...
August 3, 2012 at 3:24 pm
I guess the simple answer is that whenever an enabled scheduled job with an enabled schedule is created, sql server agent evaluates the runtime schedule map such as the next...
May 30, 2012 at 11:27 am
It's this box kind of character that one of our oracle linked servers contains in its table that we are pulling data from. I have no idea how would you...
January 23, 2012 at 2:52 pm
what if the usage of xp_cmdshell is restricted? .. Any workaround to still be able to do this?
January 11, 2012 at 2:56 pm
I kinda was able to convert the .epub file over online but wasn't really an impressive conversion but if anyone would like to give it a try, then they could...
January 4, 2012 at 2:28 pm
What i understand from your description and If i am correct, you are trying to attempt for a dynamic data source connection.
One thing that you really need to understand that...
December 27, 2011 at 11:47 pm
I have an issue at hand right now similar to this but its the other way around.
I have an stored procedure which uses an openquery to query a linked...
December 8, 2011 at 11:03 pm
My Question to performance guard::
Don't you think this is somewhat similar to hardcoding the content.
You are hardcoding the domain for one reason where it cannot always be assumed that...
December 1, 2011 at 5:54 pm
Well, i already know that i could edit them using a sysadmin account but the type of accounts in question here are controlled accounts with restricted sets of privileges. They...
December 1, 2011 at 5:43 pm
Guys, i am kinda facing similar issue.
Can you please look at the post:
and throw in some ideas.
October 19, 2011 at 8:23 am
October 18, 2011 at 7:59 pm
I think you might be correct ...
I did try to recreate the issue scenario today. Also, as per the previous suggestions, I did install the service pack 1 for...
October 18, 2011 at 3:23 pm
This is two fold. On my machine, i just have the SSMS 2008 R2 installed but few of the others in my team have SS2000 EM and SSMS 2008 R2...
October 16, 2011 at 10:10 am
This feature would be best in use if you are addressing email groups in the recipients list to be auto-resolved at send time rather have to explicitly mention...
October 14, 2011 at 9:11 am
I agree to "Dev".
Though my suggestion seems more like a workaround without having to disable the constraints at data load, i think "dev"s suggestion seems to be a right fit...
October 14, 2011 at 9:04 am