Definitely use GSquared's query, but I have a question, you can use 3rd party tools but not vendor supplied tools? I'm not sure that makes any sense..

You could always...

I would be ultra careful about killing and SPID with a value less than 50, they tend to be system processes. I think you need to be looking elsewhere...

I would expect it to. The trick is getting the instance to listen on that port. Is there any other instance on that server? If so you...

Bert (9/15/2009)

---

Given that you must supply a unique Virtual SQL Server name with an associated unique IP address during a CLUSTERED SQL Server installation, why couldn't you create a DNS...

ramadesai108 (9/15/2009)

---

Hi All,

How do I create a trigger based on time. For example, I have a date/time column in my table. I want to compare the current time with the...

I saw this one too, however, your highlighted portion is only relevant when using like in the '%sddfg' scenarion and is not relevant in the '%sddfg%' scenario, good article though.....

Silverfox (9/15/2009)

---

Hmm,

I could say straight away that SSIS, SSRS and SSAS are integral sql components and they are part of a DBA working suite. how would you consider DTS then...

Coming into this discussion late..

I think the points about all the ancillary tech around SQL like SSRS, SSAS, and SSIS are pretty good, but I think we lost focus on...

You might start with:

http://code.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=Best%20practices%20%2c%20Design%20and%20Developement%20guidelines%20for%20Microsoft%20SQL%20Server

I would also suggest developing a naming standard for all objects so that you can clearly tell what they are and what they do.

CEWII

sbowell (9/15/2009)

---

Stupid Questions are ALWAYS a good idea.

No, I was try to use an after trigger. However due to the complexity, age and size of our system, it won't be...

singhster (9/15/2009)

---

Elliott W (9/14/2009)

---

All of these things will work, but are you doing any source control? Don't you already have a copy of the way it was, and if...

Mark (9/15/2009)

---

Let me be clearer.

The first table is just the employee table. the second table is the relationship between the people in the first table. What I would...

Can you ping the servername that you are trying to connect to FROM the server with the DTS job on it? It sounds like you need to do the...

Most of that can be handled with server level DDL triggers and LOGON triggers. Some of the trace file stuff may not be necessary depending on your method of...

Then they won't be able to connect.. But that is a client problem and not something that will be resolved at the server. It is also not a...