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...
Application is written in Java. Will trap the SP:Completed event. Thanks!!
Hi, I'm having difficulty relating the trace TEXTDATA values to the corresponding SQL. Our vendor app runs quite a bit of prepared statements. In...
Hi, One of our applications is experiecing slowness (about 2 mins for a simple report) while running reports. These reports when tested within Query...
Hi, I have a Execute SQL Task that outputs a resultset. I would like to check the output variable (which in this case is of the type object) using...
Appreciate your reply Satya. This is one of our Citrix databases which will be divided between East and West coast users. So "primary" database will...
Hi, I'm setting up Transactional Replication for a Databases between 2 Data centers. This is one way replication from Data Center 1 to Data Center 2....
I might not have access to create new blogs. So if someone can post it please.. Thanks
Hi, We have a Health Care app that is installed on SQL Server 2005 EE 654 bit Cluster with Windows 2003 R2 64bit. This app doesn't reconnect users...
Separate names with a comma.
