Search Results | SQL Server Performance Forums

datediff.. timediff??

Post by: bparow, May 17, 2007 in forum: General DBA Questions

where PUB_CDE < DATEADD(DAY, DATEDIFF(DAY, 0, GETDATE()) -7, 0) gives me the following error: Syntax error converting datetime from character...

datediff.. timediff??

Post by: bparow, May 17, 2007 in forum: General DBA Questions

I have a column in my database called LST_DTE and a column called PUB_CDE. The data in the PUB_CDE has a list of Publications and the data in the...

Can I program subscriptions into report

Post by: bparow, May 14, 2007 in forum: SQL Server 2005 Reporting Services

OK, I've got the data-driven subscription done for 1 of the reports. I have it setup as a file share delivery. All of the reports will be delivered...

Can I program subscriptions into report

Thread by: bparow, May 14, 2007, 2 replies, in forum: SQL Server 2005 Reporting Services

I have 17 reports that I converted from Crystal using VS 2005. The reports work fine and now I am getting to the delivery phase. Each of the 17...

rsErrorOpeningConnection

Post by: bparow, Mar 14, 2007 in forum: SQL Server Reporting Services

Can somebody tell me what the best way is to debug this issue? I am trying to check the event log's Security tab on the Sql server for something but...

rsErrorOpeningConnection

Post by: bparow, Feb 28, 2007 in forum: SQL Server Reporting Services

Hey bugster, That seems like a good place to start. I have the database on one server, the reporting server on another and I'm accessing the report...

rsErrorOpeningConnection

Post by: bparow, Feb 16, 2007 in forum: SQL Server Reporting Services

I am getting this message as well. An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source...