Blogs about: Object Search
Featured Blog
How to Query Active Directory (AD) from SQL Server
There can be a scenario where you will want to query Active Directory, directly from your stored procedure. This can be achieved by creating a linked server to your target Active Directory and then qu… more →
SQL Tips by Namwar Rizvi
Find an object using system tables
SQLWebLogger wrote 3 weeks ago: Oracle sql server system tables all_objects OR user_catalog, all_catalog, dba_catalog sys.obj … more →
Object dependencies
SQLWebLogger wrote 3 weeks ago: Oracle SQL Server system tables USER_DEPENDENCIES or ALL_DEPENDENCIES or DBA_DEPENDENCIES sys … more →
How to Query Active Directory (AD) from SQL Server
namwar wrote 3 months ago: There can be a scenario where you will want to query Active Directory, directly from your stored pro … more →
Search all columns of all tables for a particular value
namwar wrote 10 months ago: Several times I have came across with the question that how can I search all columns of all tables i … more →
How to find relationship between tables
namwar wrote 11 months ago: As a DBA or even as a SQL Server Programmer, you may need a quick script to find relationship betwee … more →
Retrieve current user permissions in SQL Server 2005
namwar wrote 2 years ago: If you want to retrieve the permissions available for the currently logged in user then you can use … more →
Retreive current user permissions in SQL Server 2005
— 1 comment
namwar wrote 2 years ago: If you want to retrieve the permissions available for the currently logged in user then you can use … more →
Retrieving DDL of SQL Server objects
— 2 comments
namwar wrote 2 years ago: Following is just a quickest and simplest way to retrieve DDL or the SQL required to create a databa … more →
Search columns in SQL Server 2005 database
namwar wrote 2 years ago: Since SQL Server 2005 Management Studio lacks the Object Search feature, here is the simple query to … more →
