Browse by Tags

All Tags » sql server » enterprise manager   (RSS)
Different ways to know structure of a table
28 February 08 01:51 AM | Madhivanan | 3 Comments   
You can use one of the following to know the structure of a table 1 Generate SQL Script option from Enterprise Manager/Management Studio 2 select * from information_schema.columns where table_name='table_name' 3 EXEC sp_help 'table_name' 4 EXEC sp_columns Read More...
Copy the SQL Server instances list from Enterprise Manager using vbscript
07 February 08 01:34 AM | SQL Master | 2 Comments   
As you may be aware you can take help of Registry settings in order to copy the SQL Server list that are managed from the Central Managed server. I have seen this VBScript posted by Mohammed U posted the following script, you can save it as .VBS that Read More...
TSQL to get FieldName & FieldDescription within a SQL Server database
25 July 07 07:52 AM | SQL Master | 2 Comments   
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 Read More...