So for adhoc (i.e. SQL from the application), we can get the query from the plan cache? Excellent! I'm clearly behind on what's possible in SQL Server.

How far...

Hi John,
Thanks  for the reply.
My problem is getting the full query for the statements. I assume I'm going to have to trawl the application source and stored procedures...

Hi Steve,

Thanks - that's what I thought.

The problem is the customer wants to put representative data in terms of volumes on the new system, but wants it anonymised. If it...

Hi Lowell,

Thanks - that' really useful. I'll give it a go.

Having said that, I read late Friday that Azure 12 will accept indexes with FillFactor specified now. I'm checking with...

Thanks for the links - I hadn't found them despite some creative Googling. It appears from the 1st one that it's possible to reproduce this. To be honest, given that...

Thanks for the info - I'll take on board!

James

Perfect - just what I needed to know, thanks.

James

Thanks for the responses - they're very helpful.

James

Thanks - good point to just keep one trace. If I keep the output lightweight then there shouldn't be too much load on the server.

Thanks for the links - very...

Thanks, everyone, for the pointers.

You've confirmed my thoughts that the DMVs won't give enough/the right information for what I want.

I'm running my trace using sp_trace_create, which I...

Gift Peddie (12/23/2009)

---

James Lavery (12/23/2009)

---

We've got an application written in .NET 1.1 which currently uses MSDE as its database.

In order to make this work with Windows 7 (we never bothered...

So just to be clear, you're saying that (notwithstanding any code changes I might have to make in my .NET 1.1 client to work with 2008) I should be able...