Browse by Tags

SQL Server 2008 - TSQL behavioural changes and enhancements

Published 31 March 8 2:0 PM | SSQA.net

As usual the new release of SQL Server version 2008 had few changes from 2000 to 2005 and as usual this control-of-flow sequence should occur in order to take advantage of performance with transaction/rollback advantages. Such direction of flow should...

Filed under: sql server, performance, transaction, article, 2008, tsql, enhancement, begin

How to find all the owners of entities contained in a specified schema?

Published 4 October 7 3:0 AM | SSQA.net

How to find all the owners of entities contained in a specified schema? USE <database_name>; GO SELECT 'OBJECT' AS entity_type ,USER_NAME(OBJECTPROPERTY(object_id, 'OwnerId')) AS owner_name ,name FROM sys.objects WHERE SCHEMA_NAME...

Filed under: sql server, security, login, tsql, enhancement, schema, entity

TSQL to get FieldName & FieldDescription within a SQL Server database

Published 25 July 7 9:52 AM | SSQA.net

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...

Filed under: sql server, ssms, tsql, enhancement, field, enterprise manager

Enhancement to OBJECT_NAME metadata function and a new OBJECT_SCHEMA_NAME metadata function

Published 16 July 7 3:53 AM | SSQA.net

You may be aware OBJECT_NAME function can be use to return the database object name, I think since SQL 2000 when system functions are used the parameter of a system function is optional, the current database, host computer, server user, or database user...

Filed under: sql server, sp2, tsql, object_name, enhancement, schema