Is the drill down a sub-report or a layer in the matrix?

Mike Levan (12/18/2007)

---

when i tried doing this

select startDate from tblemp where startDate between '1/1/2006' and '12/31/2006'

i dont get that date range, why?

startdate is varchar(100), I Cant change that in the...

I don't see any errors for Database Mail in the log you have posted. Here is an example of output from msdb.dbo.sysmail_event_log with an error:

1 ...

Since it is dynamic sql why not do this:

ALTER Procedure dbo.showjobs

@dbname varchar(20),

@beginDate datetime,

...

p1naga (12/18/2007)

---

This query is given to me by the developer, so i dont know why he is using this convert statemens.

i created a covering index for table T1,but still it...

Could you post the code and the exact error?

It sounds like the object is not being created successfully.

How are you loading the data, bcp, bulk insert, sql? How long do you have to complete the load? How is the data used after the load?...

It sounds like you are returning too much detail to the report server and it is timing out aggregating and displaying the data. Have you tried reducing the details...

I would use one database to house candidate information. SQL Server is designed for concurrency.

If recruiters are not changing candidate data you could mirror the database or use transactional...

Can you manage the report server using SSMS? In SSMS you can connect to a report server and manage security from within SSMS.

No you do not need a setting in alias local host server.

If you right-click on Database mail and select View Database Mail Log you will see what is happening and...

Is the database set to autoclose or single user? If autoclose connecting to it should open it.

Here is a link where someone else had this problem:

http://sqlforums.windowsitpro.com/web/forum/messageview.aspx?catid=83&threadid=44601&enterthread=y

I don't think it is going to happen. Couldn't you display a link to the media file and through the application association have the file play? I am...

Maintenance Plans are run by SQL Server Agent. Have you set up the Mail Profile for SQL Server Agent? SQL Server Agent Properties -> Alert System

I am not sure what you mean by maintaining a database for environmental science, but I am of the opinion that regardless of the data being stored in the database...