The backup db and backup log do different things. Dumping the log will not free up space in the database. If you are running log backups (full or bulk mode),...

I don't believe this information is tracked in SQL Server 2000. If you ran profiler, you might be able to get it, but I'm not sure.

A couple thoughts.

Did you select SQL Server or some other driver?

What type of security options did you set? There's a second and third tab in the add linked server dialog.

Please watch the forums. This is (was) a 2005 forum. The post is moved.

Lumigent also has a product to audit activity on servers. I haven't used either one, but I...

If you've patched the server, you shouldn't need to install SSIS. I believe service pack 2 allows you to run the maintenance plans without SSIS.

Are these files always named the...

I'm a little confused. What does your second log file have to do with backups?

I think you've got a good process there, though instead of removing data, perhaps you want to move off some percentage of good data to a new database with a...

Good luck on the exams.

We bought the forum code, it came with it, I'll take the blame/credit for the bug/feature as needed.

I think you're getting rights to pass through. Why not have them select select from employees? Each individual will look for the table in their own schema only.

select @@trancount

Incremented when you start a new transaction, decremented when it's committed or roll'd back. If 0, no transactions for this connection.

Please watch the forum names. I've moved this to the .NET programming area.

Can you post some code from the client?

What are the data types for these fields? Might not be possible.

There is a DTS Runtime environment in SQL Server 2005 that can let you continue to run old DTS packages. For new ones, you'd be better off learning the basics...

You are having a login issue, not a permissions issue. First you should determine if you need to send a name/pwd. If you are using SQL authentication, you would, but...