Problem: Login dropped and created through the script with the default public access.

Solution: SQL server had nt authority\system with sys admin access. I was able to recreate the dropped...

You are amazing... Thank you so much.

Hi Everyone,

I have a query. I can combine 3 table results in HTML body. When I add my fourth table, I get an error. This error is not respect...

Hi Mark,

Thank you for the response.

I am getting a new error now...

Please let meknow if I can get help on this error:

"Failed to unload app domain DefaultDomain....

Thats awesome. Worked great for me....

Thanks again.

Thanks for ur response. Will try the code and update.

But let me know if there is any possibility to identify the packages those uses the same query in the...

My prod envt has almost close to 300 packages, designed long time back.

I now have a situation to chnage the SQL statement used in the EXECUTE SQL TASK (in many...

Hi

As u said, the column name "itrn" is same in both the tables. Please let us know the column name to be updated to "YES" on the existence of the...

Hi

Can the same be done using Federated Database server by which the database can be given to multiple servers....?

As per the MSDBN, there is no effect on the performance.

Please let...

Hi Sat,

Thanks for your quicker response...

The highly loaded tables are frequently accessed tables.

Also, the data greater than 90 days gets deleted. So, i believe there is no way of data...

Thanks for your quick response. I have attached the procedure.

Please help in solving this issue.

Hi,

Sorry if i m wrong. Please try specifying "/" for ur remote path. It should succeed.

Thanks for ur reply.

Create trigger tr_Prevent_DDL On All Server For Alter_Database, Drop_Database

As

begin

Print 'Restricted';

Rollback;

End

Go

This trigger fires for both the defined events. But It restricts the DROP_DATABASE but not the ALTER_DATABASE....

Hi,

Sorry for the late response.

When tried to change the FTP file name in command prompt using

send abc.xls Newabc.xls

This is successful in command prompt but gives me errors in the...

Thanks for your response.

Is it is possible to create Excel Table in Execute SQL Task with Notes as Long Text and then proceed?

The transfer is successful with Execute SQL...