I've never understood hoarding information so your job is secure. I spent 9 years supporting a manufacturing facility through 2 owners and had call that varied from every 3rd...

Yeah, what is upperbognor doing on this thread?

Performing self-joins should not be any slower than joining on other tables as long as you have appropriate indexes. Also check out this article about PIVOT: http://www.sqlservercentral.com/articles/T-SQL/63681/

Select Count(*) From sys.tables

You can modify the trace using the sp_trace_* procedures. You would need to get the trace id from sys.traces, stop the trace using sp_trace_setstatus, and then add and enable...

Here's how I do it. If I know the column is a fixed size I used char otherwise I use varchar. I've heard the argument that smaller columns...

You can run this code within the specific database:

Select

P.name as username,

RP.name as role_name

from

sys.database_role_members R Join

sys.database_principals RP On

R.role_principal_id = RP.principal_id Join

sys.database_principals P On

R.member_principal_id = P.principal_id

Where

RP.name = 'db_owner'

Assuming the text files are all in the same location you can use a ForEach container and you would use the foreach file enumerator. You would place the file...

I don't know of an easier way to do this. You would need to create a policy and the policy would need to have some teeth.

While Vladan is probably correct in noting that there is probably a simpler, better way to do this I will attempt to answer your question. I think you need...

When you go to the security tab of the linked server in SSMS what is there? You either need to provide a mapping in the top area or select...

Sure you can concatenate first name and last name in a stored procedure just like you have done it in this post.

rbarryyoung (9/30/2008)

---

To the best of my knowledge an "c0000005 EXCEPTION_ACCESS_VIOLATION" is only caused by (1)a SQL Server bug, a binary corruption in the SQLServer executables or a corruption of one...

GSquared (9/30/2008)

---

Personally, I'd rather have a manager who was skilled at management and poor at technology than the other way around.

My current manager likes to joke about his "prequel" skills....

Lynn Pettis (9/30/2008)

---

Jack Corbett (9/30/2008)

---

Sorry, my question was meant to be funny. I do know what...