Why? Changing Passwords? Maintenance?

Maybe I need to change the way I go about it......

Have you tried setting up connection strings's with the proper logins and passwords in the default's for your webservers......That's the way we do it.

We have a specific login id for...

I was aksed to track the same type of thing on an asp application in a prior job. I set up a test enviroment to duplicate the real one, and...

This is just my opinion, but wouldn't Person and Task be your entities, and TimeSpent and Date be descriptors of these entities.....

What would be the objective of creating Date and...

17903 is a connectivity error, generally meaning a bad password or username. The times I've seen it, it turned out to be the agent login didn't have rights to the...

I do the same as pnewhart except that my trans log backups are 5 minutes apart. For me and our purposes, thats as good as a point in time.

I do the same as pnewhart except that my trans log backups are 5 minutes apart. For me and our purposes, thats as good as a point in time.

Here is a reduced code set which I hope will be useful to you. Modify it to your use. I quickly concatenated it together and stepped through it once but...

I apologize. This thread slipped by me, and I just remembered to check. Of course, Let me clean it up slightly, and it will be my next post. Again,...

In the course of writing some VB apps for some clients of mine, I ran across a similar problem. Using MDAC 2.5, the software compiled and would install on the...

He's right. That would be more efficient as well. Assuming the column's data will allow a unique constraint.

Will that work for you?

Edited by - Scorpion_66 on 10/09/2002 08:45:16 AM

give me the table names, and field names involved, and I'll write it for you....

It could be done easily with an insert, update trigger.

Are we making the assumption that the field types are the same? And the fill factor....

all of the third party software that I have had experience with, uses far more resources than native sql backups. I do not allow them on my servers. I require...