Thanks. I was pretty sure that I had never seen this in SQL Server.

The QOD should be vetted and tested before posting for all to answer. None of the answers are correct because the select statement returns 4 columns, not 3. ...

The results of @@rowcount will be one and is out of scope (executed in a different context) so the value of @@rowcount in you print statement is null. You...

But that small typo makes the correct answer incorrect.

SQLAgentAgentRole does not exist.

I support SQL 2000 Standard, 2005 Standard and Enterprise, 2008 Standard and Enterprise and 2008R2 Standard.

Since PASS is in Seattle and 2012 marks the 50 year anniversary of the Seattle World's Fair and the Space Needle was built for the Worlds Fair and the Space...

I work for a relatively small company that invests heavily in technology. Our critical systems have full hardware redundancy with real time replication to our DR site. We...

None of the answers are correct. You receive a result set with 50 GUIDS. Very poor question. No QA before posting.

I started thinking out of the box and realized that I could populate a drop down list based on a parameter selection (we do that all of the time). ...

That's what I figured would be the outcome, but I was just making sure that I understood what the filtered subscription would or would not do.

Thanks.

No, a filtered index does not purge (delete) the data. I want to remove the data from the data mart after 6 months.

Thanks for the input. I cannot partition the data on the data mart because we are not running Enterprise Edition on the data mart, just on the data warehouse....

This will give you the column name, table name, datatype and the maximum length:

select c.name as columnname, o.name as tablename, d.name as datatype, c.max_length

from sys.columns c inner join sys.objects o...

I found a very long post that had specifics on how to correct this problem. It is a bug, but there is a workaround. Basically there are two...