Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
esmayuser
Starting Member
3 Posts |
 Posted - 2007-02-12 : 00:46:02
|
| I wrote a script about 12 months ago and I have lost my saved version of it. Is it possible that it may stored in a log file of all the scripts that I have run in past 12 months? I've heard about SQL Query logs but I don't know anything about them.EasyUser. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-02-12 : 00:50:48
|
You can still access to your script (you mean Stored Procedure, functions ?) from the SQL Server. Use Enterprise Manager (2000) or SQL Server Management Studio (2005) to script out the Stored Procedures, functions etc.
KH |
 |
|
|
esmayuser
Starting Member
3 Posts |
Posted - 2007-02-12 : 01:08:56
|
| It was not a stored procedure and it was not a write script. It was just a script I wrote to read from a few tables. Would this have been stored in any log file? |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-02-12 : 01:39:29
|
no
KH |
|
|
|
esmayuser
Starting Member
3 Posts |
Posted - 2007-02-12 : 01:41:58
|
| Thanks |
|
|
|
|
|
|
SQL Query Log