I wouldn't use foreachDB:

SET NOCOUNT ON;

IF OBJECT_ID(N'tempdb..#TempDBs') IS NOT NULL DROP TABLE #TempDBs;

CREATE TABLE #TempDBs(DatabaseName NVARCHAR(250), ExtendedProp NVARCHAR(MAX));

DECLARE @sql VARCHAR(MAX);

SET @sql = '';

SELECT @sql...

As far as I am aware, it is impossible to create new system functions in SQL Server (unlike system procs).

Closest think you might want to do is to create function...

Do you Active Directory groups and user? If so...

If you need just two columns: RowId and ConcatenatedAddress - use advised FOR XML with STUFF thingy.

If...

Select and RaisError only display the string up to the Char(0), but Print displays the entire string, even though both strings show the same Len() and DataLength()....

No need in windowed functions, you can achieve the same by simple ORDER BY of UNION ALL:

SELECT ItemName

FROM (SELECT *

FROM ...

GilaMonster (8/23/2013)

---

In a future version of SQL Server, ANSI_NULLS will always be ON and any applications...

GilaMonster (8/23/2013)

---

The only comparison with NULL that can return TRUE is the IS NULL/IS NOT NULL comparison.

'x' = NULL returns UNKNOWN, not TRUE or FALSE

'x'<> NULL returns UNKNOWN, not TRUE...

Does your proc have input parameters which then used directly in WHERE clauses or JOINS?

If so, try to declare local variables at the top of proc, assign them to input...

There is another, more cryptic way, if you wish:

select * from @t where case when name = 'Check' then 1 else 0 end = 0

:hehe:

You need to specify TYPE COLUMN which holds file type extention.

Read BoL: http://technet.microsoft.com/en-us/library/ms187317.aspx

So you need a column to keep extention in.

BFSTEP (8/1/2013)

---

I am in a time crunch, many things on my plate today, and I just can't seem to get this problem, thought I would toss it out to the...

Eugene Elutin (8/1/2013)

---

GilaMonster (8/1/2013)

---

That's not a dirty read. The definition of dirty read is reading uncommitted data.

That...

GilaMonster (8/1/2013)

---

That's not a dirty read. The definition of dirty read is reading uncommitted data.

That nolock can...

To nest CTE just use comma:

;WITH cte1 AS (SELECT .... FROM [sometable])

,cte2 AS (SELECT .......