Search Results

Search found 4 results on 1 pages for 'paranjai'.

Page 1/1 | 1 

• SQl server 2008 permission and encryption

  - by Paranjai

  i have made columns in some of the tables encrypted in sql server 2008. Now as i am a db owner i have the access to encode and decode the data using the symmetric key and certificate. But some other users have only currently datareader and datawriter rights ,and when they execute any SP referring the logic which uses the key and certificate "User does has not right on the certificate to execute". What rights / exact permission should i grant them just to solve this problem

  Read the article

• CSV is not creating format problems with integer value when generated through SSIS package

  - by paranjai

  Hi I am trying to generate a CSV file from DB Query as source one of my column is having datatype nvarchar(50) with values as "01050007029604301001" After the export when the csv file is viewed using Excel the value appears as "1.0500E18" . How can i stop this . Please suggest

  Read the article

• changing default hierarchy of Cube dimension

  - by paranjai

  Hi , I have created Dealer dimension in SSAS 2005 and it has 3 hierarchies. By default the hierarchy created first is the default hierarchy of the dimension. Is there any way to change the default hierarchy to another hierarchy.

  Read the article

• SQl server 2008 permission and encryption

  - by paranjai

  i have made columns in some of the tables encrypted in sql server 2008. Now as i am a db owner i have the access to encode and decode the data using the symmetric key and certificate. But some other users have only currently datareader and datawriter rights ,and when they execute any SP referring the logic which uses the key and certificate "User does has not right on the certificate to execute". What rights / exact permission should i grant them just to solve this problem

  Read the article

1