Hi ,

I cannot post the output of this data. It is confidential. If you can share me the logic i will try and see if it is working.

I need some...

I have to rewrite the code in another language. This correlated subquery is not working in the another language. So i am trying to rewrite the code without correlated sub...

Hi Steve,

I don't know Powershell.

Thank You

Hi,

Example: Audit_DBA_991AEE46-71F7-470D-B63C-2EC208FD3303_0_130126053692760000.sqlaudit

Auditing file looks like this. when i go to folder i could see date and time the file was modified.

My auditing files doesn't contain the datetime. i have to...

Hi ,

I had found out the Issue. The security on the dotnet framework got messed up after the installation of the third party drivers on the server. To fix this...

Sean,

Thank You very much. Now I understand. Your answer is very clear.

Hi ,

After the data named 2314K was removed from the table the Job was working fine.

I changed the code from

update Table_Test1 set Test_Code=1001 where Test_Code=1000

update Table_Test1 set Test_Code='1001'...

Hi ,

After the data named 2314K was removed from the table the Job was working fine.

I changed the code from

update Table_Test1 set Test_Code=1001 where Test_Code=1000

update Table_Test1 set Test_Code='1001'...

I will change the code like what you had said but when it was having issues with the Test_Code Column in the Table_Test1 . It should throw an error message...

Hi ,

Even without making changes like the one you have mentioned above the Job is running successfully.

If i assume Test_Code column is a culprit in the table Table_Test1 how is...

I did not design those datatypes. There are already present and I was working on those. I will change the code and give a try.

I will update you about the...

There are other steps in the Job. The job is failing when it is running the stored procedure which i had mentioned.

I don't see any issues with other steps in...

Hi ,

I am using SQL Server 2005 Enterprise edition SP4 (64 BIT) ON Windows Server 2008 R2 Standard edition 64 bit SP1 .

Below mentioned is the structure of the...

Hi Celko,

I got the business requirement like this. Based on the business requirement I had created the code.

I will follow your recommendations. Thank You very much.

Thank You,

Hi Phil,

Business developers had asked me to create a trigger like that.

I hate to write triggers like that. I will check with the developers.

Thank You,