I am having following issue.

I created encryption certificate using master 3-4 day before.

I want drop that master key now..

when I tried following thing it gives me error.

1> DROP MASTER KEY

Msg...

great solution.

I guess using wildcard character..

like

select * from student where studentname like 'LC%' ;

is this the one what you are looking for?

Hi friends,

I found this wonderful article with example on

http://www.mytechmantra.com/LearnSQLServer/Using_Transparent_Data_Encryption_Feature_of_SQL_Server_2008_P1.html

from other posts..

But I am still wondering about what is "Overhead" means in encyption?

Please help.

thanks.

Hi,

my issue is

My table is as follows:

CREATE Table Table_Update(TableName Varchar(128) primary key,StartlastWritten datetime, EndlastWritten datetime)

When I run following query :

SELECT 'UPDATE Table_Update SET EndlastWritten= (SELECT MAX(LASTWRITTEN)

FROM [13.137.16.51]..PBR.' +...

Hi Champion,

when i used your second option , I got following errorrmessage.

here studentDetails is the table name exist in oracle server.

and it is listed by your query on the top.

so...

Hi champion, What is SSMS..where I have to copy the result of column1.?

Now I am trying to get latest update or last modified timestamp, which itsef is "LASTWRITTEN" from each table.

when I tried above query it give me list of tables..which are...

Hi finally I manage to get it done with following query.

select * from [13.137.16.51]..SYS.ALL_TAB_COLS

where owner = 'PBR'

and column_name = 'LASTWRITTEN'

I am just wondering about the the tables as they are located as following structre in SQL SERVER MANAGMENT STUDIO

SERVER OBJECT => LINKED SERVER => [ORACLE LS] => [CATALOG] =>...

when i tried this one , it gives me different error,

SELECT

TABLE_NAME,

COLUMN_NAME

FROM

[13.137.16.51]...USER_TAB_COLUMNS

WHERE

COLUMN_NAME LIKE 'L%';

the error is

Msg 7314, Level 16, State 1, Line 1

The OLE DB provider "OraOLEDB.Oracle" for linked server...

WHEN I tried folowing query..

select OBJECT_NAME(object_id),* from [13.137.16.51].master.sys.columns where name like 'LAST%'

Msg 7312, Level 16, State 1, Line 1

Invalid use of schema or catalog for OLE DB provider "OraOLEDB.Oracle" for...

Try this one..

You will get your solution for sure

http://www.sqlservercentral.com/articles/EDW/77100/

Thanks.

Let me know your results..

[font="Comic Sans MS"]THANK YOU SO SO SO...SO MUCH SSCCRAZYeight, LOWEL, SSC CHAMPION, SSC Journeyman, SSC Veteran AND ALL OTHER MEMEBRS OF THIS FORUM.[/font]

One this I learned most here is

"There...

when I applied the solution which is provided here, which looks like as follows.

SET @merge_sql = (' MERGE into ' + @TgtDB + '.' + @TgtSchema + '.' + @TgtTable...