This is a cross tab report. Search on that and make an attempt. We can help if you can't figure it out from examples.

When you read the feed, specifically make the data a parameter. Use stored procedures and don't ever take the chance that the data from your feed could ever get...

Sinanju, haven't read that in a long, long time.

Ah, sorry don't have a better way. Was thinking putting it in one step would help.

I've never heard of this type of scheduling. I guess you could simplify it by...

You are welcome.

Right, sorry, Flip to full, truncate to clear space, flip back.

I want to reset the space usage down and see what happens.

truncate the log (backup with truncate only) and see if it grows again. Check the logspace (as shown above) regularly.

Profiler, and SQL Trace, show you what is happening now. It cannot go back in time. It is a real time tool.

There is a default trace, but I'd guess that...

LOL, probably a good plan. She is coming to PASS in November, but decide to look you up.

Last year we hit an aikido dojo one night. Hoping we can do...

If it returns no open transactions, then either it's clear, or you have other issues.

Can you reboot the server?

I'm confused. What do you mean by "lock"

Prevent changes?

You can remove update permissions from the table, or the column, for a user/role.

You can set a step to go to the next step on success, stop on failure. Set up a starting step to check the day of the month. If it's...

We have a lot of scripts on this site that can help you.

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

are you doing in place or side by side?

The new 2008 server will need to restart in single user mode at some point, I believe, so you can't have people...

That's an interesting question. My guess would be no since the proc license typically supercedes the CAL licenses, but it's an either OR.

Are they authenticated users (in AD)?