i don't think there's a limit on RAM;

the default setting is 2048 terabytes of ram as the default maximum setting until you change it to something less than what is...

Howard I have 2012, but I'm not sure where, specifically, you are talking about where the objects get bracketed by the quotename() function;

do you mean when you script an object?...

GabyYYZ (6/4/2013)

---

Ahhh...in our company, we consider naivete and blissful ignorance as sound DR...

sachin6139 (6/4/2013)

---

I have 2 select statements. One with NOLOCK hint and other without NOLOCK hint. I am getting different result sets. Rows are same but there order is different....

i had to add one more alias near the end to get this to parse correctly in SQL:

(also several columns are using reserved word names: xxxSTAFF.[File],xxxBanks.[Desc], xxxPayrollBankGroups.[Group])

...

FROM [xxxOES Absence 2006...

maybe soemthing like this might help?

you just need to test for the existence of any data int he INSERTED or DELETED virtual tables

CREATE TRIGGER TR_WHATEVER_NOTIFICATIONS

ON WHATEVER FOR INSERT,UPDATE,DELETE

AS

BEGIN

SET NOCOUNT...

take...

this is a query i like to use, to get teh path for me easily:

--SELECT * from sys.traces

declare @TraceIDToReview int

declare @path varchar(255)

SET @TraceIDToReview = 1 --this is the trace you...

again, it's not the version, it's most likely stale statistics, that we mentioned a few times; there's nothing in your example that is not done in...

i believe under the covers , false is zero, and true is anything not zero,...

nope, not a valid test/way to reproduce the issue.

here's your exact code, but loaded with random data.

on my machine, with all four versions of SQL Server I have installed...

i believe this is the equivalent; the first test is evaluating whether it's boolean, so the first part of your test is just checking if the value is zero...

here's a quick and dirty example, of how to get rows from the Oracle Linked server without copying the whole table, and then filtering, like a typical linked server query...

wow that's unusual, can you check for corruption? that might explain everything:

dbcc checktable ('YourTableName') WITH ALL_ERRORMSGS

DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

the default trace has it,if not too much time has passed, since it only keeps the last 100 meg of changes

fastest way to get to it is to right...