Thanks Again

• This reply was modified 6 years, 4 months ago by DHeath.

Thank you SIR...... much appreciated

DHeath

Mr. Green,  thanks again and much appreciated

altho i must ask...how does the sys.master_files clean up itself...is that something SQL will do or something  i need to do after i revert? ...

Antony.Green,  thanks for the reply...

I have never had to "revert" backward are there any special commands or anything to the sort?  As you mention you said single master mode i...

Phil,  Yes i would like the new tables to be empty once they are created.

Johnathan LMAO.... loved your response with the comment *** So would still probably involve pressing the paste key about 2,000 times. But faster than scripting each one individually.*** too funny...

Phil... thanks for that as actually it is copying the table and keeping the same name with _new added.  So for the mis hap..will correct my self in the post.....

Jeffery....Thanks so much for the assistance... i too been searching all over for that error and came to the conclusion of permissions as well.  Now will give try to give...

Sue Thank you so much for your time and everything .... you are appreciated and  wanted to say thanks

Jeffery... the code you sent seems to work much better than what...

• This reply was modified 6 years, 7 months ago by DHeath.

Sue,  I am wondering if its the code because i am doing some file manipulation and not simply a select statement as those seem okay...and i know the code is...

Sue,

Thank you for your reply...greatly appreciated.

There is nothing trying to touch the file.. i created it specifically for this.  I am thinking my coce is wrong in the way i...

Thanks Lowell as your assistance is appreciated...Yet i am still dead in the water...  Your suggestion about permission were excellent and spot on. yet now i am getting different messages...

• This reply was modified 6 years, 7 months ago by DHeath.

thank you ...the insert into was where i was wrong...thank you so much

thank you for the reply and that has me moving in the right direction.... BUT this is the current error

IF OBJECT_ID('IsFirstRemit_D') IS NOT NULL

TRUNCATE TABLE IsFirstRemit_D;

SELECT MIN(a.ClaimDetailID) as ClaimDetailID

,a.FacilityPrefix

,a.AccountNumber

,a.RemitDate

--INTO IsFirstRemit_D ...

Thank you for the reply...much appreciated...so i am thinking i can run my query as a stored proc on server Production....and have it return a command in @cmd... Then have...