• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 187
  • Last Modified:

Lost Important Stored Procedure ~ Autosave?

Hi, I was working on an important stored procedure in a query window in management studio.  The power went out before I was able to create the procedure in the database.  Does SQL Server autosave to a temp location or store any of that data somewhere?  I only ask because I know Excel saves copies of spreadsheets to a temp directory even if you don't have autosave turned on.

I will be a very happy camper if this is true.  Thanks in advance.
0
Roxanne25
Asked:
Roxanne25
  • 2
  • 2
  • 2
  • +1
2 Solutions
 
OtanaCommented:
Not in SQL Server 2000, I don't know about 2005.
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
are you importing the procs or Genrating the 'crearte Script'  ?
0
 
SQL_SERVER_DBACommented:
no
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Roxanne25Author Commented:
I was using the query editor to create with a script.   I guess its gone then.... *cries*
0
 
SQL_SERVER_DBACommented:
sorry roxy
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
yup, its gone :(
0
 
Roxanne25Author Commented:
Thanks for the condolences... back to rewriting it. :(
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 2
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now