John Mitchell-245523 (6/13/2011)

---

Well, yes - but only if such a group exists. By default, all members of the local Administrators group have full access to SQL Server (at least...

If all you're looking for is a count of statements, I'd go with just pulling the data out of performance monitor then. It's standard set of data. As long as...

I can't tell you what backward recovery is, never heard of that one.

Rollback or rollforward is referring to transactions. A rollback on a transaction is to undo whatever that transaction...

aaa-322853 (6/12/2011)

---

Ok guys thanks for your advice to date.

I wanted to provide somekind of update to where my findings have led me, any feedback is welcome as always.

So I posted...

You can use the Data Collector if you have Enterprise edition. That will collect disk usage for you and is built into SQL Server.

And if you go to Tools -> Options -> SQL Server Object Explorer -> Scripting, you can exercise some control over how scripts are generated.

Not a problem. Glad I could help. Also, thanks for posting that it worked. Makes it better for someone reading this later.

Not having your data, it's hard for me test this, but you can try moving the other WHERE criteria into the JOIN clause. When dealing with OUTER JOINs, filter criteria...

You don't need to do that. Just click on the Report button and ignore the post otherwise.

I'm not sure what context you're asking the question, but here's my swipe at an answer.

A migration is moving...

In addition to the order, you also have to worry about permissions. Do you have permissions to create the objects? Once created, do the objects have permissions to see other...

Depending on how you're defining transactions, you could go the Performance Monitor route, which just counts transactions, or you may need to set up a server side trace. You can...

One piece of advice. You're writing your queries using the ANSI 89 standard on joins. Don't do that. As soon as you get to outer joins you're going to have...

Man, I couldn't have been further off track. I totally missed several key words and tricky phrases in the original question. Sorry for any confusion tossed into the mix.

I wrote an article outlining several ways to get versioned data. Latest date is not any different than latest version. Take a look at this[/url] and post back here if...