OK...pretty simple.

These is a folder that has shared datasources. If in the properties you have Overwritedatasources set to false, it can't delete whatever folder you have designated in TargetDataSourcesFolder.

Either...

Thanks Ken

That worked! I knew it was something small that I was missiing. However, it was driving me crazy when I couldn't find the answer through the articles...

This looks interesting.

Thank you.

But I don't understand where you are getting 'comp' and 'table'. Are this variables?

Tony

Thanks guys.

I am learning so much from this forum! I like to research and investigate and come up with a strategy or a thought. Then I bounce it...

Gail,

On the messages tab, I got:

Msg 15123, Level 16, State 1, Procedure sp_configure, Line 79

The configuration option 'default trace enabled' does not exist, or it may be an advanced option.

...

Yes, Sir. SQL Server 2005.

Tony

Hello,

I found this query and ran it. It returned 0 rows.

SELECT * FROM ::fn_trace_getinfo(default)

Thanks.

Tony

Hello,

I'm getting:

Msg 208, Level 16, State 1, Line 1

Invalid object name 'fn_trace_getinfo'.

Tony

The message says

(2 row(s) affected)

begin transaction;

Insert into CE_CUSTOM..GL_Transactions

(

SOURCEINTERID,

SOURCETBL,

DEX_ROW_ID,

SOURCDOC,

OPENYEAR,

OPENMTH,

OPENDAY,

ACTINDX,

ACCTTYPE,

ACTNUMBR_1,

ACTNUMBR_2,

ACTNUMBR_3,

ACTNUMBR_4,

ACTNUMBR_5)

Select '

(2 row(s) affected)

The two rows affected are:

GL20000

GL30000

Those...

So I am running into some difficulties when running the script.

1) I first have to get a result set of the available companies. This is from the beginning...

Wow!!

GSquared, this is whole new territory for me. I am going to do some tests and try this example.

Thanks so much for your help, ideas and getting me going...

I've never heard of that before. Creating a table with dynamic strings? Let me try to create a table and see if I understand what you are saying.

Thanks...

It may be, but I think the problem is scrolling throgh the resultset one at a time.

We get a company from the initial resultset, query the GL20000 table and insert...

Yes, that is correct.

1) First it creates a result set of companies which could be 500 rows.

2) Then it looks at each company's database

3) It finds either...

Thanks for your help.

I believe our server is under a heavy load at times. We are currently at service pack 3. So this fix should already be on...