tshad (5/19/2014)

---

I also tried it by taking the t1.t_id off of the selection list and it still worked.

You said it knows about the column from the one table but not...

rightontarget (5/19/2014)

---

Hi all,

This character "ä" comes up in one of contacts last names.

It breaks one of our web apps. I'd like to deal with it in sql, if possible,...

You might want to look at the results. The calculation you provided will not correctly determine the amount of disc space used. This calculation is (FreeSpace / TotalSize) / 100.

Let's...

tshad (5/19/2014)

---

Great.

That answers my question.

But on your CTE sample, I like that as well but am not sure why it works.

I made a small modification to your sample to add...

dmandosql (5/19/2014)

---

Hello,

I know this is kind of a basic question, but I am stuck. I am trying to get the percentage of 2 numbers. I believe this is correct, but...

TC-416047 (5/19/2014)

---

Thank you for the explanation/clarification.

This is greatly appreciated.

I can't change the trigger without breaking our support contract.

So I'll have to disable the triggers and do an update.

Again I really...

rafael_si (5/19/2014)

---

I've done right as you showed. What happens is that the proc show just the "SomeUser" session. What i've is:

1 - create "SomeUser" login with "View Server State" permission

2...

navie22 (5/19/2014)

---

in results i like to see for recordcount_ resourcenumid = 20003

table name ...

Eric M Russell (5/19/2014)

---

Maxer (5/18/2014)

---

A company I work with stores all HR data for all past and present employees in a table that has SSN, DOB, address, and full name.

This...

TC-416047 (5/19/2014)

---

Yes.

There are two triggers causing this.

V_AU_CUSTOMER

V_AU_CUSTOMER1

I could disable triggers and the update works.

But I'm not sure of the impact yet.

The trigger names are the sames as the actual tables...

Do you have any triggers on that table? I suspect that is the same problem with all of your views.

Can you post ddl, sample data and the actual desired output based...

navie22 (5/19/2014)

---

i have to create a job. this query, gives me table names in database with column name with where condition. now, from here, i also need to get...

rafael_si (5/19/2014)

---

Sean,

I've done that! I've create a stored procedure with execute as <sysadmin> user. But it is showing just the information about that user, not all connection information. Why does...

Hi...