I created a view with an * once, and then when the table that the view referenced got its definition changed, the column names in the view did not correspond...

I think this is a pretty good topic, hopefully more folks with more experience can pitch in.

I've done some archiving. Pretty much across the board with stuff, I've taken snapshots...

I like just ommitting the end date. I wonder what cases there are for which this doesn't work well?

ScottPletcher (10/23/2014)

---

arnipetursson (10/23/2014)

---

ScottPletcher (10/22/2014)

---

You should be able to use the session_id to do the lookup. But since session_ids are reused, and sysjobactivity keeps history, if your proc is not...

Speaking of which, I wonder if the last bar in this chart is close to accurate?

http://www.informationisbeautiful.net/visualizations/million-lines-of-code/

They hedge their bets...

My theory is that intel is "little edian", which means that bytes stored in memory are stored with "increasing numeric significance with increasing memory addresses (or increasing time), known as...

g.britton (10/23/2014)

---

Interestingly, this does yield a jobid that I can use, even though it is not THE job id. e.g. using that query I get

72A6BEB9941ED146AD41CCEED345E01D

the actual job id (from...

Nice! I looked more into your convert statement and the second part that finally converts to nvarchar, style '2' ditches the 0x! I've never used the style beyond datetime so...

Awesome! Glad it worked!

Found a few more issues with the process...

-- first to create a test

create table testtree

(

id1 varchar(10),

orgnode hierarchyid,

orglevel as ([orgnode].[GetLevel]())

)

-- build some rows

insert into testtree select '001',hierarchyid::GetRoot()

insert into testtree select '002',(SELECT...

Well its more complicated than I thought, so much for me trying to help LOL

First off, we need the type "flag".

Can you post that type "flag?" Its in your SSMS...

Gotcha, maybe you can use master..sysprocesses from...

I always thought it was more like:

Those are the fundamental building blocks of relational databases. A primary key uniquely identifies a row within the database an individual table. A foreign...

Can you post the table definition, and the collation of your database? This would make for a closer duplication of your efforts.

Maybe you could use the job name. Just offering some suggestions!

You know the job name because its listed in agent jobs in ssms explorer, so you could start by nabbing...