Thanks,

so there is no way i can have a script that will pick up the name of the database from error log or from sys table to determine that if...

Thanx George,

i can set up the SQL agent job to take transaction log backup, but what if i have 10 databases on the server and the alerts send me...

Thanks for the ifo guys,

can i set up an alert on the server that if transaction log file is about to be full.

Lets say 90% or 85% so I can...

Thanks, sorry i dodnt see the response, my bad.

i understand where you coming form but I have been asked to do so in a test enviroment.

i can make the case...

Thanks for the response,

The reason I think is the connection to the configuration file is because of two things,

i get the following error

SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method...

Guys, even if no one has a exact answer, some idea would be nice

Thanks,

any one has a idea ??

it so nice to see so many people giving solution for the issue,

i also have a solution which might not be a great one but i think in particular scenario...

Thank you guys, let me dig in to it based on ur advices,

since the queries are ramdonmly been picked..so not so sure if it a particular query.

well i have found the answer of my own question, putting it here if some one else come across the same situatioon.

give the windows user one of the three roles...

thanks for the reply, i was able to solve the issue and puttting it over here for the future if some 1 else gets in to the same problem.

the issue...

first of all thank you very much for all the info

we do have automatic updates and patching but for this particular box they only do manual updates.

i do have figured...

hello every one

first of all thank you for all your help, i was able to solve it and woudl just like to let every one know how.

- when i drop...

Hello,

thank you for ur fast response.

so if i understand it correctly, the fk on the table needs to be truncate table A ( the original table of that...

Hello,

First of all thank you very much for all your help.... ur took time to listen to my adam/eve story when I was totally freaking out.

good news is i...