first find out how much extra space is there in the db, shrinking it etc.

Thanks everyone for your inputs...

Thanks for your response... I tried this as below..

use testdb

go

set ansi_padding OFF

--drop table t1

create table t1 (RowNum INT IDENTITY(1,1), col char(5) NULL)

Go

insert t1 select 'abc'

insert t1 select ''

insert...

It worked Thanks a lot...

select '<MESSAGE type = "XYZ" Content ="XYZ"

...

SELECT ' '

ok can you help me with this one, this line is a part of my stored proc.. how do I remove " in front of XYZ and use ASCII code....

Is that backup folder shared??

Did you start backup job again manually?

Does that show any error on sql error log?

Are you using trusted connection to login to the server? you can use -E if yes.

chicagonj,

did you try killing this spids and dropping the objects? did it work?

Use following tables from MSDB in your query and it willgive you allthe necessary details.

sysjobs, sysjobhistory, sysjobschedules, sysjobservers & sysjobsteps...

----------------------------------------------------------------------------------------

Try this --

Alter this view alltogather to a different code since you anyways want to drop it.

ex. alter view "viewname" as select getdate();

& then try dropping it.

use sp_depends and see if there are any dependencies on this table/view? There might be some parent-child relationship for this table to other tables.

You have to drop view first if...