Dear Vsamantha35,

Have you tried to compress your backup ??, if so you must specify a MAXTRANSFERSIZE option in your backup greater than 65536.

Just one idea

Old Hand,

It is possible to use the listener name in a transactional replication environment that is using always on, perhaps you will need to re-create a replication suscriber and remove...

Thanks for your responses,

but it appears that in SQL Server 2008 (r2), is not possible to capture  store procedures parameters, I have tryed with the events commented above and it...

Thanks all for your responses,

My question now is Why?  Why does not works as is ? we are suggested to a very strict change control policy

Thanks

Thanks for your responses,

This code is legacy for a client, I am thinking that the original developer tryed to validate their input parameters at the wrong side, fldinfo is a...

Folks,

Thanks for your ideas, is clear now to me, that only I need is to have a plan that helps me to use what I already have.

Thanks again.

Jeffrey,

Thanks for your ideas, but this server packages are deployed in the file system, and called via SQL Server Agent.

I have found, this old thread, I don't know, if still...

cboone,

Perhaps, this can help

https://stackoverflow.com/questions/1273489/ssis-cant-find-32-bit-odbc-driver-in-debug-mode

https://stackoverflow.com/questions/13943765/why-does-my-odbc-connection-fail-when-running-an-ssis-load-in-visual-studio-but/13960063

Good luck

Friend,

Please, enable and check in your PostgreSQL server, error reporting log files and keep an eye in the log, just to check that you are really connecting or disconnecting, the...

Friend,

Have you checked, that you can connect, as a client to your PostgreSQL Server  from another computer?

Have you checked that you are allowed to connect to PostgreSQL with your user...

Friend,

Your problem is not in the System Databases, may be in your user databases, so I could change the compatibility level only in these databases. If possible, ask your ETL...

Hi,

Thanks for your response,

I have checked the following conditions:

1.) I am choosing partitioning because the size of the database does not matter.

2.) Index maintenance is taking too much time.

3.) User...

Hi,

Assuming that your target database in the ssis package has an updated compatibility level that is different from your source instance.

https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql-compatibility-level?redirectedfrom=MSDN&view=sql-server-2017

Hi,

Have you checked the compatibility level, of the query in your SSIS, I'm assuming that you have a query inside your package.

Good luck

Perhaps,

You should see your AlwaysOn Dashboard

good luck