| Author |
Topic |
|
priyaram
Yak Posting Veteran
82 Posts |
 Posted - 2007-01-29 : 16:55:41
|
| I am trying to get the create script fot a function, but it's giving me the following , how can i get the script by overcoming this error.error:===================================Script failed for UserDefinedFunction 'dbo.test_decrypt_KEY'. (Microsoft.SqlServer.Smo)------------------------------For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Script+UserDefinedFunction&LinkId=20476------------------------------Program Location: at Microsoft.SqlServer.Management.Smo.Scripter.ScriptWithList(DependencyCollection depList, SqlSmoObject[] objects) at Microsoft.SqlServer.Management.Smo.Scripter.ScriptWithList(Urn[] urns, SqlSmoObject[] objects) at Microsoft.SqlServer.Management.Smo.Scripter.Script(Urn[] urns, SqlSmoObject[] objects) at Microsoft.SqlServer.Management.Smo.Scripter.Script(Urn[] urns) at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ScriptGenerator.ScriptCreate(Server server, Urn[] urns, SqlScriptOptions options) at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ScriptMenuHelper.OnScriptToNewWindow(Object sender, EventArgs args)===================================Property TextHeader is not available for UserDefinedFunction '[dbo].[test_decrypt_KEY]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. The text is encrypted. (Microsoft.SqlServer.Smo) |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-01-29 : 16:56:41
|
| Please post whatever code is failing.Tara Kizer |
 |
|
|
priyaram
Yak Posting Veteran
82 Posts |
Posted - 2007-01-29 : 17:06:26
|
| it's failing on the following code:Error: The Execute method on the task returned error code 0x80131500 (The UserDefinedFunction '[dbo].[test_decrypt_KEY]' cannot be scripted as its data is not accessible.). The Execute method must succeed, and indicate the result using an "out" parameter. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-01-29 : 17:10:30
|
| That isn't code.Tara Kizer |
|
|
|
priyaram
Yak Posting Veteran
82 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-01-29 : 17:16:08
|
| I don't see how we can help you without the code that is failing. You are posting errors, not code.Tara Kizer |
|
|
|
priyaram
Yak Posting Veteran
82 Posts |
Posted - 2007-01-29 : 17:19:25
|
| i don't find any code . is there any specific place i have to look for the code |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-01-29 : 17:23:28
|
| I am so confused. What are you doing to cause the error?Tara Kizer |
|
|
|
amarzi
Starting Member
1 Post |
Posted - 2008-09-29 : 17:44:45
|
| I have the same problem and this has nothing to do with code. For me, it is happening when I right-click on a Tabled-value Function to generate a create script. Additional information is below. It is worth noting I am in the dbowners group."Property TextHeader is not available for UserDefinedFucntion '<function>'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. The text is encrypted. (Microsoft.SqlServer.Smo)" |
|
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2008-09-30 : 07:14:02
|
| This function is encrypted. So, you will not be able to view the code.Look at the properties to confirm. |
|
|
|
|
create script error