if due to hardware bottle neck you have any process blocked, and other process is waiting for its release then obviously it can result into dead lock.

Severity level indicates that this error may be due to any hardware problem or may be due to any external software problem other than SQL Server. You may think on...

As terry said: Be sure the account running the SQL Agent has rights to the share.

Normally Trigger is created for an update, insert or delete event. And then it is bind with a table (object) on which it is required. And it is automatically invoked...

You may consider file groups backup strategy. Distribute database on more than one file groups.

Its working now. and thanks for all of you.

Ok , thanks alot christopher. i hope it will work.

I have my production server on SQL Server 2000. So no CTE here.:unsure:

I think calculation is no correct. It could not be 61 (years) from 2002 to 2008. We have to divide the datediff with 12 and some thing like that.

Here is the way i want to calculate the dates for each employee

.

At the end i will have X.Y year as result. I require accuracy till months only.

i require time for each section added. Because there may be gaps between the pairs of dates.

Quatrei, i was required to convert time from msdb..sysjobschedules where it is in int format. Thanks for all of you

Thanks a lot

statistics profile displays the profile information for a statement. STATISTICS PROFILE works for ad hoc queries, views, triggers, and stored procedures.

This procedure reports about a particular remote or replication server, or about all servers of both types. Provides the server name, the server’s network name, the server’s replication status, and...