Hi,

If you are using an execute sql task do the following.

1. Create your variable.

2. right click your Execute SQL Task

3. On the general tab , set the...

Hi,

Thanks for that.

It definately appears to be what used to show up in SQL 2000 as out of Memory.

I guess I could ask microsoft about it.

I...

Hi,

I have actually tried to select eveything into a temp table. The select into works fine, and if I do a select count(*) there are no problems.

However if...

Hi Guys,

Thank you for your comments as it turned out , I was just being silly. Being new the SQL 2005 I didnt realise that the default for developer...

yes, indeed it would be. That is how I had it setup initially. But suddenly it came up with an error saying. Cannot find database ID 11.

Ive had a...

Hi,

The problem is that the tables are on two seperate servers , so I cant rference the destination table from my query, in DTS.

Any Ideas?