Yes i was / am using a DDL Trigger, till now i was getting the system name like Hostname where i will get the computer name or pc or laptop...

Thanks for the support and information. Here i am trying to log the changes done for Database Objects from which system and which login the changes have been made.

Earliear...

No,

my Pc or Laptop loginname is dakshina, where as i login to sql server using sa login and its password, the sql server may be either in my own pc...

Hi,

i even tried that, i will ge the login used to connect to sql server, but i am required of the loginname used to connect to my PC or...

Hi Bhuvanesh,

here i am loging to SQL Server after loging to my desktop or Laptop PC , now i would like to track the login name which i use to...

Thanks a lot for the reply, but when i execute the query i will get the systemname or computer name, in our case the computer name will be different and...

Thank You Very Much, i will try with this link.

Sorry,

for not replying to the thread, as i was not feeling well i was off from the office.

The reason why i need this is, one of my client need to...

The objective or the requirement is, we would like to know what all the transactions has happend which is stored in the .ldf file and its contents in .ldf file.

Thanks a lot for quick reply sir, So how to allote the memory for each SQL Server instance in either 32 bit or 64 bit systems, if i do so,...

Hi,

Thanks a lot, I will keep the Data Files of the different Instances in the Separate Drive, I would like to know by having multiple instances and using separate instance...

Hi,

Thanks a lot i tried and it has happend.

With Regards

Dakshina Murthy

Hi,

Thanks a lot for the input, i will definitely go through the links, if any i will get back to you, please help me out.

With Regards

Dakshina Murthy

Hi sir,

Thats right, need to check this several times before implementing into the production. So as you said expensive but safer to have separate servers for witness and distributor.

Once again...

Hi Sir,

Thanks for the support and help you are providing, i am having the distributor on my Server B, distributor is not in a separate server. i have configured the...