This is useful for me since it gives me a way of finding invalid objects without recompiling.  I was using a script that recompiled the objects to find the broken...

I posed this question to the resident Microsoft DSE years ago where I work.  The solution I was given was to run the SP in a Powershell step in the...

Great article!  xp_logininfo is invaluable but you have to know it's limitations:
- returns empty row when AD account exists but it does not have login authentication in the SQL...

Thanks for your suggestion Steve.  I need to modify an existing SP that executes queries in a "test framework" tool.  I'm unable to make major design changes to break it out...

Looks like it's a problem with dm_exec_sessions but not dm_exec_requests or dm_exec_connections or sysprocesses so I can get the data I want from those instead.  I know sysprocesses is to-be-deprecated...

First time using your script. Looks like db role members are scripted out but the role itself is not so the sp_addrolemember statements fail? I only had one...

I have been using this technique for many years. It's much easier to maintain than dynamic SQL. I have also used it for dynamic GROUP BY and ORDER...

If you are willing to relocate to the Washington DC area and you are a US citizen check out job vacancies at the U.S. Census Bureau (on opm usajobs site)....

Does the "WITH (NOLOCK)" query hint not work as well for this (except for the dirty reads)?

I used to be an Oracle DBA but am a SQL Server DBA now. Companies who are converting from Oracle to SQL may hire experienced Oracle DBAs and offer...

I wrote a DTS pkg a few years ago to search DTS pkgs for an obsolete server name (when we migrated the pkgs from SQL 2000 to new SQL 2000...

I agree. I don't think SSMS 2005/2008 are deinstalled; they seem to just be missing from the start menu.

I just created a shortcut to the SSMS 2008 (c:\Program Files\Microsoft...

This is why it is a good idea to make the schema/owner for SPs/UDFs to be something other than dbo. 

We use a customized role called "dco" (database code owner)...

Amazing how some of these threads live on!

I originally wrote my FormatDate udf as we migrated from Oracle (which had the "to_char" function for this).  It's not the fastest UDF,...

Check out Microsoft's SSMA (SQL Server Migration Assistant):

http://www.microsoft.com/sql/migration/facilitatingdatabasemigration.mspx

I have not used it.  Looks cool if it works.  Should have a free download.

Jeff