Viewing 15 posts - 16 through 30 (of 1,047 total)
wolfkillj (1/24/2014)
The developers have so much of that architecture built already, and frankly, I'd rather not accumulate any more responsibility for this project than I already have!
LOL Understood -...
The probability of survival is inversely proportional to the angle of arrival.
January 28, 2014 at 8:15 am
Its obvious that the event is being sent to the second thread before the transaction (first insert) has committed, regardless of what is going on in your second procedure.
I will...
The probability of survival is inversely proportional to the angle of arrival.
January 24, 2014 at 2:02 pm
RPC calls are not the same as actual TSQL statements or procedures run directly against SQL server. They run inside of of the RPC server process, so just because thread1...
The probability of survival is inversely proportional to the angle of arrival.
January 24, 2014 at 12:21 pm
Shouldn't take that long, the process must be being blocked.
The probability of survival is inversely proportional to the angle of arrival.
January 24, 2014 at 12:01 pm
Jeff Moden (12/18/2013)
The probability of survival is inversely proportional to the angle of arrival.
December 18, 2013 at 12:38 pm
What you have presented looks like an ugly design. The PK appears to be a string that has a 'EXPXX' suffix appended to it. Then you must apparently strip the...
The probability of survival is inversely proportional to the angle of arrival.
December 18, 2013 at 9:20 am
Grant is right on. Your use of sp_executeSQL is superfluous in terms of preventing injection the way you have implemented it. Read BOL on sp_executeSQL and learn how it works....
The probability of survival is inversely proportional to the angle of arrival.
December 16, 2013 at 7:23 am
robin.pryor (12/12/2013)
The probability of survival is inversely proportional to the angle of arrival.
December 12, 2013 at 9:23 am
It appears the server was added using a fully qualified domain name like: server.domain.com. To be honest I have never considered the impact that might have on referencing database...
The probability of survival is inversely proportional to the angle of arrival.
December 11, 2013 at 1:57 pm
Is Server1 the DNS alias name?
The probability of survival is inversely proportional to the angle of arrival.
December 4, 2013 at 3:08 pm
Have you set up that as a linked server? What does the sys.servers entry look like?
The probability of survival is inversely proportional to the angle of arrival.
December 4, 2013 at 2:19 pm
You'll have to restore the most recent back with standby
The probability of survival is inversely proportional to the angle of arrival.
November 15, 2013 at 12:57 pm
yes. modify the stored procedure to do the bulk insert into your stage table first, then encrypt the column in place or encrypt by inserting into your final table...
The probability of survival is inversely proportional to the angle of arrival.
November 13, 2013 at 1:13 pm
If you want and have the desire to, you can script out all of the Agent jobs using method from SMO from a .net utility. I actually do this on...
The probability of survival is inversely proportional to the angle of arrival.
September 26, 2013 at 11:00 am
The first thing you need to do is sum up the items - group by each month:
select mm=datepart(month,Date), itemRef, QTyTot=sum(Qty)
from Purchaseorders P
JOIN Items I on I.PoNum = P.PoNum
group by datepart(month,Date),...
The probability of survival is inversely proportional to the angle of arrival.
September 26, 2013 at 8:15 am
Viewing 15 posts - 16 through 30 (of 1,047 total)