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...

This isn't necessarily stored anywhere. You could build a table to hold this and then set a DDL trigger on the server login event to update this table with GETDATE()...

Page locks are ok, row locks better, table locks worse.

Blocking means that he's got transactions taking too long. You want to lower the amount of time locks are being held,...

Never did COBOL, but when I got to college at Syracuse, everything was remote terminals on IBM and VAX machines. We had a central print center in one building to...

I hadn't thought about it too much, but I was probably immature in my early career. Over the years I have seen more and more woman in business all over...

Hey, a fellow Orangeman. Glad to see you stuck it out. Too cold and $$$ for me, so I went to UVa where I could still wear my blue and...