The unfortunate part thats how the found the table created. Thanks for mentioning the filestream option as the app stores the documents on the db and i did advise the...

Thanks for your response. No row or page compression

when i ran it first time i was on the master db, then connected to the user db

Please attachement when running user_token

I ran the command from his SSMS then return "guest" but the user guest is disabled from the user db's only active in the master and tempdb

Thanks for the response will test and advise

From your job on that pkg, check the properties of the "Data Sources" then the Connection String

see attached pic

Thanks for your response

It's monthly report that will only show 2 months of data comparing previous and current month

is ur pkg stored in msdb or file system? are your pkgs connecting to external rdbms?

Im calling 15 child pkg from the master pkg stored on a file system no...

Thanks will check

Thx Gila, awaiting storage team as the backup is running before the ETL. Will advise on their findings

Thx

Thx Gila, I found de problem it was on how our QA DMZ setup to limit connections to 2000

Hi

As soon as the 1600 user logs in the web page stops rendering but de resources on de db is ok. No error the page nolonger renders

Nyc article but have few things to understand

U have other connections that refers to "FROM [].[VES_MS].[dbo].[Logs]" with no script to create a table referenced

Also the following step but no script...