We already have enough mixed nuts.

especially coming from someone like yourself

That the heck is that supposed to mean?

Once again - just kidding.

No, sorry. You...

Lynn Pettis (1/21/2009)

---

Grant Fritchey (1/21/2009)

---

This is the second time this exact question has been posted:

http://www.sqlservercentral.com/Forums/Topic640498-1291-1.aspx

No answers to the questions, no further interaction at all. I wouldn't be surprised to see...

Depending on the names you have, you may not be able to do much. Some surnames can have spaces in them.

There is a package property in the security section called "ProtectionLevel". By default, the value is "EncryptSensitiveWithUserKey". This will encrypt the "sensitive" information in the xml. Sensitive...

That sums up my opinion.

At the very least, I think it is pretty clear that there are many dumb...

Here is a simple illustration. Run the following:

[font="Courier New"]SELECT 1,'My Test 1'

UNION SELECT 1,'My Test 1'

UNION SELECT 2,'My Test 2'

SELECT 1,'My Test 1'

UNION ALL SELECT 1,'My Test 1'

UNION ALL...

The ANSI standard for variable length character fields indicates that trailing spaces pretty much don't exist. This is also why they do not matter when you join from one...

I would really question needing permissions in model and tempDB. As Gail pointed out, you would only need permissions in TempDB if you were creating permanent tables there -...

These types of circular references are typically a bad design. I understand why you want to do this in your design, but you may want to re-think the design...

Sorry - busy posting...

I think you are seriously underestimating the number of people that are not thinking.

We had an interesting issue recently. One of our VM farms was performing very poorly for me. It turned out that they had purchased about 2/3 of the...

In SQL 2008 there is a resource governor to allow you to handle hardware resource allocation at a more grandular level. This is not available in SQL 2005.

In SQL...