× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Nilesh Mali
nileshhmali reported 2014-05-16T10:31:45Z  · tariqrahiman last modified 2014-10-24T20:57:58Z

ENCRYPTION view script not generated in view source pane for Sql server-2000.


Dev
John LH
JohnLH
QA
Tariq Rahiman
tariqrahiman
Priority Low
Complexity Unknown
Component App - General
Version Future
ADS version:ADS-15.0.0-dev-285
 
Connect Ms sql Server-2000
Create table
CREATE TABLE "dbo"."emp"  ( 
"c1" int NOT NULL,
"c2" int NULL,
"c3" int NULL,
"c4" varchar(25) NULL 
)
GO
 
CREATE VIEW "test_Encryt" (c1,c2,c3,c4)
WITH ENCRYPTION
AS 
SELECT * FROM "dbo"."emp"
GO
 
Right click on "test_Encryt" view
Select Script object to window as->Select CREATE parameter.
Generate below sql script:
 
�那㴑焞瓁撒偔캞㯂俁㼃ㅝ쩝諁袜̗뢐߫姻캹ᯟ縃뚗ӟ唰䡳詬ꛅ䬩颌䩀胁帤뢅聯섮�袰㐲蒼뭀௖掴ﲎẛᤔﱈᗦʜ厇ꡬⓆ뮞香㉭ū�꟠睁蠕覍³盻濮Әະ먣蓦Ⲏⱥ฀᜵溽捚ầ朁뜫
GO
 
Right click on "test_Encryt" view
Select Alter view option
Alter view windows opens
 
Now you will observe that,ENCRYPTION view script not generated in view source pane. 
 
Please refer below link:
http://technet.microsoft.com/en-us/library/aa258253(v=sql.80).aspx
4 attachments
  •  
  •  
  • No shares
  •  
All Comments (2) Change History
Sort 

Issue #12143
Closed
Won't Fix
Resolved 2014-05-20T06:10:48Z
 
 
Completion
No due date
No fixed build
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017