I'm pretty sure I saw one version that did not return the SPID that was executing SP_WHO3.

jbalbo (3/19/2015)

---

I will definitely be able to use this for something, but I did find a problem with the formatting,

I got en error because one record had parenthesis in...

I'm not sure that I understand why you're doing this, but you could make a copy of the project folder. Run one instance from the original folder and another...

I'd try something like:

DECLARE @TestString...

Why are you inserting the same values in each table twice? This might be causing the unexpected results?

There's several System views you can query to get that type of information, for example:

INFORMATION_SCHEMA.TABLES

INFORMATION_SCHEMA.COLUMNS

sys.tables

sys.columns

Jim, when you said the processes were doing incremental loads, did you mean that they were only loading new records and may have ignored old modified records?

Yes you can take one file and in one data flow, insert any column(s) you want to one or more tables.

You could also do this in multiple data flows if...

If you want "column level security" for data coming out of SSAS, then you have to apply the security in SSAS.

Someone is asking the question: "One of the database that I monitoring is showing the .mdf file full. Recovery model of that database is simple. How can I add more...

If I read your query correctly, you have IF statements to cover the 4 regions specified individually, but nothing else.

If the value used is not 1 of the 4 values...

below86 (3/12/2015)

---

One huge problem I see so far is...

Be very careful about putting the "when" and "not when" conditions in a where clause. This could cause unexpected results if both conditions exists in the same string.

+ 1

I create a process to rebuild or reorganize indexes that are too fragmented. The process...

lawsonoliver1 (3/6/2015)

---

I am selecting DATABASE zone.....but your system will not allow me to select it because I'm asking a question? Makes no sense. So I checked other...