SQL and Me

SQL Server – Different Ways to Check Object Definition

• by VishalGajjar

• SQL and Me

sp_helptext is widely used for checking object definition in SQL Server. sp_helptext can be used to check definition of various...

2014-04-14

1,037 reads

SQL Server – Different Ways to Check Object Definition

• by VishalGajjar

• SQL and Me

sp_helptext is widely used for checking object definition in SQL Server. sp_helptext can be used to check definition of various...

2014-04-14

274 reads

SQL Server – Different Ways to Check Object Definition

• by VishalGajjar

• SQL and Me

sp_helptext is widely used for checking object definition in SQL Server. sp_helptext can be used to check definition of various...

2014-04-14

98 reads

SQL Server – Hide system objects in Object Explorer – SQL Server Management Studio

• by VishalGajjar

• SQL and Me

By default, SQL Server system objects are listed in Object Explorer in Management Studio. These system objects include system database,...

2014-04-15 (first published: 2014-04-07)

3,275 reads

SQL Server – Hide system objects in Object Explorer – SQL Server Management Studio

• by VishalGajjar

• SQL and Me

By default, SQL Server system objects are listed in Object Explorer in Management Studio. These system objects include system database,...

2014-04-07

471 reads

SQL Server – Hide system objects in Object Explorer – SQL Server Management Studio

• by VishalGajjar

• SQL and Me

By default, SQL Server system objects are listed in Object Explorer in Management Studio. These system objects include system database,...

2014-04-07

285 reads

SQL Server – How to get last access/update time for a table

• by VishalGajjar

• SQL and Me

Modify date and create date for a table can be retrieved from sys.tables catalog view. When any structural changes are made the...

2014-03-11

7,726 reads

SQL Server – How to get last access/update time for a table

• by VishalGajjar

• SQL and Me

Modify date and create date for a table can be retrieved from sys.tables catalog view. When any structural changes are made the...

2014-03-11

248 reads

SQL Server – How to get last access/update time for a table

• by VishalGajjar

• SQL and Me

Modify date and create date for a table can be retrieved from sys.tables catalog view. When any structural changes are made the...

2014-03-11

145 reads

SQL Server – Displaying line numbers in Query Editor – SSMS

• by VishalGajjar

• SQL and Me

You can enable line numbers to be displayed in SSMS Query Editor. This is extremely useful when working on a...

2014-01-20

915 reads