Drop database <DBname> should work irrespective of the state.

Hi Bru

but the job works fine when run manually,, does it still matter...

Is the server 32 or 64 bit?

I had this,, I restarted SQL server agent and the schedule started to work. I still haven't got an answer as to why it stopped working...

Is it 32 or 64...

Do you get an error? Or do you mean it doesn't run at all...

Hi Madhu

Have a look at this post:

http://www.sqlservercentral.com/Forums/Topic710120-357-1.aspx?Highlight=class+registered

See if this helps.

Hi Madhu

You normally get it in windows related errors. Which logs did you see this?

You can find more information or download this from

http://www.dll-files.com/dllindex/dll-files.shtml?dbghelp .

I am not sure if...

DECLARE @TestString VARCHAR(256),

@MaxLength INT;

SELECT @MaxLength = 256; --Should be same as the VARCHAR() definition of @TestString above or column...

Have u installed SP2?

Check the logs for more information. see if you can find the dll then register that dll again. If not post what is in the log about...

It looks like one of the dll is incorrectly registered. Have you done an upgrade? What maintenance plan are you creating?

I had to do this recently..

This is what i found:

DECLARE @DateOld datetime, @DateNew datetime SET @DateOld = '23-Nov-2009' SET @DateNew = GETDATE()

SET DATEFIRST 1

SELECT DATEDIFF (day, @DateOld, @DateNew) -...

Please check permissions for the database.

Have you tried:

USE master;

GO

ALTER DATABASE <dbNAME>

SET SINGLE_USER

WITH ROLLBACK IMMEDIATE;

GO

ALTER DATABASE <dbNAME>

SET READ_WRITE;

GO

ALTER DATABASE <dbNAME>

SET MULTI_USER;

GO

Cool. got rid of the duplicates. it works like magic. It's easy when you know. Thank u so much.

This is the data i have after inserting extra 3 records that you mentioned above.

CCIDSnoItemAmount

XX11AA10

XX12BB30

XX23CC30

XX24DD40

XX25EE50

XX36FF50

XX210CC30

XX24DD40

XX25EE50

Hi Arun

I am getting this error: when i run the query

select a.CCID,

SUM(a.Amount) as Amount,

case when a.Sno IS Null then MAX(a.Sno)+1 else a.Sno end SNO,

(select item from #temp1 b where b.SNO...