I'm assuming this means that you solved the problem yourself?

Please post a followup that explains what worked so we know it's solved.

You also need to provide a user/password in mixed mode. Without a domain, you would add a "SQL Server Authenticated" login to SQL Server, then use the same name/pwd in...

I'd use ALZDBA's solution.

If that doesn't make sense, give us an idea of what the conditions are and we can help (tables/cols)

The only thing that I've done in the past is check for a change to the user. When the user changes a password, the data in syslogins is updated (some...

I believe because of the SID mapping in 2000 that you can only have one login in each db mapped to a user. So you'd need to make the changes...

In 2005 you have all sorts of event triggers (look up Event Notifications) for logins and changes.

For data changes, you really should use Profiler with a server side trace. It...

Can you provide some more information?

When you log in through ODBC, which login do you use and what are the rights?

When you create a table, how do you do it...

What is in the package? This is definitely some type of network error. Are you sure you're checking the names referenced in the package? You might try saving it out...

Moved to the Anything not SQL forum.

Please watch your forums. This was in the SQL 2000, General area. It has been moved.

I don't think this is possible. You can filter by table, which could help if you know the tables with triggers, but I don't think this is possible.

What are you...

If this is homework or an interview question, please solve it yourself.

Also, you should post your own attempt when asking others.

Do you mean the filename?

http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/31640/

Be careful with this and monitor it carefully. The backup process doesn't tolerate any delays well and will fail if the network hiccups. You'd really be better off buying more...

Most things are on the list. It's a question of priorities and resources, both of which are limited right now. Some changes coming tomorrow (fingers crossed) and then we'll look...