I'm using the fast load as it happens. The slow part is the lookup.

Thanks though

Kenneth

He only has the client tools installed. I thought that the remote connections setting was for the server level only?

He can connect to the server with the...

Yea I saw alot of postings about it related to SQL 2000 but nothing related to SQL 2005. And I can't find anything on the previous error that isn't...

Unfortunatlly we checked the install and it was fine. Just to be sure we re-installed it but still no difference.

Kenneth

Unfortunately no.

The only suggestion that I saw that might have worked was changing a registry setting that told windows where the default program files directory was. Unfortunately I don't...

The only thing I can think of is that the create procedure is failing. Unless the code is doing a drop ahead of time the SP already exists so...

You might also make that a question as you hire your SQL DBA's. See if they can explain to You how to design a DB.

Kenneth

Probably the eaiest thing for you to do is to create a trace on create database. But you can create a trigger using

CREATE TRIGGER ddl_Trig_DBCreate

ON ALL SERVER

FOR CREATE_DATABASE

......

Use...

If I were you I would run a short trace on the server to see where the "create procedure" statement is comming from.

It may be that when the application code...

And that typically you find the easy method after spending hours and hours on the harder methods.

Kenneth

I'm not really sure if what you are looking for is possible in a single query.

Part of the problem is that it doesn't just matter if the field...

If I understand what you are asking its not possible. Because text files just can't do that. A text file is just that .. a file with text....

Probably a fairly minor point but even a very very small difference can be worth it when you have a piece of code being run thousands of times a second.

Also...

create table t1 (a int, b int)

create table t2 (b int, c int)

insert into t1 values(1,1)

insert into t1 values(1,2)

insert into t1 values(1,3)

insert into t2 values(1,2)

insert into t2 values(1,null)

insert into t2...

Yes, unfortunately you do have to declare a variable for each column. Generally you want to make sure that you aren't pulling columns that you aren't going to use.

If...