I have checked security and is good. This package enumerates thru files , imports the data into a staging table and runs a Stored proc against this...
Package fails at ForEach File loop with the following: Description: The For Each File enumerator is empty And still works with no issue if right...
Hi, I have a package which executes the latest version upon right clicking within MSDB. If I were to call this from a Stored Procedure, an older...
Thanks , will try it !!!
Appreciate your response. Probably can try vendor's point of view.. Thanks!
Hi, One of the queries in our Timekeeping application (vendor app) takes around 4 mins to complete from the application Interface. Ran this query in...
This is a SQL user account. Funny thing is if this user types in the backup folder path and runs the backup process, works fine. Issue is when he is...
Hi, I have granted dbo, db_backupoperator role but when this user tries to change the location of the backup folder using SSMS, the following error...
One of our core switch was spitting errors and is in the mode of being replaced. Appreciate your help. Thanks
Thanks! Apparently our Network Engineer found errors ona few ports at our Data Center which could be the possible source of this slowness. Will keep...
I'm restoring of a network drive assigned to this node.
Hi, I'm in the process of restoring a 15GB db into our SQL Server 2005 X64 env deployed on iSCSI SAN which takes 2 hours. Lookigninto the Activity...
Separate names with a comma.