If you use a dateandtime var and a datetime column, use a parameterized query in combination with a datetime parameterobject.

e.g. vbs:

' Handle commandobject

set CmdObj = CreateObject("ADODB.Command")

CmdObj.ActiveConnection = ConnObj

CmdObj.CommandText = "select...

you could set the "audit level" to ALL.

and then import the sql-errorlog at regular basis and filter the sysadm-logins.

you'll have to keep an eye at the sql-errorlog because it...

- A clustered index _contains_ the datapages (leaflevel)  !

- if you create a table on a specific filegroup, if there is no clustering index, the data will reside on the...

capture the query-load and examine it !

You may need to add some indexes, expecialy to support group by, order by operations ! as well as joins !

This way you may...

get the creation of temporary tables out of  the transaction if you can !

So if possible,  create your #tmptbl(s) and then begin tran  ... do your stuff ... commit/rollback and cleanup...

I didn't test this myself, but the doc seems good :

http://www.databasejournal.com/features/mssql/article.php/3467291

now this one is nice to read

imo switch your sql-agent service account to a windows account (grant the account the needed rights to the fileshares)

and...

definitely

And if you pull open the umbrella you can find a YOU !

If you activate the job via EM, the job may run using your windows-auth (it is logged your useraccount started the job).

That would explain why it can reach the share.

- what was the timegap between the backup and the restore ?

- have these procs, .. been created/altered during your backup ? (open transaction will be rolledback during recover)

hey, hey ... apparently I started a workaround section .....

As you all have seen, there's a remark in huge letters stating "... could cost you your job..."

- They must have no confidence at all regarding their DBA's.

- If this is a political issue, have it placed back on the agenda ! In case of disaster, problems,...

is the share granted public read/write ?

read this : http://support.microsoft.com/kb/224071/EN-US/

just to add to Eddie Wuerch 's reply :

- also check if you still use the same recovery mode. Maybe even switch...