Well... I have now narrowed down that it is not a replication issue or anything tied directly to service broker or the subscription for the query notification. It seems...

In addition to what Brandie said, I would think that the quote in your first post says it all. It doesn't say that Windows Authentication is the ONLY required...

Yes it would. This should administered by...

What everyone is saying is true and good. However, I think your real question is asking whether or not you can have mixed mode set. The answer is...

GilaMonster (11/15/2012)

---

If a clustered index is created on a heap and one or more nonclustered index exists, all nonclustered indexes will be rebuilt as part of the process of creating...

Lowell (11/13/2012)

---

if you know it's a single table, it's going to look something like this:

you can use the pattern matching , regular expression style of the LIKE statement:

SELECT *

FROM...

Please post ddl for the table.

J-Rock (11/13/2012)

---

I have account numbers within text fields in a table that need to be replaced with X's for security purposes. The account numbers aren't always in the same...

Not on disk, but you can download sqlexpress with advanced tools and only instal ssms.

http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=3743

J-Rock (11/13/2012)

---

I need to run a query in a table to find and replace anywhere where there are sets of random 16 and 17 digit numbers. I need to...

I don't understand... If you...

bhaveshp.dba (11/2/2012)

---

I need to geterate table within fromdate and Todate.

and Use this table with left join to other table.

Select m.month,v.year, ID, Name from #Month m

lett join View_Data v on...

Don't use a UDF. Create a calendar...

Thanks, but this just tells me how to set it up for a specific thing and does not help me ti understand XEs.

Awesome! Thanks...