You can limit profiler so that it only captures information on SP's that run longer than a set duration, then again that doesn't really help if you want to identify...

select datepart(yy, date) as year, datepart(mm, date) as month, *

from yourtable

where datepart(YY, date) = '2004'

order by datepart(yy, date), datepart(mm, date)

I've broken it down into month too so you can...

one word 'Profiler'.

Set up a trace to monitor SQL:Batch Completed and enable it only for the DB that you want to monitor.

As for how many times the queries are being...

I gave it a go with a fairly complex SP and it took much longer to complete than just executing the SP by itself

of course, what a plonker.

I have no defense, I must have been having one of those days yesterday

that's one way of doing it, but as a general rule, especially in production systems I don't like AV software being there, if nothing else then its going to consume...

I for one hate the idea of putting anti-virus software on a SQL Cluster, sure it's possible but if you have your network security configured properly then the SQL boxes...

Doesn't it just backup the database to a file called 'NUL' in the default backup location?

I've not had a play but off the top of my head that's the most...

Have you checked the client connectivity on all of the PCs (in ODBC) to make sure that they're all configured to use the same protocol (tcp/ip / named pipes, etc.)

Just adding my comments

There are a few things that you need to keep in mind when detaching and attaching databases.

If you're using full-text...

I'm assuming that this is a production database so you probably want to discount options 2 and 3 straight away.  If you do either of them then you can only...

I know that some people use GO statements in their individual steps, make sure the ones you're scripting dont contain any or you might encounter problems applying the job to...

OK, here's my stab at an answer (there are lots of different opinions ).

A backup window isn't a problem because SQL lets you do online backups.

I would suggest that you...

If you find that the optimiser is making a hash of things (missing an obvious step that will significantly reduce the workload) and the queries are taking too long to...

Yep, because if you're returning a table variable then it has to do a table scan on the results, I hate that there's no way to have statistics or indexes...