Probably, but then how would you learn how to do it if we do it for you? Give it a try first, and as you have problems, ask for...

I'b build a clustered index. You may want to analyze the usage on the table. There may be a useful index that may benefit from being a clustered...

Not sure if this is relavent, but an INDEX scan on a clustered index is a table scan.

Lookup xp_logininfo in BOL (Books Online).

The balance may be a rolling balance, but if you...

Magy (12/15/2009)

---

But it didn't order the data according to my ORDER BY clause...that's why I'm confused.

When I run the cursor, and then check the table, it is not...

Also, Jeff asked a question in the other thread that you still should answer.

What you may need to do is write quesries that recalc the balances as of a certain...

It depends.

Also, remember that, if for any reason, you have to restore the database you will have to drop all your snapshots.

one-1016367 (12/15/2009)

---

Nope, no table variables. I'm not at work at the moment, and I didn't write the stored procedure myself so I don't remember the details. I'll paste the...

When initially created, it will be empty. It will start occupying space as your database is updated as it needs to retain a copy of the data as it...

Totally Cute!!

Spot On!!

You never showed us the code. Question, in the code, are you using table variables??

Unfortunately, I can't see what you see. I know that when I run Activity Monitor on my desktop system against one of my servers that Activity Monitor is displayed...

Does the account under which SQL Server Agent run have appropriate permissions to the source and destination directories/shares?