But how would I determine who is using the most resources?

It...

I don't see the spid or account...

🙁

I go to Recent Expensive Queries, and I see a nice listing of various queries.

The columns I have available are:

----

Query

Executions/min

CPU

Physical Reads

Logical Writes

Logical Reads

Average Duration

Plan...

How does database mail work anyway?

It's an external application right?

It runs on some sort of timer or something and its job is to take what I pass it, store it...

What I basically want to do is add up all 6 columns.

So NULL = 0 and NOT NULL = 1, then at the end I will add all 6 columns...

I have no good reason to NOT do merge replication, I will read up on that.

Thanks!

EDIT:

OK, I recall now.

It was because I was under the impression that merge had a...

Yeah, all painfully true points.

In this case we are working to migrate off Access and replacing with a WPF app.

However, that will take a year to complete and this is...

Mike-336008 (1/27/2010)

---

I may not be quite understanding the question but if you loaded this into a table (leaded into EntryDateTime order) and included an identity column, you could do a...

Thanks, anything other than check database that I should do, or does that pretty much over it?

That did it, I had disabled my SA account.

So I renamed it, gave it a good strong password, and then it seemed to work fine.

So does it HAVE to be...

Nice Marmot (11/27/2009)

---

Hi Maxer,

Good luck with the exam. You might want to take a look at http://www.wrox.com/WileyCDA/WroxTitle/Professional-Microsoft-SQL-Server-2008-Administration.productCd-0470247967.html. (I prefer books that I can later use for reference or examples, rather...

Makes good sense, thanks!

Finally got it sorted.

Ended up using a script task to msgbox out the value each time to ensure it was doing what it was supposed to.

Turns out it was.... which...

It is running as Local SYSTEM, not service.

Apologies, that was my fault for typing that wrong.

But in this case it is also only on a local testing box.

Pedro Perfeito (8/6/2009)

---

I made an example for those people that still need:

http://biresort.net/blogs/pedrocgd/archive/2009/08/06/stepbystep-ssis-extract-data-from-multiple-excel-worksheets.aspx

I hope this help.

regards,

Pedro

http://www.pedrocgd.blogspot.com[/quote%5D

That URL no longer seems to work, I don't suppose you still...

Thanks!