sp_help is the correct answer.

how to know description of a table in sqlserver 2000

Question Posted / punithalakshmi

Answer Posted / punithalakshmi

Is This Answer Correct ?

5 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is the default Port No on which SQL Server listens?

1124

How can you control the amount of free space in your index pages?

1057

What is optimistic concurrency?

1038

Distinguish between commit and rollback?

961

Can we return Data from 4(more than 1) tables in stored procedure?

1059

What is sql stored procedure?

1093

what do you understand by change data capture?

1020

Explain about builtinadministrator?

1053

What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

2072

What are approximate numeric data types in ms sql server?

1059

Why use update_statistics command in sql server?

1051

How do I know if localdb is running?

953

When would you use sql joins?

959

What are character string data types in ms sql server?

1251

What are the differences between left join and inner join in sql server?

1107