quackhandle1975 (3/4/2014)

---

Hi,

Many thanks for all your replies and yes I do agree that running CHECKDB on a dummy database is not the same as running it in production and my...

Grant Fritchey (3/4/2014)

---

dbalmf (3/4/2014)

---

Hi,

I'm assuming your laptop is part of the same domain as the SQL Server. Create a shared folder on your laptop, You will need to give the...

Lowell (3/4/2014)

---

quackhandle1975 (3/4/2014)

---

Hi,

I am looking to perform some DBCC CHECKDB tests and for many reasons, I cannot copy a use a copy of current prod database, but the best I...

Bacteria

Gigahertz

+1. However, it was an interesting one. Thanks for the question.

Frequency

Why not just make the last step in your procedure to return what you want based on your input parameter? Example:

CREATE PROCEDURE SomeProc(@intOutput Integer)

AS

BEGIN

--do some stuff here

...

crookj (3/3/2014)

---

Ed Wagner (3/3/2014)

---

Revenant (3/3/2014)

---

crookj (3/3/2014)

---

SQLRNNR (3/3/2014)

---

Ed Wagner (3/3/2014)

---

BWFC (3/3/2014)

---

EricEyster (3/3/2014)

---

Ed Wagner (3/3/2014)

---

crookj (2/28/2014)

---

...

Steve Jones - SSC Editor (3/3/2014)

---

Ed Wagner (3/3/2014)

---

Steve Jones - SSC Editor (3/3/2014)

---

I...

jbalbo (3/3/2014)

---

Hi

I have two tables I need to get info from

Client

Services

I need to find clients with whose last service > 80 days old

so I know I need something like...

Revenant (3/3/2014)

---

crookj (3/3/2014)

---

SQLRNNR (3/3/2014)

---

Ed Wagner (3/3/2014)

---

BWFC (3/3/2014)

---

EricEyster (3/3/2014)

---

Ed Wagner (3/3/2014)

---

crookj (2/28/2014)

---

Ronnie and the...

Steve Jones - SSC Editor (3/3/2014)

---

I am. Might be slightly longer in real...

Demolition

HanShi (2/28/2014)

---

I see your point although you can also colorcode the query-windows in SSMS. Register the instances in registered servers and apply a different color for each instance under the...