All good ideas... Thanks, Carl!

Shhhhh!  My ol' friend Serqiy will hear you!  

Thanks Carl,

Yeap... the thing about the proxy needing to be available is pretty much what books online said... thanks.

Heh... Maintenance plan?  What's that?   Doesn't everyone know that a database is just a place to hold data for the GUI?

Heh, thanks Michaela,

I don't mind explaining at all... Some folks really take things the wrong way when asked for the source of what they said and I wanted to make sure no one...

Thanks again... I'll check that SET command.  Jobs also look promising if I set up a "proxy" account (lucky guess on my previous post).  Here's what BOL says about running...

Oh shoot... why didn't I think of this before?   I can setup a "job" to run as a user that has "SA" privs...

Heh... I'd have to say they just did it out of ignorance or the path is hardcoded in the installation routine (whatever that may have been), Bill.  I've seen your...

Thanks, Sugesh...

Wow... not sure I want to grant exec privs to xp_CmdShell... almost as bad as giving them "SA" privs in the damage they could do.

Small shop?  In that case and having been there myself... you'll be amazed at how many good bites you get with the seemingly silly "DBA and Jack of all trades"...

Try it through Enterprise Manager and make sure you select to option to move the pages to the beginning of the file before a shrink is attempted.

Michael,

SQL is not SQL... Access has a slightly different set of commands, clauses, and features... you might want to try posting on the Access forum... or, at least give someone...

Sorry about that... the other code had a problem when the two strings were different lengths (doh!)... I fixed the function code above...

Ah crud... I've got a fly in the ointment... didn't test the majority of possibilities... I'll be back...

Ok, a function it is... still using the Tally table 'cause I don't have 2K5 to test the code with...

 CREATE FUNCTION dbo.fnCharCompare

/******************************************************************************

 Purpose:

 Compare the two input strings and return...