Is the restore job failing?  On the SQL Server you installed the monitor server goto Management-->Log Shipping Monitor and then right click on one of the monitor jobs and click...

This may help!

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q310834

Two queries, one temp table and a reverse ranking by identity column!

1. Create a temp table for your data with the first column being an identity column.

2. Select the data into the...

If Exists (Select empid From dbo.employees where empid = @empid)

Begin

Update

--test for error and take action ...

End

Else

Begin

Insert

--test for error and take action ...

End

Query msdb.dbo.sysjobs and msdb.dbo.sysjobschedules! I do not have time right now but can put the SQL together tonight if someone does not post it!

insert into glb_email (type, title, subject, body)values('PAS-1', 'Add New Password, 'Subject Text', REPLACE('

We understand that you have recently or may soon receive.

For your convenience, allows you to provide this...

Try this:

SELECT     TOP 100 PERCENT *

FROM         dbo.MAINB

WHERE    DateDiff(ss, tarih, '01/11/2005 16:00:00') <=0 And DateDiff(ss, tarihB  '01/11/2005 20:00:00') >= 0

AND (meosar LIKE '1')

This will give you records that have 'tarih' a...

I am making the same assumption and was trying to walk him, into it!

I don't reccommend doinf DBCC's, Index rebuilds or stats on system databases if that is attempted here.

Integrity...

I was asking in reference to the patch for sp4.

Capture the start and end times in a log or log table and discard the resulting output.

So Have you given it a shot with the implicit conversion of the varchar back to a datetime?

Removing the data being retuned to an application will more than likely reduce the amount of time and work to be done.

Which job is failing?

What data type is the column tarihb? I would also use (tarih >= Convert(DateTime, CONVERT(varchar, DATEADD([day], - 1, GETDATE()), 112) + ' 16:00:00')) AND (tarihb <= Convert(DateTime, CONVERT(varchar, DATEADD([day], 0,...

Last question! If you execute the procedure from query analyzer on qa and production, what is returned from the procedure?