Geeks With Blogs

News Copyright © 2008-2013 Paula DiTallo
Ask Paula! ...bringing you notes from the field... October 2010 Entries
How do I know what version of IIS I am running?
I've encountered a LOT of posts on this--some of them represent a LOT of unnecessary work. Here's the simple way: 1. Navigate to Administrative Tools. 2. Go to Internet Information Services (IIS) 3. If you last looked at something, Navigate to ABOVE your server name -- where it says "Internet Information Services" 4. Look to the right. You should see something that looks like this: computer local version -------------------------- ------- ------------- YourComputerName yes IIS V6.0 You're DONE ......

Posted On Sunday, October 17, 2010 6:04 PM

How do I list every table and every column in the table in SQL Server?
The sys.tables and sys.columns objects will return this information for you. The following SQL statement will bring bring back all the colunns in all the tables ordered by the table name then the column name. SELECT tbl.name AS table_name, SCHEMA_NAME (schema_id) AS schema_name, col .name AS column_name FROM sys.tables AS tbl INNER JOIN sys.columns col ON tbl.OBJECT_ID = col.OBJECT_ID ORDER BY schema_name, table_name; ......

Posted On Sunday, October 10, 2010 10:32 PM

How do I find all instances of a column name in my SQL Server database?
The objects that help you find this info in SQL Server are in sys.tables and sys.columns SELECT tbl.name AS table_name, SCHEMA_NAME(schema_id) AS schema_name, col.name AS column_name FROM sys.tables AS tbl INNER JOIN sys.columns col ON tbl.OBJECT_ID = col.OBJECT_ID WHERE col.name LIKE '%YourColumnNameHere%' ORDER BY schema_name, table_name; This will bring back every table that has a reference to '%YourColumnNameHere%' ......

Posted On Sunday, October 10, 2010 10:27 PM

Copyright © Paula DiTallo | Powered by: GeeksWithBlogs.net | Join free