I want an advice

When I compare two tables or two sp's should I create a local database and put the result there?

The number of comparison is quite big and I...

I start doing this...and is working,but there is stuff I still need to do

I have another question:D

Is there an equivalent to '\ n'

When I build the create string I want...

and if i have an index on 2 columns....

I can't find this anywhere...

I will come with other examples ...later,because now I need a break

I believe you and I will start...

I know this ones:D

The idea is that I don't think I can build an identical create statement for a table,or for an index, but the programers that build ApexSqlDiff did....

I know that, but I want to do this dynamic

I have a table...and I want to create it exactly the same...using t sql

to make a script for creating...

...or how can I build the create index statement from views ....?is there a field view that contains this statement?

can anybody tell me?

thank you

You say that is possible from SSMS . Then I have a question.Is there a way to find the create statement of a table, the way you find for a...

Thank you...but I'm interested the SQL "part" of the tool...I will think about the rest later.

For instance I want to know where can I find all the info...

though, is there a ROWID function in Sql Server?

Some say that this is very usefull (in oracle or others..)

Thank you

That's exactly what I was looking for

Thank you

Is working.I've tryied CTE with split for the date and it wasn't working properly...

Nice solution:)

I've said before that Config Manager is working.But C Manager was in SQL Server 2005 not in SQL Server where was E Manager, so it was irrelevant.

So for Full text...

I think I'm a little stupid....:D

In Start I have SQL Server 2005 and SQL Server ....

Enterprise Manager is in SQL Server and Config Manager is in SQL...

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Service Pack 2 Developer Edition

So

I'm reading an article about full text indexing , and the advice of the autor and the examples are made using SQL Server Enterprise Manager.

So I tryied to...