Check Processadmin permissions.

As KENT suggested, it will be easier for you if you have a permanent Calendar TABLE insted of TEMP Table.

the link KENT provided is all you need and adding to...

As far as i know, this is the only way to set the identity_insert.

Try to encapsulate the identity insert code into a TRIGGER..(personally never tried That).

If you have multiple Tables,...

No way to Figure out the password or CRACk it. If you however have the DTSRUn command with the pasword in the job, then it be a CRACk.. Sorry..couldnt be...

Check the ISOLATION LEVELS for more info.

First Use SQL Server Express Editions.

Second: Either you can create a SQL Script and RUn it when the applicaiton is EXECUTED or let the SETUP Program (INSTALLER) that comes with...

What Error are you getting?

There can be many errors and Reasons.. check this out: http://support.microsoft.com/kb/317375

is the Database set to AUTO_CLOSE or AUTO SHRINK.. remove these 2 Options.

check the AUTO CLOSE and AUTO SHRINK features in the database..

TURN off these 2 Features and check again.

Here the STEPS you should perform.

Kill destination connections. (run multiple times)

set Db in single_user mode.

RESTORE the LOG

set db to Multi_user

Check your Secondary Database consistency once a week for sure.

DBCC UPDATEUSAGE...

What do you mean by 0 Deadlocks...

According to my MEAN Knowledge, if it is NO (0) deadlocks.. yes it is always possible and Good to have NO Deadlocks...on a...

Just a suggestion: if you are running something with legacy systems or have recently upgraded .. try looking at your MDAC versions.

Question: did you RUN DBCC UPDATEUSAGE and DBCC CHECKDB on the Databases after the upgrade.

Also do you perform a index fragmentation check and rebuild.

For your Current ISSUES: Try UPDATE STATISTICS...

Did u happen to check if there are INSERTS/UPDATES/SELECTS happening on the Database at the same time. the SPID are system SPID's, so better be carefull is you are thinking...

Thanks for the Quick Reply.

how about marking the user as ACCEPTED Answer: like in msdn forums.