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

Copy the table structure

Hi,
In SQL Server, Is there any DDL available to copy a table structure alone and not the data,
I believe 'SELECT * into new_table from table1' will copy both structure and data as well.
Please advice,
Thanks,
MiraJYou can use SELECT...INTO to create an identical table definition (different table name) with no data by having a FALSE condition in the WHERE clause.

SELECT * INTO new_table FROM table1 WHERE 1 = 0|||Understand though that Indexes and constraints do not get copied over...

copy table structure

Hi,
In SQL Server, Is there any DDL available to copy a table structure alone and not the data,
I believe 'SELECT * into new_table from table1' will copy both structure and data as well.
Please advice,
Thanks,
SmithaYou can do:

select top 0 * into new_Table from table1;

--or
select top 0 * into new_Table from table1 where 1=0;

-- or in SQL Server 2005
select top(0) * into new_Table from table1;