are you able to connect through SSMS if sql2k5 or Enterprise manager sql2k?

can you check the application logs in event viewer? best will be attempt to restart the service and then check what is logged in application log.

run this

declare @STR varchar(max)

create table #tmpspace (name varchar(100), rows int, reserved varchar(200), data varchar(200), index_size varchar(200), unused varchar(200))

select @STR = isnull(@str,'') + ' insert #tmpspace exec...

🙂 i should have mentioned this before only, neverthless I disable LS restore jobs and let the LS copy jobs run, after i am done iwth backup restore I enable...

start sql browser service...

I have encountered this issue in my prod enviornemt, you need to keep and eye on LS using Log Shipping monitor, it will tell you when the last restore happened,...

use this, it will give you text for all the sp's, you can then find name of your table and make the changes accordingly, please ensure that your query result...

use this, it will give you text for all the sp's and then you can serach your table name, please ensure that your query result mode is text (press...

if it's sql 2000 then you just need to select all the sp's and then script however its quite tricky in sql 2005, you will have to make use of...

hey sejal thanks for extension, can you please show me with example on making this parametrized will be of great help for me as well...

Is is sql server 2005? if yes this is how you can achieve it without using cursors, while loop...

declare @execstring varchar(max)

declare @0 varchar(1)

set @0=0

select @execstring = isnull(@execstring,'') + ' update...

I would suggest you to copy the above code and save it in a sql file on your machine,

let say the file is called as testsql.sql

from command prompt you have...

In my organisation, we store all the database objects in version control, its always a best practice to use version control, sp_depends procedure will not return you name of the...

This is what i would suggest, will work well with SQL Server 2005. If you need the same in SQL server 2000 then you can replace @STR varibles...

you definatley need to read BOL, however i guess you must be beginner so if you dont want to get confused with syntax in bol, refer the below code

backup...