Browse by Tags

Using Management Studio unable to select "create one file per object"?

Published 17 October 7 4:6 AM | SSQA.net

One of the Developer complained that he is unable to create one file per object using Generating SQL Scripts within Management Studio. It is one of the good feature within SQL Server 2000 using Enterprise Manager where you can differentiate the objects...

Filed under: sql server, ssms, script, 2000, service pack2, 2005, management studio, enterprise manager, generate

Full Text Search is installed, but not enabled to see at table-level

Published 26 July 7 4:38 AM | SSQA.net

It was long time ago I have used FULL-TEXT within our environment, recently I have been given a task to manage a full text SQL instance. Well to refresh my tasks I have installed Full Text Search component on Windows 2003 Server for SQL server 2000 instance...

Filed under: sql server, ssms, database, sql express, full-text, enterprise manager

TSQL to get FieldName & FieldDescription within a SQL Server database

Published 25 July 7 9:52 AM | SSQA.net

When you are documenting a database including the table-column information you need to have a description that can specify that so and so column is used for such a purpose. Think about accessing such information using Enterprise Manager or SS Management...

Filed under: sql server, ssms, tsql, enhancement, field, enterprise manager