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...

show the real query, and you can generate an estimated execution plan without running the query at all. just highlight the query and click the button for estimated execution plan.

Krishna1 (6/4/2013)

---

Dear All

I am using sql 2008 . While compiling the procedures it does not give error even if table not present.

I need to trap this error. How to achieve...

if you have a specific performance problem, we really would want to see at least the estimated execution plan, and the actual query.

when you abstract it out, you end up...

like this?

SELECT

snetworkname,

REPLACE(sNetworkName,'.noc','')

FROM WhatsUp.dbo.NetworkInterface

RIGHT OUTER JOIN WhatsUp.dbo.device

ON WhatsUp.dbo.NetworkInterface.nNetworkInterfaceID...

Brandi has a nice analysis;

for this one:

SQL Server Integration Services Recipes: (Beginner)

I swept through forums to identify frequently asked questions posted by people getting started with SSIS. In this demo-centric...