I am pretty sure it's because you specified a directory in the backup rather than a file. You need to name the actual file that you want to backup...

I am not really 100% on what you are asking for, but if you are asking if there's a way to trace only selected stored procedures, the way would be...

I think this will get you what you need unless I am misunderstanding the issue.

select * from sys.objects o

inner join sys.schemas s on o.schema_id = s.schema_id

where s.name =...

Programmatically, you can use WMI to check the Event Log (Application log) for the success or failed login

It's going to be difficult to help tune a stored procedure or a table's indexes without also seeing the code for the stored procedure, and the execution plan.

I am not sure what's going on, and can offer little help other than mentioning that message you posted is normal. This is not a sign of your problem....

Like so...

select top 1 ID

from (select top 5 ID

from table1

order by ID ASC) t

order by ID desc

Yes, this is a problem due to shared / common files.

This what you are looking for?

select

objtype,

usecounts,

cacheobjtype,

plan_handle

from

(

Select s.objtype,

s.cacheobjtype,

s.plan_handle,

s.usecounts,

...

Couldn't you go old school and use a .bat file for this and have it scheduled via the scheduler of your choice (SQL Agent, Task Scheduler)?

Have you tried using SQL Compare from RedGate or even the Schema Compare tool included with Visual Studio 2008 Database Edition?

Networkservice is likely the default service account for ASP.NET service? Maybe change this to a domain account?

Delete statements are logged to the transaction log, and thus slower than a TRUNCATE for example which is not logged.

The speed of a delete will depend upon many...

joshua,

Thanks for the post, you saved me from short term insanity. :crazy:

Execution plans do in fact change, some slightly, some more so from 2000 to 2005. Did you update all statistics (preferably with fullscan) after migrating to SQL 2005?