Because, by varying the server name, you are varying the object you a referring to, that is dynamic SQL.

Except, we have objects that "alias" to other objects .. views to...

"sysservers" does not mean all SQL servers, it should be called sysLINKEDservers, which relates to alzdba's point.

You would also have to define the procedure DatabaseSummaryInfo on each server.

I have recently...

I think that sp_helpserver and sysservers are really about Linked servers. That is, they dont recognise all the servers you might have, only those you have explicitly created "linked...

I meant, move the code from the trigger to a stored procedure, so the trigger becomes just one line "exec triggerprocedure", recompiling that would be cheap, and I wondered if...

IOs aint IOs.

There are two physical types of IOs - direct and sequential - and other terminology depending on what function you are using to look at it.

Firstly, the popup...

Is it any different if you put your logic in a stored procedure that is called from the trigger ? (that is, SP may not recompile)

In Query Analyzer, type in a query on your view. Select the menu Query - Display Estimated Execution Plan.

You will see that the query plan shows how the UNDERLYING...

quote:

---

Beware using TRUNCATE TABLE as that is a non-logged operation

---

It will not fire on-delete triggers.

Some...

Perhaps the constraints (especially the second) were create WITH NOCHECK.

Because you can bypass checking when the constraint is created, it is possible (I think) to create a unique constraint on...

EXEC (dynamic) is always executed in a separate scope, which means it does not have the variables that were declared in the scope where "exec" appears.

Just as

declare @code1 varchar(10)

execute 'select...

Some errors in SQLServer are Untrappable in T-SQL. You can trap it in application code (ADO for example) but since you refer to @@Error it seems like you are...

Unions should always be

UNION ALL

unless you want the effect of Select DISTINCT.

Just thought I'd mention it because someone had a bit of code with Union. It can effect performance.

Maybe if you compared cpu from sysprocesses with before&after values of the global variables @@idle and @@cpu_busy (in millisecs) you might figure it out.

EG if you can get a quiet...

Definitions:

Primary Key = A unique key, disallowing Nulls. It is a concept from relational theory, where a Primary Key is one type of Constraint (Unique constraint is another, very...

I load 50,000 rows in 15sec. Multiplying that out, 24m would be 2 hours (just as a rough guide). Mine is a narrow table though - the total...