In SQL Server 2000 sp_configure‘allow’,1 GO Reconfigurewithoverride GO Updatesysdatabasessetstatus=status&(~32768)wherename=‘SQLDBPool’ GO sp_configure‘allow’,0 GO Reconfigurewithoverride go
IN SQL Server 2005/2008 ALTERDATABASEsqldbpool SETonline
when i run the “restore veryfionly from disk=’path'”
then i got the folling error please give reson for that i.e why it will get that error message
Msg 3201, Level 16, State 2, Line 1
Cannot open backup device ‘E:\SQLLOG\SQL12\dhamodharan.ldfD’. Operating system error 2(The system cannot find the file specified.).
Msg 3013, Level 16, State 1, Line 1
VERIFY DATABASE is terminating abnormally.
aiDeeva.com 
the abow command is also not working i.e when i run the abow command then i got an error please give me another method
Hi jugal shah,
when i run the “restore veryfionly from disk=’path'”
then i got the folling error please give reson for that i.e why it will get that error message
Msg 3201, Level 16, State 2, Line 1
Cannot open backup device ‘E:\SQLLOG\SQL12\dhamodharan.ldfD’. Operating system error 2(The system cannot find the file specified.).
Msg 3013, Level 16, State 1, Line 1
VERIFY DATABASE is terminating abnormally.
Check for the required permission, it seems you are verifying the transaction log file, restore verify only work with backup files only.
This is wrong T-SQL query it should be sp_configure ‘allow updates’ ,1 instead of sp_configure ‘allow’ ,1
Have you checked it with SQL Server 2000?