Re: Why I can't change collation w/ Query Analyzer, but can do that w/

Hello Dejan,

When making table changes you can generate a script in EM and SSMS


Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons


Rather than using Profiler, I think you can get EM to only generate
script for you, but I may be wrong on that point. (I know you can in
SQL Server Management Studio, and what is in Mgmt Studio is very
similar to EM - including all the bugs!)

IIRC in EM you can generate scripts only for existing objects, not for
actions you want to perform, like you can in SSMS. However, I am not
100% sure anymore either:-)



.

Relevant Pages

  • Re: Can I create a Scipt with only create index command?
    ... How to create a script with indexes and Primary Keys only using SQL Server ... The resulting output is a script of only create index commands and/or Alter ... A very useful feature that is no longer available in SSMS 2005 or SSMS 2008. ...
    (microsoft.public.sqlserver.tools)
  • Re: SQL Agent Job
    ... You want to add the job through stored procedure calls or using the GUI (SQL Server Management Studio, ... If you want to use SSMS, just use the Agent Node, Jobs, add a job, add a job step, make it CmdExec type and type the path and name of your exe file. ...
    (microsoft.public.sqlserver.programming)
  • Re: How to drop & re-create subscription
    ... might as well get enterprise manager (SSMS) to script out the subscription ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • Re: How to script all Publications using SMO in 2005
    ... Right click on replication node in the SQL Server Management Studio and ... [This posting is provided "as is" with no warranties and confers no ... I have used your script from you site www.replicationanswers.com to ...
    (microsoft.public.sqlserver.replication)
  • Re: No Security
    ... remote instances in SSMS? ... What is SSMS? ... SQL Server Management Studio, you know, that program you admin SQL Server ...
    (microsoft.public.sqlserver.security)
Quantcast