-- I've tweaked your table definition so as to use proper dates instead of months numbers

-- Notice the constraints to keep any dodgy dates out of the table

CREATE TABLE dbo.AssetPayments(

FileMonth...

So if the ExpectedDate changes, for example, from 2015-12-01 to 2016-01-11 then you could find yourselves renumbering the visits for two years - do I understand that correctly? What...

Sean's code is right. The reason your code didn't work was you missed out the parentheses:

SET @parameter = (select distinct column_name from table_name)

You won't get a syntax error for...

Sounds like a homework question. Here's a hint - order by NEWID().

John

Not tested, so probably riddled with syntax errors, but this should get you started:

WITH Nos(m) AS (SELECT 1 UNION ALL SELECT 2

UNION ALL SELECT 3 UNION ALL SELECT 4...

It's the double hop authentication issue. Your user credentials are being passed first to SQL Server and then to the remote server, which doesn't work unless you're using Kerberos....

Danielle

What is "does not work" - returns the wrong results, or gives an error? Please can we see your whole query? You seem to have an odd number...

Does this need to be real time, or periodical (for example nightly)? For real time, consider merge replication. For periodic, consider an ETL tool such as SSIS.

John

No, I'm saying if your largest table is 1MB and you...

Assuming you're not sorting in tempdb, allow roughly 1 to 1.5 times the size of your...

No. I'm not aware of any. They may exist -...

There's several ways of doing it. Set up a Central Management Server in SSMS, then register all your servers and run a query to get the server name on...

Shouldn't the copy syntax be like this?

copy S:\Log\xxxx_log.LDF v:\logs

John

Generating the EXEC statements and then running them one by one will work, but it's not the most efficient way of doing it, especially when you have so many customers...

No, you can't do this without rewriting your stored procedure. Please post table DDL in the form of a CREATE TABLE statement, sample data in the form of INSERT...