You can use either method as Backup is an on-line operation in SQL Server. A backup will take some I/O and cpu, but likely will not be noticed by...

Have you tried using the WINDOWING functions, ROW_NUMBER(), etc...? Something like:

;WITH cteFirstLast AS

(

SELECT

hID,

...

Can you post your asp code? There has to be something wrong there because you should either get an error or data? Do you get the column header...

What is the Code Page of the source (in the properties)? Does the Code Page of the destination match (for a flat file this is on the connection)?

One option...

I'm not aware of any functionality like this. I think the closest you could come would be to use subreports.

What is the error message you getting returned from the asp call?

The calendar control only returns a date. You can type in the time after you choose the date. Another option would be to have a second parameter for...

Sounds like you want row groups NOT column groups.

You need to look at the step details for that job to get the specific error caused the step to fail. You could also use a query like this:

USE...

This is a classic "It Depends" situation. Does the report need to merge data from the 2 data sources or is each data source a different section on the...

It looks like, based on 4-part naming, that you are running this across a linked server. You may get some better performance by using OPENQUERY/OPENROWSET or creating and SP...

When you run CHECKDB without any parameters (see here for list) you should get informational messages for each step in the process in the messages tab of SSMS. Something...

I don't think this is possible with the default parameters. This is why there is the multi-value parameter available if you can use it.

This is not perfect as I don't have SSIS 2008 on at work, but if you take the code, not including the procedure/method signatures you should be well on your...

So where in the report is the expression that you posted?

Is there one parameter and then you are trying to get the entire month range?