Hello,

I've found the possible solution. I saw that the permission to see all the session "view server state" is applying to a login, not to an user, and the...

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 -...

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 it...

Hello,

Verify the default language selected for your login in both server. It's look like a format issue regarding the language.

Regards,

Rafael Melo - BR

what is the relationship between the tableA and tableB? Is it just the server name?

_Rafael - Br

Gail, Thank you for your quick answer and your amazing articles. They help me a lot.

I know that tuning is about testing and testing. But as i'm new about processing...

Thank you guys for you time and patience....

I will do what you've proposed in my test environment. My doubts was solved!

obs: is there a way in this forum to close...

Hello Eric,

Since my business key do not duplicate, the identity column is not necessary, is it?

Eric, i use the system date at the time of my insert. The Customer,...

Opc,

Many thanks for your answer. But just clarify me one more thing. Lets assume this is my key (LoadDate, Customer, Product, DeliveryDate) and it is a clustered index and the...

Opc,

I have sure i have expressed myself in a wrong way. Actually i have a composite column in my index key based on my business requirement. But besides my business...

Sorry Gail,

You are right!. I didn't search enough before asking.

Rafael Melo - Br

Thank you guys!

You've clarified my doubt.

Rafael Melo - Br

Ok... Thanks for you quick response... (and sorry my English, because it isn't my first language!!!:-))

I'll change my question: What is the difference when I execute the command UPDATE STATISTCS...

Thanks for your replying and your help...

Regards,

Rafael Melo - Br

Nice paper... It's clear to me now.

Thanks a lot for your replying!

Regards,

Rafael Melo - Brazil.