Restore the Stored Procedure - No backup

Hi all
I hv wrongly updated some stored proecedures in my database. I dont have
backup and i didnt put begin trans. Is it possible to rollback or anyother
option (restore the database in the stage before one hour like that).
Regards
B. Sundar
You might get some help from a tool which reads the tran log from lumigent
( log explorer, www.lumigent.com)
But otherwise no other way... Of course, you should put all of your code
( including SPs, etc ) in change control, but that doesn't help you now...
sorry
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Sundar" <Sundar@.discussions.microsoft.com> wrote in message
news:DEB3A28F-2EF9-4547-B342-B836A26CFBF0@.microsoft.com...
> Hi all
> I hv wrongly updated some stored proecedures in my database. I dont have
> backup and i didnt put begin trans. Is it possible to rollback or anyother
> option (restore the database in the stage before one hour like that).
> Regards
> B. Sundar
sql

Restore the Stored Procedure - No backup

Hi all
I hv wrongly updated some stored proecedures in my database. I dont have
backup and i didnt put begin trans. Is it possible to rollback or anyother
option (restore the database in the stage before one hour like that).
Regards
B. SundarYou might get some help from a tool which reads the tran log from lumigent
( log explorer, www.lumigent.com)
But otherwise no other way... Of course, you should put all of your code
( including SPs, etc ) in change control, but that doesn't help you now...
sorry
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Sundar" <Sundar@.discussions.microsoft.com> wrote in message
news:DEB3A28F-2EF9-4547-B342-B836A26CFBF0@.microsoft.com...
> Hi all
> I hv wrongly updated some stored proecedures in my database. I dont have
> backup and i didnt put begin trans. Is it possible to rollback or anyother
> option (restore the database in the stage before one hour like that).
> Regards
> B. Sundar

Restore the Stored Procedure - No backup

Hi all
I hv wrongly updated some stored proecedures in my database. I dont have
backup and i didnt put begin trans. Is it possible to rollback or anyother
option (restore the database in the stage before one hour like that).
Regards
B. SundarYou might get some help from a tool which reads the tran log from lumigent
( log explorer, www.lumigent.com)
But otherwise no other way... Of course, you should put all of your code
( including SPs, etc ) in change control, but that doesn't help you now...
sorry
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Sundar" <Sundar@.discussions.microsoft.com> wrote in message
news:DEB3A28F-2EF9-4547-B342-B836A26CFBF0@.microsoft.com...
> Hi all
> I hv wrongly updated some stored proecedures in my database. I dont have
> backup and i didnt put begin trans. Is it possible to rollback or anyother
> option (restore the database in the stage before one hour like that).
> Regards
> B. Sundar

Restore SQL server, Login failure

I restored a DB to another server and then i used the stored procedures

exec sp_addlogin on the master DB and the exec sp_change_users_login on the DB that I have restored. When i try to run a sproc I am getting

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

I have used windows authentication to login to connect to the server using sql management studio

Am i missing something. Thankyou for the help

How do you call the stored procedure and what does the stored procedure do?

Thanks
Laurentiu

Restore sp_grantdbaccess

I need to know how to restore a stored procedure that was deleted. I created
a new one, but it is set to user type and doesn't work. I don't know how to
pull it out of a master db backup. Any help would be GREAT.
Thanks,
FrankI assume this is 2000. I'd check the installation scripts in the install folder of your SQL Server
installation. You will fine one or a few which installs the system procedures and based on that code
within that script you will see how to add it as a system procedures.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Frank" <Frank@.discussions.microsoft.com> wrote in message
news:5848753F-E15B-486C-BC27-4EBD24ECC960@.microsoft.com...
>I need to know how to restore a stored procedure that was deleted. I created
> a new one, but it is set to user type and doesn't work. I don't know how to
> pull it out of a master db backup. Any help would be GREAT.
> Thanks,
> Frank|||Yes, 2000. I have the SQL out of the the SP, but when I recreate it it has a
user type and not system. Tells me i don't have access to active directory.
"Tibor Karaszi" wrote:
> I assume this is 2000. I'd check the installation scripts in the install folder of your SQL Server
> installation. You will fine one or a few which installs the system procedures and based on that code
> within that script you will see how to add it as a system procedures.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Frank" <Frank@.discussions.microsoft.com> wrote in message
> news:5848753F-E15B-486C-BC27-4EBD24ECC960@.microsoft.com...
> >I need to know how to restore a stored procedure that was deleted. I created
> > a new one, but it is set to user type and doesn't work. I don't know how to
> > pull it out of a master db backup. Any help would be GREAT.
> > Thanks,
> > Frank
>|||You need to dig further into that script file. In the beginning of the script, it should execute a
system stored procedure which result in every following procedures created are classified as system
stored procedures.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Frank" <Frank@.discussions.microsoft.com> wrote in message
news:26C50283-2EC2-4A5D-8436-1027E5B79D08@.microsoft.com...
> Yes, 2000. I have the SQL out of the the SP, but when I recreate it it has a
> user type and not system. Tells me i don't have access to active directory.
> "Tibor Karaszi" wrote:
>> I assume this is 2000. I'd check the installation scripts in the install folder of your SQL
>> Server
>> installation. You will fine one or a few which installs the system procedures and based on that
>> code
>> within that script you will see how to add it as a system procedures.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Frank" <Frank@.discussions.microsoft.com> wrote in message
>> news:5848753F-E15B-486C-BC27-4EBD24ECC960@.microsoft.com...
>> >I need to know how to restore a stored procedure that was deleted. I created
>> > a new one, but it is set to user type and doesn't work. I don't know how to
>> > pull it out of a master db backup. Any help would be GREAT.
>> > Thanks,
>> > Frank
>>

Restore objects from backup.

Hi experts,

Is there any way to restore the table structure or stored procedures alone from a database backup ?

Thanks & Regards,

DBLearner

There are no direct ways to that. Anyway, you could restore database with another name on the server and copy whatever you want from it.
|||When restoring a SQL Server backup you have to restore all the data. After restoring you can trucnate the tables which will give you the schema and procedures only.|||

No there is no way to restore a table structure from a database backup without restoring the entire database.

regarDs,

Jacx