Monthly Archives: October 2012
-
Looping through multiple servers in SSIS
15October 31, 2012 by Kenneth Fisher
This is just a quickie post to answer a question on how to loop through multiple servers in SSIS. There …
Continue reading -
How do I find all stored procedures or views that use a specific table?
3October 26, 2012 by Kenneth Fisher
Many years ago when I was still working on SQL 2000 I occasionally needed to find all stored procedures and views …
Continue reading -
I can connect to my instance locally but not remotely
4October 23, 2012 by Kenneth Fisher
Every now and again (today for example) I’ll get a call that one of our SQL Server instances is down. …
Continue reading -
fn_OBJECT_TYPE
4October 19, 2012 by Kenneth Fisher
I recently started using OBJECT_NAME, OBJECT_SCHEMA_NAME and OBJECT_ID functions; unfortunately I really could have used OBJECT_TYPE but it doesn’t exist …
Continue reading -
A review of SQL Interoperability / Joes 2 Pros Volume 5 by Rick A Morelan
1October 15, 2012 by Kenneth Fisher
I recently passed my MCTS 2008 Development (70-433). Yay me! That made my 3rd 2008 certification. This one was probably the …
Continue reading -
Multiple CTEs
10October 9, 2012 by Kenneth Fisher
Multiple CTEs It’s somewhat obscure in BOL and I wasn’t able to find any examples but it turns out you …
Continue reading -
Active flag on the TCP/IP Properties page of SQL Server Configuration Manager
1October 5, 2012 by Kenneth Fisher
I’ve been unable to connect to a server via one of its aliases for about a week. When I looked …
Continue reading -
When I get stumped I ….
2October 2, 2012 by Kenneth Fisher
I work with a reasonably large team of DBAs. There are 9 of us and we support not only 70+ …
Continue reading
SQL Studies 