List stored procedure view depenedencies
Has anyone out there got a script I can run against a database to list all the views called BY a stored procedure. I need a list likesp1 - view85sp1 - view96sp2 - view786 ....etc
2005-05-20
1 reads
data warehouse
RE: Alert is not triggered
Is there a reason that you are using a severity level of 1. Severity levels less than 11 are for informational purposes and this may be causing some of the things that you are seeing. The 16 in your Raiserror is where the <state> goes. This <state> does not seem to do much. I hope this helpsEric
2005-05-18
RE: Single user mod
Nope, if you want to restore your DB then you'll need to kill off the connections to it first, either nicely or otherwise (depends on the DB and who's using it).
2005-04-25
RE: Serach for free drive Space on all my SQL Servers
Sure thing!This is an introduction to some of the most interesting undocumented xp'shttp://www.sql-server-performance.com/ac_extended_stored_procedures.aspBut keep in mind, that mostly they are undocumented for good reasons. So, evaluate carefully if you want to rely on such features in production code.
2005-03-23
RE: Query
How about something like this:___________________________________________________________declare @@counter integer declare @@appendsql varchar(1000) declare @@sql varchar(1000)set @@counter = 1 set @@sql = 'select 'WHILE @@counter < (select COUNT(distinct ID) from temp) BEGIN set @@appendsql = 'SUM(CASE ID WHEN ' + CAST(@@counter as varchar(1000)) + ' THEN value ELSE 0 END) as ID' + CAST(@@counter as varchar(1000)) + ',' set […]
2005-02-04
2005-01-19
2004-10-18
2004-09-17
RE: SQLMail Problem (maybe)...
Doesn't look like my last post went through...Derrick, you might have something there. I'll be checking with our Exchange Admin on that. Although, our Dev servers use the same config as our prod machines (albeit with a different domain account), and they seem OK. Thanks!!!!!! Josh
2004-07-06
RE: Constraint Questions
- use decimal[(p[, s])] check BOL in stead of float.- check constaints can help to delimit values : from BOL : ALTER TABLE doc_exd ADD CONSTRAINT exd_check CHECK (column_a between -99 and +99) alter table dox_exd ADD CONSTRAINT exd_check_precision CHECK (case column_a - cast(column_a as integer) when 0 then 1 when 0.5 […]
2004-04-20
Blogs
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Query Store Keeps Switching Itself Off, Getting it Moving Again
I recently received a complaint that Query Store for a particular database was turned...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers