I have this query thats taking almost 20sec to complete. we need to optimize this to at least reduce the run time from 20sec to 4-5sec. I have...
Hi, I have a package which has 4 steps and let say the package fails while executing at step 3. Now i want to rollback everything whatever was done...
I need a query which will return all the stored procedure which has a particular table called in it. For eg we have table called PRBuild_DealAll_DT...
Hi, I need to know if there is some query which would pull up all the SPs where the hardcoded values have been used from a particular DB. For example...
System.DateTime.Now gives me the system time but i need to display the time of the server which is located at the different place what command should...
I need to run a query which would return the last date of the month. Suppose i am running this query in May i need to get the result as 20080430 i.e....
If i update or delete some set of record then how do i rollback the changes. Is there any query for it. for e.g. if i run the following query: Update...
Hi, I want to export the packages from one server to another in the dts format. For packages we dont have any option like import or export. is there...
Hi I have a server with several DBs in it. This server has some linked servers in which we can access only tables and views. i need to access one...
Hi, I have two tables. Main table is soxbillingrelationship having a column as BRID along with many other columns. The other table is BR having just...
Separate names with a comma.
