Thank you GilaMonster And Ed Wagner

And about "Ed Wagner" Question :

This transaction are send by our application and This day I triggered to review it. (but it is time consuming)

and...

I think there is a problem , when a transaction in between.

in detail :

when a connection created , you can get "Textcommand" of that spid. (very easy)

But...

yes, I searched this id on my db and found that sp which I told about it.

Blocking object was : a simple sp with readuncommitted

And

Blocked object was...

But what is the relation between this and my abstacle?

The DDL trigger Dont work with...

Thank you

But this link is refrenced to this page again !!!!

Grant VIEW SERVER STATE to [NewLogin]

Secondly :

Create a user based on this login in my db .

then

ALTER ROLE [db_owner] ADD MEMBER [NewLogin]

GO

finally :

Create TRIGGER [DDLTrigger_LogAll_DDLChanges_ToDataBase]

...

Depending on how you need to link the image to other data in your database you may need to engineer some relationship tables but compared to using FILESTREAM directly it...

Thank you Orlando

I found the problem .

I login to ssms with my windows user.

And It hasn't access to do service brokers tasks in default.

Then I login with sa and every...

Hi again

You Define a Disaster Site.

It means Primary site is in Datacenter_1 And Disaster site is in Datacenter_2

And if it would be true , Can I Create Cluster between...

:doze:

Thank you Jeff Moden

Both for my obstacle and for your sidebar.

😛

Thank you Jason

And what about 'Parameter sniffing', some one say me about that ? what is it ?

:doze:

A best Practice Or GuidLine ?

:crying:

:-D:-D

Thank you

I was busy with Pivot from several hours. :Whistling: