Hi,

I didn't got how you detached the tempdb. Its just an idea please take backup of temp db that is existing on different server. Try to restore the database with...

Hi,

Did u tried with Query analyzer. May be somw thing in the settings options has been changed. Did System tables are also not giving any thing.

Hi Prakash,

Below query will provide all the sp in the database. May be to work on this to get what exactly u need.

select * from sysobjects where type='p' 

In...

Hi,

Try with this one It may help your purpose.

select @@servername as Server,

 left(@@version, 26) as Version

declare @dbid int

declare @maxid int

declare @dbname sysname

declare @tablename varchar (255)

set @maxid = (select max(dbid) from...

Hi,

 Write a query

where feature = 0 and 1 instead of typing all 0's and 1's and this will work .

with regards,

 Eshwar