Can I generate a SQL CREATE script for a table that exists in the db automatical

I'm trying to figure out what the easiest/best way to transfer just one table from one sql server to another. Any help would be appreciated. Thanks!you can use the query analyzer, select database --> user tables --> select correct table --> right click --> script object to new window as -->> create. The query analyzer will generate a script that will generate your table.|||Thanks for the quick reply!
However, I can't seem to find the "user tables-->select correct table" option in the query analyzer?
Thanks again!|||At the left side is the object browser. If you cannot see, push the F8 button. You see at the top your server and below the databases in that server. From that point on it's like the Windows Explorer. When you see the user tables you can select one and right click on it for the scripting.|||Is this a SQL 2000 thing? I'm on SQL 7.0|||don't know, never used sql 7. Something else you can try: in the enterprise manager, select the table you want to script. Right click on it, select all tasks and then generate script. A popup will appear and if you want you can set some preferences, but just pushing OK is sufficient. Hopefully this is in sql 7|||You can access this through enterprise manager by right-clicking on the table and selecting All Tasks, Generate SQL Script.

Note that this does not copy the actual data. To do that you will need to use DTS.

blindman

can i do RDA transfer using integrated security?

or do i need to setup SQL security users and logins.?

The following articles will help you to understand the various ways for configuring security for replication

http://msdn2.microsoft.com/en-us/library/bb226707.aspx

http://msdn2.microsoft.com/en-us/library/ms172917.aspx

Manish Agnihotri

Program Manager

SQL Compact

sql

Can a Report Model have Reports included in it?

Hi All

I have created reports in 'Projects'. What I would like to know is that if can transfer these reports into a report model?

As per my knowledge, a report model contains datasources, datasource views, report models itself and doesn't allow to transfer reports. Please , let me know if my understanding is correct?

Cheers

Preps.

Correct - you cannot add a report to a Report Model project. You should create a Report Server project if you want to develop and deploy reports.

|||

hi,

i am new in report model report. i have created one report model project, but i don't know how to make report from this report model project.............can u help me? to make report from report model project or suggest any article on it..........thx in advance

Can a Report Model have Reports included in it?

Hi All

I have created reports in 'Projects'. What I would like to know is that if can transfer these reports into a report model?

As per my knowledge, a report model contains datasources, datasource views, report models itself and doesn't allow to transfer reports. Please , let me know if my understanding is correct?

Cheers

Preps.

Correct - you cannot add a report to a Report Model project. You should create a Report Server project if you want to develop and deploy reports.

|||

hi,

i am new in report model report. i have created one report model project, but i don't know how to make report from this report model project.............can u help me? to make report from report model project or suggest any article on it..........thx in advance