How to Develop report with Parent-Child relationship from Relational DB

hello all, I am stumped at this and pulling my hair out. Below is the Stored Procedure I am using.…

Alret when restore not happened from last 5 hours in Logshipping

Hi Friends, I need you idea for setting up Monitors for Logshipping, If Last restore does not happe…

Need to delete a row from the source table

I have a source table and another table with duplicate rows in it. I want to delete a row from the …

Delta Pull for new added data

Hello guys, I have created SSIS Package to pull some data ,we update data every week .But now i nee…

PIVOT/UNPIVOT Question

Hi , I have a req as follows: My table structure is something like below: TestIDDistinctionFirst…

What is the third 'file' in the database folder.

what is the type of 'file' in the database folder other than .mdf and .ldf files. what is its use. …

Dsiplaying month & year in cross tab report

Hi, How to display both month & year in the format like Oct-12, Dec-2012, Jan-2013 in cross ta…

Max number of user connections available...

hi, Can anyone please advise, what are the maximum number of user connections allowed in each diffe…

Database Backups

Hi, I currently backup my databases everynight and also run a maintenance plan that deletes backup …

DBA Leaver Checklist

Hi, I'm currently working with a client that has had their DBA leave. This person had the "keys to …

Data in Foreign table not reference primary table

Sorry Administrator (My Data is SQL Server 2005, I post in SQL Server 7,2000 :blush:) My Data Error…

SSIS SCENARIO

Hi, Is there any difference between OLEDB Destination and SQL Server Destination in SSIS. Thanks in…

Which one is faster?

please tell me what is wrong with this query run on Northwind

Select Orders.OrderID, 'Order Total', 'order count' from Orders, (SELECT SUM ( [Order Details].…

Created Proxy to Execute SSIS Package Job worked fine but it does not allow Run AS SQL Server Agent

I created a Proxy to Execute SSIS Package Job worked fine but it does not allow Run AS SQL Server A…