Thx.. Bill

Actually that is what I am trying to do but I can not access db. I've got an error message saying that Protocol Adapter error and other one is...

OK.. Then

I dont have much choices.. I try learn , I mean quick learn, how to import dmp file..

I am looking at article about importing but do you, I mean anybody,...

Create

Proc USP_AT_Participation_Report_Pull @prog Varchar(50),@Chapt Varchar(10),@State...

ohhh..yes space is typo

Thx..

Let me try..

Jay

Thx..

Probably I was on drug..

I couldnt find that one but right now,I...

Thx..

I just find out that if Image field is NULL, this TEXTCOPY wont work..

Therefore I update that field with empty string('') and then I run this command.. That works OK..

Thx

Jay

Thx..

Jay

Hi, Brandon

I am not sure u can backup into UNC path by schedule. YES, u can backup into network when u manually back up the DB but not by schedule.....

If ur job is for backing up DB or any kind jobs to other server not in the same server, U need to run ur SQL agent with network user...

I am not sure u are heard about this CRM.

Name is IMIS. This package nomally focuses on non-profit organizations.

Thx

Jay

Thx..Jeremy..

That fixes 0MB problem...

Right.. That gives me more q why that happens..

Jay

No.. but Auto Update Statistics and Auto creating statistics are turned on.

Jay

Nothing.. That works great. I mean SQL server.

Jay

Oh..Man..I forgot something to post..

I have 4500 records to test the both of ways.

-GregLyon's script ran for 40 mins but did not finish to pull.

-5409045121009's script ran less than a...