This was not helpful. This result is below:

===========================================

-- FOR INTERNAL USE ONLY ... DO NOT DOCUMENT --

-- This procedure sets a bit in sysobjects. This bit has no meaning,...

Thanks for all your help. The reason why I am doing this is to recycle the server. I noticed that whenever we reboot the server for an application upgrade there...

Is there no one using Log shipping that could help?

Thanks

This link should be helpful:

http://www.microsoft.com/technet/treeview/default.asp url=/technet/prodtechnol/sql/deploy/confeat/sqlha/SQLHALP.asp

Get the high availability white paper.

I got an answer from a MS white paper that says I can set up other full/diff backups with log shipping. I am testing this now to see if it...

You can find information about the sysxlogins table here:

http://www.mssqlcity.com/Articles/Undoc/SQL70UndocTbl.htm

How do I know when a user just logs in as I need to know this and trap the event. I can then check for the password expiration.

Thanks

The application is an access front end using SQL Server as backend. I intend to provide a GUI for the users to change the password once it expires. I probably...

Thanks, what info is held in xdate2?

You are spot on. I have got it sorted.

Thanks a lot for your help.

Regards.

Thanks, this is likely to help. I am now trying to resolve the error:

Invalid length parameter passed to the substring function.

which occured on line one.

Thanks

The column contains data like this:

11 A10 Axxxxxxxxxxxxxxxxxxxxxxxx

There is a request for me to reformat the column such that the column becomes

11A 10Axxxxxxxxxxxxxxxxxxxxxxxx

I hope this...

Sorry about that post. I meant ntusername not hostname. Users login using SQL login but some users have ntusername but some blank.

Thanks

Good job. Just what I was looking for to automate login using VB and DMO.

Thanks for your help. This sounds possible.