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...

That's a very unambiguous message. What do you not understand about it? What statement are you running to get the error?

John

Why are you creating the table at runtime? Does it change from one run to the next? Indexes will slow down inserts, yes, although not necessarily by a...

Yes, you'd need to use dynamic SQL, something like this:

DECLARE @sql nvarchar(200)

SET @sql = N'Select * from #emps Where EN IN (' + @names + N')'

EXEC sp_executesql @sql

John

Careful, Chris. That doesn't work if you use values explicitly defined as time.

DECLARE @TimeTable table (StartTime time, EndTime time)

INSERT INTO @TimeTable

SELECT * FROM (VALUES

('09:00', '17:00'),

('09:00', '15:00'),

('09:30', '17:30'),

('12:00', '17:00'),

('13:00',...