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,035 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

272 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

96 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,271 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

469 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

283 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,724 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

246 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

143 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

913 reads