If you need to return a value from dynamic sql, you should use

the sp_executeSQL system stored proc.  You can look it up in BOL, but here's a sample script:

DECLARE...

Straight from MS's site:

Distributed File System (DFS) is a strategic storage management solution in Windows Server 2003 that enables you to group shared folders located on different servers logically...

This is very simple, but it's worked like a charm for the last couple of years.  If anyone has a better alternative, I'm all eyes (since I can't hear what...

If you're using the MSDE, you're probably running up against the "governor" that "dissuades" more than 5 users from using it, although you can theoretically go higher, it just gets...

Just an FYI, you might have already considered this, but make sure to code your trigger for multiple inserts.  I've been burnt by the reality of insert statements that fire...

I have been using an Access2k front end to SQL 2k for about 2 years with 6 users. I've never had the locking problem and all 6 are in it...

You might want to look into User-Defined Functions That Return a table Data Type.

They might give you the functionality you're looking for.

From BOL searching on AND:

Hope is helps.

Precedence of AND and OR

When a query is executed, it evaluates first the clauses linked with AND, and then those linked with OR.

Note...

I don't know if it's just pseudo code, but you should be using inserted as your table name.  It's the actual table data that's being inserted, even during the update. ...

Have you tried accessing the data in the linked server using a view and then trying to access the view from the remote servers?

Whenever I use linked servers, I use a view to hide the extra complexity and confusion.   It also saves typing the extra dots

I think the easiest way to rebuild the data would be to delete and add a clustered index.  The final result would be data ordered by the clustered index.

Whenever I import data from Excel, especially using DTS, I open the doc and import it using COM. The "feature" you're dealing with is MS's way of optimizing ODBC...

You could save all of the packages to a structured file (text) and then search those files. Kind of a pain, I know.

I've always used the > clause and a unique index to page through my data. You store the ID on the page and pass that ID to a stored...