By default SQL Server does not accept remote connections. On the SQL Server box you need to go to the SQL Server Configuration Manager and make sure TCP and/or...

Check out this thread, http://www.sqlservercentral.com/Forums/Topic305986-92-2.aspx

Have you tried using RESTORE? While the standard extension for a Native SQL Backup is .bak you can use any extension you want and it will restore using RESTORE.

I'd guess 1. 3 will be slowest.

Vikas and Abhijit have offered better solutions. Your original proposal is inflexible as you limit the # of phone numbers to the number of columns in the table. ...

Please read the articles linked in my signature. Your question is incomplete as posted.

Just a shot in the dark, but if the column is a character data...

Interesting topic. I can see both sides of the issue. I personally am against legislation of pay. I'm not a big union fan either, because the union...

If you are using SSIS, I think going directly to the source will be faster. Using a linked server basically means you have 2 clients the SQL Server and...

Steve Jones - Editor (1/15/2009)

---

With the editor living in Denver and being a Broncos fan, that's a good way to get yourself banned!!;)

Glad to see the Patriots out of contention...

Why are you using a linked server? Why don't you just use the actual source as the source in SSIS and skip the overhead of the linked server?

GSquared (1/15/2009)

---

Just to check something on this, I put together this test:

create table #T1 (

ID int identity primary key,

Col1 int);

insert into #T1 (Col1)

select number

from dbo.numbers;

select *

from dbo.Numbers

cross apply

(select col1

from #T1

where...

The APPLY operator is designed for use against table valued functions while JOIN is for tables. They are not interchangeable.

What is the primary key definition? The error is pretty self-explanatory. You are getting dupes, so either you have bad data or a poorly chosen primary key.

You should work on tuning the stored procedure. Run it on the source server, check the execution plan, and add indexes or change query as needed.

Wasn't hard. Montana was for the wedding of her...