Viewing 15 posts - 256 through 270 (of 965 total)
One way to hack around this problem is to turn TRUSTWORTHY ON for the database that has your wrapper stored procedure in it. However, the best way to do...
November 24, 2009 at 6:50 pm
The potential problems are the same as any upgrade. Download a copy of the Upgrade Advisor and use it to help plan:
November 23, 2009 at 10:18 pm
Try changing the port from 25 to 587. Your ISP could be blocking port 25 or you could have a virus scanner that is blocking that port as well.
October 23, 2009 at 11:05 am
Make sure that you enabled Database Mail in the Surface Area Configuration Tool. Then Open up SSMS, go to SQL Server Agent and right click on it. Go Properties....
October 23, 2009 at 10:06 am
Which specific Cumulative Update are you referring to? There are multiple Post SP3 Cumulative Updates? Can you provide a link to the specific one you are looking at?
October 23, 2009 at 10:02 am
There are two ways to go about doing this:
1. Design the database and SQL code that is generic and DBMS agnostic. (Essentially nothing beyond basic SELECT/INSERT/UPDATE/DELETE and ANSI standard...
October 23, 2009 at 10:00 am
Have you attempted to use EXECUTE AS and impersonating the execution context of the job to see what results you get?
October 23, 2009 at 9:52 am
It depends on what kind of load you are after. The trace method is one way to go about it, but if you are targeting a specific load point,...
October 23, 2009 at 9:48 am
The Books Online topic would be the most comprehensive location:
Database Engine Events and Errors
You can also query sys.messages to get the information:
select
message_id,
language_id,
severity,
is_event_logged,
text
from sys.messages
where language_id...
October 23, 2009 at 8:47 am
sanokistoka (10/23/2009)
So are we to draw the conclusion that this application is actually not designed correctly because it didn't catch this and retry the transaction?
It depends on how you...
October 23, 2009 at 8:07 am
sanokistoka (10/22/2009)
Have you tried Oracle, which doesn't exhibit, say SELECT/UPDATE deadlocks because of row versioning?
My companies primary DBMS is Oracle. SQL Server is just a supporting application database...
October 22, 2009 at 5:25 pm
sanokistoka (10/22/2009)
October 22, 2009 at 2:36 pm
No there isn't a way to currently do this in SQL Server 2005 or 2008. Your only way to attempt it, and it isn't guaranteed, would be to setup...
October 20, 2009 at 1:27 pm
Reapply Service Pack 1 to SSMS 2008. There is a DLL from 2005 that was reregistered during the updates that is causing the issue. Running SP1 for 2008...
October 20, 2009 at 1:25 pm
Steve Jones - Editor (10/20/2009)
October 20, 2009 at 1:15 pm
Viewing 15 posts - 256 through 270 (of 965 total)