Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mathiyazhagan.sekar@gmail
Starting Member
11 Posts |
 Posted - 2008-05-19 : 05:32:07
|
| Hi, What is the use of sys.syscomments ?Cheers,MathiIndia. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-05-19 : 05:34:40
|
What does Books Online tell you?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
mathiyazhagan.sekar@gmail
Starting Member
11 Posts |
Posted - 2008-05-19 : 05:46:44
|
| Hi, MSDN says "sys.syscomments Contains entries for each view, rule, default, trigger, CHECK constraint, DEFAULT constraint, and stored procedure within the database. The text column contains the original SQL definition statements. These statements are limited to a maximum size of 4 megabytes (MB)."But,when to use it?Cheers,MathiIndia. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-05-19 : 05:49:00
|
SQL Server uses it, not you.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2008-05-19 : 06:30:47
|
| And on SQL 2005, it's a deprecated view and should not be used at all.If you want to do a programatic search through stored procedure/view/function definitions (which it the main usage I've seen) use sys.sql_modules instead.--Gail Shaw |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-19 : 07:17:34
|
| and BOL clearly states it too:-This SQL Server 2000 system table is included as a view for backward compatibility. We recommend that you use the current SQL Server system views instead. |
|
|
|
|
|
|
|
|
use of sys.syscomments