Viewing 15 posts - 196 through 210 (of 4,271 total)
You shouldn't have to do anything, it already knows about both instances.
Where you might have issues is if you have a firewall up on the SQL machine it is possible...
June 21, 2013 at 12:53 pm
Again you have not provided enough information.
A startup job in sql agent would not prevent other clients from connecting to SQL because SQL Agent is just a client of SQL....
June 21, 2013 at 12:50 pm
You end up with extra steps
1. Do something, If success goto step 3, if fail goto step 2
2. Email the failure, goto step 3
3. Do something else, If success goto...
June 21, 2013 at 12:47 pm
It is best for the OS, Data, Log, and TempDB files all to be on separate drives, but your config does not allow for this. As far as where each...
June 21, 2013 at 12:42 pm
Google: purchase sql server 2012 developer edition
You should have at least 5 places to buy from. Keep in mind that you won't be able to buy SQL 2005 developer...
June 21, 2013 at 12:22 pm
Dev edition is Enterprise Edition with a license that basically say you can't use it in production. It does not have a time limit. If you install a copy with...
June 21, 2013 at 10:57 am
I'm gonna pile on.
This is a bad idea, there is so much that can go wrong that endangers your production environment that it simply isn't worth the risk.
You could build...
June 21, 2013 at 10:49 am
I believe that all nodes have to be in the same cluster to utilize the Always On functionality. You could still use log shipping or mirroring but not Always-On.
Sorry man.
CEWII
June 21, 2013 at 10:42 am
If the COM object is hung up in-process then restarting SQL is the only way to clear it.
I found this http://support.persits.com/show.asp?code=PS051122152 it seems to use sp_oadestroy to destroy thing other...
June 21, 2013 at 8:56 am
bdanks 85818 (6/20/2013)
And yes you have the scenario correct, except what do you mean by "The sp_send_dbmail returns successfully"? No retries in code. Just those attempted by db mail.
I mean...
June 20, 2013 at 10:21 pm
Is the com object in-process(dll) or out-of-process (exe)?
How much time between iterations?
How much memory on the machine and how much is SQL allowed to use?
I have had more problems than...
June 20, 2013 at 9:47 pm
ok, all patches applied.
same process that worked in 2005 but not in 2008
same servers
same setup
You can send email in 2008 except when you @attach_query_result_as_file =1
The sp_send_dbmail returns successfully
That about everything?
I'm...
June 20, 2013 at 9:37 pm
My guess is the linked server is not setup to pass credentials to the far end of the connection, or as the other responder said it could be a double-hop...
June 20, 2013 at 5:28 pm
Ok, stupid question, what is the patch level of your SQL 2008 install? Maybe there was a bug that was fixed.
CEWII
June 20, 2013 at 5:26 pm
Boy, I'm running out of ideas..
So basically it works in 2008 but not 2005.
And you have verified the recipients are exactly the same? One recipient or a list? If its...
June 20, 2013 at 5:09 pm
Viewing 15 posts - 196 through 210 (of 4,271 total)