Backing up to a remote location is going to be extremely slow.

Respectfully, have you looked at the DateDiff Function?

http://msdn.microsoft.com/en-us/library/ms189794.aspx

Have you tried it or even Googling it?

I believe that you can.

If you disagree e-mail the Author or better yet try it yourself.

I would not get hung against the axle...

I do not know what the requirement is in this situation but if a user wishes to view a SSIS package they will need a user password....

I do not know of an extended procedure that does this.

Do you want to perform this action for SQL Server of from a Windows Script?

http://msdn.microsoft.com/en-us/library/cc280386.aspx

http://www.databasejournal.com/features/mssql/article.php/3562406/SQL-Server-2005---SQL-Server-Integration-Services---Part-12---Logging.htm

Perhaps I'm asking too much but could you provide the DDL, the DM to insert the Data and your Statement so that you may be better assisted?

Thanks,

WC

I'm sorry Gail.

When I posted my reply your response was not active.

I would have not have responded if I had observed your post...

Respectfully,

In order to be provided with assistance you should provided more detailed information about your problem.

I'm not going to plagurize anyone else but if you search this site you will...

How often do you refresh the development & QA Environments?

I wrote DTS and SSIS Packages to do this on a routine basis.

This has to be be coordinated and your developers...

cowabunga,

I know exactly what you are going through...

Regards,

Welsh "Dick" Corgi

I suspect that the reason that the users are accessing your application via Access & Excel is because that they can't get what they need via your VB.NET Application?

To provide...

In my humble opinion Triggers seems to be the only viable option.

Since the changes involve more than one table a Check constraint will not work.

Since Users are accessing the Database...

....

I'm sorry but I will defer to the distiquished members of this forum.

Unfortunately I have gone through some tough times and I do not feel that I could give good...

I'm sorry, I did not understand what you meant by the following:

-----------------------------------------------------------------------------------

I would hope that changing your avatar and community pen-name in relation to this

-----------------------------------------------------------------------------------

WHat are you saying that I...