Exactly!

That was the example I as referring to.

Thanx Linda Johanning!

//Hanslindgren

Does this SP actually exist on the remote server or on the local server?

I almost guessed so... I think at this point it should be up to your third party vendor to show that their WebForm software actually IS slowed down. What ever...

Well, then I think the followup question would be: Where do you fit in your original question about CustomerID?

What do you want to pass to your SP to get your resulting...

..and even if you table has a clustered index on the column you want ordered. Don't depend on it. Doing a join might re-sort the table in some other, more...

No. SQL Triggers does not have a FOR EACH ROW. Depending on what dbo.s_SendErrorNotification is doing, maybe you could solve it without a cursor though...

Have you tried to make a SP on the Linked Server and execute it OVER the linked server?

EXEC LinkedServer.Database.Owner.mySPThatReturnsTheResultOfMyDBCC

//Hanslindgren

Hello,

You mean that you have x tables with CustomerID and you want the resultset to contain all the rows from all the tables (only those tables) that contain a specific...

How do you mean support double byte?

Maybe enough to look into NCHAR and NVARCHAR? Or maybe just a different COLLATION is enough?

I agree, doing a backup/restore to get one week of data seems a little awkward since you are getting everything and not just a week...  Go with the BCP suggestion! Look...

I don't know how relavant this is, it still requires some extra work... But here goes nothing:

I think I saw an example (It might have been from

Hmm..

Simon Martin, a quick question: When you convert a table 'into' a partitioned view and you have to stick with the...

Format files are a real pain... You could go with the insertion into a temporary table, SELECT your two columns and then drop the temporary table.

Well. You could try this: http://www.microsoft.com/downloads/details.aspx?FamilyId=06616212-0356-46A0-8DA2-EEBC53A68034&displaylang=en

I guess you should be able to deduce from the query plan where the work is beeing done, if it is on SQL Server of Oracle side. (Look for the...