>> I know I've often seen younger people try to get ahead at the expense of those with families because they're willing to work more.

By chance is your database instance set up for Windows Only authentication (instead of Mixed)?

The XOR encoding approach might stop a casual thief (it's certainly better than nothing) but the algorithm is way too easy to crack.   Indeed a hacker will probably LOOK for a simple XOR approach...

>> I want to migrate MS Access database to SQL server 2000 database. Please provide the script for the same.

Hey Vilas,

You totally hijacked the original poster's...

>>  For example if there are versions 3.1 3.2 3.3 already in production

Excuse my total ignorance, but why have multiple versions in Production at once? 

I'd prefer a simpler approach, with...

I don't have the answer, but I do have a suggestion.  Don't use encrypted stored procedures.  They just create unnecessary headaches and don't really buy you added security.  The logic to de-encrypt...

You might be able to write some logic using "DATEPART" to give you the individual components...

>> Too much of activity on the publisher which coused a delay in updating the subscriber and hence the distribution database kept growing since the log reader continued doing what...

Did you check the trunc. log on checkpt (SQL 7) or Recovery Model (SQL 2000) for the "distribution" DB?  Should be set to "truncate" or "Simple" model.

You didn't say what...

Spent a while trying to figure out what the heck you were talking about with  "empty result sets", but now I think I know.  Try adding this magical little line somewhere near...

Well, since the trigger works against the production server but fails against the development server, I'd be curious if there's something different about each environment and/or the version of SQL...

We monitor cluster failover using the SQL errorlog info--using a technique like someone described above--basically by running a process that reads in and checks the SQL error log every 15 minutes or so.

In...

There's an example of a linked server connection to Excel in SQL Books Online under "sp_addlinkedsrvlogin".

Yes indeed--I ran into similar problems scheduling DTS packages in the past.   Invariably stuff works great when run interactively, but fails miserably when scheduled under the SQL Agent because of permission...

SQL Books Online will tell you almost anything you ever wanted to know about these topics (but were afraid to ask).