I saw this on Tek-Tips.com. While it is for MSDE, it seems to be the same problem you are having. Try following the directions but using the SQL Server...

Did you run it as STARTEAM or servername\STARTEAM?

-SQLBill

ilan,

Try this:

Script:

DECLARE @StartTime datetime, @EndTime datetime ,@Today smalldatetime,@Today2 smalldatetime

SET @Today = GETDATE()-4

SET @Today2 = GETDATE()-3

set @StartTime = @Today + ' ' + '16:00'

set @EndTime = @Today2...

(quote) not sure why SERVER\Instance name stopped working (end quote)

This usually indicates that the DNS server is not resolving names. Maybe you are going through a different DNS server...

I don't know the solution to your issue, but for the error log do this:

Run

EXEC SP_Cycle_Errorlog

Then find where the error logs are stored on your server. Usually on the C...

Is this a database created by an application? Some vendors create maintenance plans within their application. We have two that are that way, but the interface allows them to...

Nope. I can't quote the source, but I've seen that it's bug that Microsoft doesn't feel is worth fixing - so call it a feature.

I have been trying to...

Vijay,

I only see one table being shown, so that's all I can work with to provide an answer.

You need to provide what tables you have, what columns are in the...

mkeast,

Since it's GETDATE()-2 and GETDATE()-1, if it's Nov 4th, then:

Nov 4 - 2 = Nov 2

Nov 4 - 1 = Nov 3

-SQLBill

BTW- here is a neat trick to make sure you don't restore data past your stopat time.

Use the STOPAT option in ALL of the log restores. There is nothing that...

We are getting somewhere now...your problem is with the presentation of your date. SQL Server doesn't know what 01/11/2005 is. It could be January 11, 2005 or it...

Are you trying to get the data where it's not in Category A or Category B, or not in both of them?

BookId Category

1 ...

Does this work?

SELECT *

FROM [Stock Movement History]

WHERE [Date] = (SELECT MIN([Date])

FROM [Stock Movement History])

-SQLBill

First you need to get rid of the time from GETDATE().

SELECT CONVERT(VARCHAR(8), GETDATE(), 112)

Then you need to add the new time to that:

SELECT (CONVERT(VARCHAR(8), GETDATE(), 112)) + ' ' +...

What isn't understandable about that?

Group needing full rights - give them database owner permission.

All other groups - give them only datareader permission

-SQLBill