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

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

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

what if the usage of xp_cmdshell is restricted? .. Any workaround to still be able to do this?

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

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

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

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

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

Guys, i am kinda facing similar issue.

Can you please look at the post:

http://www.sqlservercentral.com/Forums/Topic1189494-391-1.aspx#bm1192580

and throw in some ideas.

Thanks

empty string

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

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

I agree.

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

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