September 26, 2007 at 11:56 pm
Hi,
We are trying to Import a SQL 2000 (Standard) data base on Windows NT Platform in to another server with SQL 2000 (Standard) on Wnidows 2000. While importing it shows successful data transfer but some of the User made Stored Procedures are not in the list. We have separately tried to import those store procedures but with same result. However when importing to Windows NT the problem is not there. Since those stored procedures are encripted we are not able to copy/Paste or create those in the new database. How can we get those SP in our new database?
Sisir
September 27, 2007 at 1:03 am
Script out all SP and functions to a text file.
Open the text file on the new server and run the code.
N 56°04'39.16"
E 12°55'05.25"
September 27, 2007 at 4:21 am
Dear,
I understood but How to Scriptout the SP & Functions in to a text file?
September 28, 2007 at 3:18 am
Ask Google to find code that gives the original text for an 'encrypted' stored procedure. SQL Server uses obfuscation to hide the text of a stored procedure, not encryption. It sounds better to the marketing types to use the word 'encryption' instead of 'obfuscation', so that is possibly why these are called encrypted stored procedures when they are not.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply