Sean Lange (4/9/2015)

---

Thanks!!! Not sure why I pointed out a possible concern and stopped short of providing an alternative. Been a heck of a week around the office...thankfully the weekend...

Good point, then we use the sys.all_sql_modules

😎

SELECT

...

tcronin 95651 (4/9/2015)

---

I have baselines, just stunned to see this happen, I have been a dba for 20 years and 99% of the time this happens either blocking or someone...

Seen almost the same before, the difference being the text qualifiers and the missing parameter delimiter. Guess you will have to query the...

tcronin 95651 (4/9/2015)

---

no blocking that was the first thing I looked for. I had dropped an unused index the night before on a table that the stored proc that...

He he, not the thing I would think of in the context of...

Grant Fritchey (4/9/2015)

---

tcronin 95651 (4/9/2015)

---

May have found the needle, started going through the snapshots Idera DM saves, as I scrolled through I noticed there is one stored procedure with about...

MAA (Mother of All Acronyms)

maurer.martina (4/9/2015)

---

hello,

I am looking for a script, that returns all SPs, which related to a given table, incl. the access type.

For example: the SPs SP_test1, SP_test2, SP_test3 are dependencies of...

rxm119528 (4/9/2015)

---

Hi all,

I am trying to understand the syntax change for Raiserror from 2008 to 2012

SET ANSI_NULLS OFF

GO

SET QUOTED_IDENTIFIER OFF

GO

CREATE procedure [dbo].[Spr_RaiseError]

as

declare @Rcount...

TBA

Quick suggestion (if I got this right)

😎

select

*

from

#vehicle v

inner join #class c on v.classtype = c.classtype

where

v.vehiclemake = 'AUDI'

and ( v.vehiclemodel = 'R8' OR v.vehiclemodel IS NULL);

Results

id ...

There should be no problem installing...

Sree Divya (4/8/2015)

---

Hi,

can anyone suggest how to take backup

my scenario is sunday 8pm full backup,daily 8 pm diff backup,for every 1 hr transaction log backup.

one developer wants the data upto...

Eirikur Eiriksson (4/6/2015)

---

Luis Cazares (4/6/2015)

---

I'm not sure if this can be done. I'm not sure if it's the lack of coffee in my body or something else, but I'd like...