just checking the obvious here:

what drive is this on? the string starts with a colon which is obviously invalid but might be an artifact of code obfuscation? or an actual...

well i'm betting that all the column names are aliases, right? the base tables don't have columns that have that pattern. in that case you can't alter the view without...

ZZartin (3/19/2015)

---

I'm sure you could write some kind of CLR function that would go ping your URL's, that'll tell you whether they're valid or not 😀

Trying to rely on regular...

well, all the information's in the metadata;

here's something i use myself, where i check if there are any extended property descriptions as well.

does this get you started?

select

--objz.object_id,

objz.name As TableName,

ISNULL(tabz.value,'')...

still using sys.sql_expression_dependencies, this seems to work for me, but gives some falsepositives due to CTE names appearing in the dependancies as well.

i deleted some staging tables that i know...

The Tally Table is a reference to a single column table from 1 to {some large number}

the example shown only needs 8000 chars;

this was the origianl definition from years ago:

SELECT...

well i doinked aroudn getting the data, but row number snot going to find consecutive montsh... here;s the data as a consumable post at least.

;WITH MyCTE([PERSON ID],[MONTH ORDERED],[Note])

AS

(

SELECT 'JD12345','4','' UNION...

here's a full example:

select

...

you can find every column namedDateStamp, and it's tablename (but it might be VIEWNAME !!) you can join to sys.tables and then sys.columns as instead

select

'delete from '...

my shop is the opposite;

i never receive scripts that contain settings from developers. s

o i'd say since my default conection settings from SSMS will have those settings set at...

GilaMonster (3/18/2015)

---

In this case it's unlikely to be faster as the column in the count is already in the...

there a nice softball of a suggested missing index right there.....i bet you could hit that one out of the park.

also, why not count(*)? it would be faster, i would...

watching this post for a better way; i couldn't figure out a way to cleanly edit a report programmaticly to change the datasourc.e

when i cleaned up this same issue(2005 to...

so true! i wonder...

SQL doesn't have a concept of previous row, so you have to have a structure that supports being able to identify a row and some sort of row order explicitly.

here's...