You can use the four part name for a linked server:

DELETE FROM linkedserver.databasename.schema.table where .....

Good luck

Peter

By the way...

If you want to find out the name of the third to last database backup file created, so you can delete it, you can do it with:

declare @file_name varchar(100)

select top...

Thats the article reference I was looking for! I believe it only relates to variables or constants in WHERE clauses of SQL statements. If they aren't 'DECLARED' SQL server assumes they are variant and...

I don't know how much data you are bulk loading each time, but rebuilding the indexes is probably causing the database to grow. Check the database growth percentage is large...

The procedure will work OK if you stop and start SQL server, because it will have no trouble getting the large amount of contiguous memory that it needs. The problem will...

Sorry Jim, I missed that you were trying to get the maintenance plan to delete without doing the backup.

I have never tried to do it, but I think you will...

A possible solution is to schedule transaction log backups more frequently, using your maintenance plan. Or, set up an alert to automatically trigger a transaction log backup when the log files gets...

I have probably misunderstood what you are trying to calculate, but the following SQL tells you how many overlaps each staff member has per day. You can change it as...

Just a thought. It might be writing to the log but the server reboot will mean the update to the log file may not have been written to disk. Perhaps change...

Two points that will affect query speeds but maybe not to the extent that you are saying...

The queries will take longer if there are more physical disk reads to do....

Wow. I haven't any way of easily testing something like that here, without alot of work.

I suspect that the INNER JOIN OPENXML near the top is doing a hash merge...

You have to nest the selects and calculate the columns you want to use for other columns in the inner select. eg

select *,

CASE MonthsOfStock

WHEN < 1 THEN 10

WHEN >= 1...

Replication runs under the SQLSERVERAGENT service and the Enterprise manager Replication facility runs under the MSSQLSERVER service on the publisher and subscriber servers. In Enterprise Manager right click on the...

If you try

declare @a datetime

select @a = '19041112  '

select @a

in query analyser you will see that SQL server has no problem with the format of the dates (even with...

I had this same error a few months ago. I tracked it down, in my case, to an SQL select query that had just been modified to add 2 more 'LEFT JOINS'...