You have to identify the sessions using the database and kill them.

The easiest way is querying sys.sysprocesses (I know, it's a compatibility view, but does the trick very fast).

SELECT spid...

Can you script out the linked server and post it here please?

Also, can you post a sample of the failing code?

It returns no rows, with new and old query.

What am I missing?

The only parameter that returns rows is '1'.

I guess this is a RESTORE WITH REPLACE, isn't it?

Just DROP the database before restoring, no need to restart the instance.

Thanks, but your sample data looks nothing like your expected output. Can you update that as well?

Almost forgotten: do it on both servers.

My bad, I totally misread your initial post. :blush:

Run this instead:

exec sp_configure 'remote access', 1

reconfigure

This is a tricky requirement and I had to deal with this myself some years ago.

I ended up adding a couple of statements to each stored procedure I wanted to...

Can you please post the table script as a CREATE TABLE statement and some sample data as INSERT statements? Can you also post the expected output based on the sample...

There is nothing wrong with the call: it'a a linked server property that controls whether stored procedure calls are allowed or not.

Run the code I posted and let me know.

http://www.google.com/search?q=script+database+roles+and+permissions

EXEC master.dbo.sp_serveroption @server=N'LINKEDSERVERNAMEGOESHERE', @optname=N'rpc', @optvalue=N'true'

GO

EXEC master.dbo.sp_serveroption @server=N'LINKEDSERVERNAMEGOESHERE', @optname=N'rpc out', @optvalue=N'true'

GO

Hope this does the trick.

Gianluca

You may find this article[/url] helpful.

Regards

Gianluca

Case matters. Use sqlcmd -S.\instance3 instead (uppercase s).

GROUP BY should do the trick:

-- SAMPLE DATA

DECLARE @Audit TABLE (

[ID] int,

[Modified on] datetime,

[Previous Delivery Date] datetime,

[New Delivery Date] datetime

)

SET DATEFORMAT dmy

INSERT INTO @Audit

...