Viewing 15 posts - 3,496 through 3,510 (of 5,394 total)
GilaMonster (2/2/2011)
Google terms - Fire_Triggers...
February 2, 2011 at 2:01 am
Lynn Pettis (2/2/2011)
February 2, 2011 at 1:16 am
The server collation determines the collation for system databases (master, model, tempdb, msdb).
Probably some procedure makes use of temporary tables, created on tempdb, hence the collation conflict.
I would create...
February 2, 2011 at 1:11 am
It's an Active Directory issue IMHO.
I have been experiencing something similar and found out that the AD server had to be patched. Is it w2k3?
February 2, 2011 at 1:05 am
Somethiing must be failing from SSIS.
The code in your trigger has no transaction control,so that it can insert data on table emp and tien fail.
I would suggest adding transaction control...
February 2, 2011 at 1:00 am
db_ddladmin is a built-in role.
If you are willing to give this role a different permission set, I would create a new one with a different name instead.
January 31, 2011 at 1:18 am
Can you explain a bit more what you're after?
What should this DLL do that a CLR assembly can't do?
January 31, 2011 at 1:15 am
Here's a split function (and much more).
January 28, 2011 at 9:59 am
It's not very efficient, but it should do.
Prabably dynamic sql is the best tool here.
CREATE PROC spBalanceRanges
@VendorVar varchar(50) = '%',
@BalanceMin money = 0,
@BalanceMax money = 9
AS
Select VendorName,InvoiceNumber,InvoiceTotal-CreditTotal - PaymentTotal AS...
January 28, 2011 at 1:24 am
CirquedeSQLeil (1/26/2011)
Have you guys seen the news?
Congrats, Jason!
January 27, 2011 at 1:03 am
Elliott Whitlow (1/26/2011)
Gianluca Sartori (1/26/2011)
Funny. I always thought that Hubbard had written Scientology related books. Looks like this one is focused on other topics.
I read that as: he wasn't always...
January 26, 2011 at 9:36 am
GSquared (1/26/2011)
Brandie Tarvin (1/26/2011)
Gus, where and how did you learn all this stuff? It's really fascinating.
Much of it is from a book called "Science of Survival" (http://www.amazon.com/Science-Survival-Prediction-Human-Behavior/dp/1403144850/ref=sr_1_1?ie=UTF8&qid=1296058221&sr=8-1). (Most libraries...
January 26, 2011 at 9:29 am
pektas.isil (1/26/2011)
Sorry,I cant post execution plan.is the problem related with plan cache?
I don't think so, since you said the plan is correct.
I suggest that you identify with a trace which...
January 26, 2011 at 6:41 am
Are you running with a different parameter set? It could be parameter sniffing.
January 26, 2011 at 4:18 am
Viewing 15 posts - 3,496 through 3,510 (of 5,394 total)