Copying encrypted objects ?

Hi,

I would like to copy a function from one sql 2005 database to another, but the function is encrypted so cannot use the script to window commands etc... Is there a way of copying encrypted objects from one sql 2005 db to another? I don't really care to know the contents of the function.

Any help appreciated.

James.

I would recommend that you create a DTS Package to transfer the object. There was a 'Copy SQL Server Object Task' that was made exactly for this purpose.|||I tried this out in DTC and although the procedure seems to run successfully, the function still does not appear in the destination database. I take it from this that you cannot copy encrypted functions using DTC unless there is a certain way of doing it?|||Yes if it is encrypted then the DTS would fail, only way is to decrypt and then recreate on the destination server.|||

I thought this would be the case.

thank you for your help :)

Copying encrypted objects ?

Hi,

I would like to copy a function from one sql 2005 database to another, but the function is encrypted so cannot use the script to window commands etc... Is there a way of copying encrypted objects from one sql 2005 db to another? I don't really care to know the contents of the function.

Any help appreciated.

James.

I would recommend that you create a DTS Package to transfer the object. There was a 'Copy SQL Server Object Task' that was made exactly for this purpose.|||I tried this out in DTC and although the procedure seems to run successfully, the function still does not appear in the destination database. I take it from this that you cannot copy encrypted functions using DTC unless there is a certain way of doing it?|||Yes if it is encrypted then the DTS would fail, only way is to decrypt and then recreate on the destination server.|||

I thought this would be the case.

thank you for your help :)

Copy, Quick Find and Quick Replace not always available in SQL pane

Why is it that the copy, quick find and quick replace commands are available at some times and not others. This is something I have experienced while working in the SQL pane of a rather long union query contained in a View. The availability of these commands seems to come and go, so I would like to know what conditions are causing this so that I can make better use of these necessary editing tools.

This is a bit frustrating to say the least!

TIA,

Steve

Can you explain on what time and when it is behaving like that, I guess it could be during any process generation.|||I'm having the same problem. Seems that with the 5/22/07 Windows update, I'v completely lost access to Quick Find and Quick Replace.|||

What is the service pack level on the SQL SErver & client tools?

Check what updates were involved in that WSUS check.

|||

When is it not available - what steps are you using? What happens if you use the keyboard shortcut Ctrl+F or Ctrl+H - does the find and replace window display?

-Sue

Copy, Quick Find and Quick Replace not always available in SQL pane

Why is it that the copy, quick find and quick replace commands are available at some times and not others. This is something I have experienced while working in the SQL pane of a rather long union query contained in a View. The availability of these commands seems to come and go, so I would like to know what conditions are causing this so that I can make better use of these necessary editing tools.

This is a bit frustrating to say the least!

TIA,

Steve

Can you explain on what time and when it is behaving like that, I guess it could be during any process generation.|||I'm having the same problem. Seems that with the 5/22/07 Windows update, I'v completely lost access to Quick Find and Quick Replace.|||

What is the service pack level on the SQL SErver & client tools?

Check what updates were involved in that WSUS check.

|||

When is it not available - what steps are you using? What happens if you use the keyboard shortcut Ctrl+F or Ctrl+H - does the find and replace window display?

-Sue

Copy, Quick Find and Quick Replace not always available in SQL pane

Why is it that the copy, quick find and quick replace commands are available at some times and not others. This is something I have experienced while working in the SQL pane of a rather long union query contained in a View. The availability of these commands seems to come and go, so I would like to know what conditions are causing this so that I can make better use of these necessary editing tools.

This is a bit frustrating to say the least!

TIA,

Steve

Can you explain on what time and when it is behaving like that, I guess it could be during any process generation.|||I'm having the same problem. Seems that with the 5/22/07 Windows update, I'v completely lost access to Quick Find and Quick Replace.|||

What is the service pack level on the SQL SErver & client tools?

Check what updates were involved in that WSUS check.

|||

When is it not available - what steps are you using? What happens if you use the keyboard shortcut Ctrl+F or Ctrl+H - does the find and replace window display?

-Sue