Recent content by aomara

You can simply use this stored procedure to refresh all database views with one command (including dependent views problem handling - Binding errors) Note : this procedure is examined on SQL Server 2005 . CREATE procedure [dbo].[refviews] ( @varViewName VARCHAR(500) = NULL ) --Created on 08...

Any way, Thanks for you concern

End_Date is more important in this case. The summary field shows only the "Count" and "Distinct Count", no any other summerization option avaialble.

lbass, Thank you for your fast response. I try it and it shows what I need, but the point is that I need the Date to be in the Y axis, but because you select "In Change Of", the value field (date) must be summarized. Any idea how to show the date without summarization?

I have a table includes a list of all Contracts (Includes contact Extensions) like bellow: Contract Code , Start Date , End Date , Original Contract Code(for extensions) -------------------------------------------------------------------------------- "A0001", 01/01/2007, 31/12/2007, ""...

I found that opening the detail report in new tab is satisfactory, therefor thank you everybody espically Ian.

Many thanks Marckssg. IanWaterman, could you please explain more what do you mean ? I would like the detail report to run in a new report viewer screen in full screen.

I am having a set or reports, one summary including many values as totals and detail reports for each value. I generate the summary report for certain period, and then run all the details reports for the same period. My Idea is how to run the details report directly from inside the summery...

I change the Agent Profile of the Merge Replication Agent to be "Verbose history agent profile", but there is no place for specifing the output file. I try to search for the log file in SQL Server folder "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL", but I failed.

I have 2 Different server using SQL Server 2005 with SP2 in the same domain using LAN. I establish Merge Replication between the 2 servers on one table "EMP". Note: EMP table have 1 child table with a foreign Key, so I change the Article properties in the Publication to be "Keep existing...

Thanks John. Actually I am searching for formating the results of parameter "@query" which is evaluated during the runtime. I would like to know how to get access to these results.

I am using "sp_send_dbmail" to send Email notifications form the database which is SQL Server 2005. When the Email is sent in TEXT format (Parameter @body_format = 'TEXT'), the result of the parameter "@query" appears good in a tabular format in the email body. But the problem is that when I...

I find my self forced to upgrade the Subscriber to be SQL Server 2005, so every think is OK now. But I have got the experiance that Replication between SQL Server 2005 and 2000 is not reliable specially when the database you replicated is already replicated before using SQL Server 2000.

I have a Merge Replication between a Publisher SQL Server 2005 and Subscriber SQL Server 2000. Whenever I establish the replication and after 2 or 3 successful propagations of the data, the Merge Agent stop and provide this error : -------------------------------------------------------- Error...

Many Thanks mrdenny. I develop this statement. EXEC sp_executesql @p_condquery, N'@p_condresult INT OUTPUT', @p_condresult OUTPUT IF @p_condresult>0 BEGIN ... ... END