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...

GG,

Heh... ok about the aesthetics thing... I don't agree about it being unsettling about having "skip" numbers show up, but I'm also not in your position nor do I know...

Perfect... thanks for that and great answer... good code, too!

Amrita??? How about you?  You started this thread... why do YOU need to do...

Heh... and this is the SECOND one on the same subject...

Heh... absolutely agree on that!  And the "Hardware Support" may even include the mundane... like changing toner cartridges on a printer