You definitely should communicate your concerns with your manager and get it in writing at least in an email, so when something you are concerned about happens, you can point...

John is right. I just wanted to comment that shrinking your database is not normally a good idea. There is usually a reason why it grew and it...

Can you provide the SQL Statement and a general idea of the layout you need?

Odds are you can do this with a table control with a group on Employee and...

I use the Variables.TaskName to get the Task and ComponentMetaData.Name to get the name of the step (which is the script task). Check out this article[/url] in which I...

How many rows are you inserting/updating at a time? How often are you doing the updates/inserts? Is SSIS an option? Does it have to be real time...

Can you get an execution plan and attach it? Here's a video on JumstartTV that explains how to upload an execution plan to SSC (free registration required).

By using a...

I'd check the security. Who are you connecting as?

How about adding another Catch block to handle a SQLClient error? Perhaps you will get a more specific error message.

Thanks Michael.

That is a better solution. I did too quick a solution.

Start here.

You will create a job, add a step, and put the SP call in the job step. Then create a schedule for the job. The link I...

What OS is the SQL Server on? I have had this problem when testing on VISTA where it is a security issue.

Hey Ram,

We need a lot more information. Where are you seeing the term DOCID maps? What application are using?

David,

What are you trying to find out with your trace? Knowing what you are tracing is great, but without knowing what you are trying to accomplish it is impossible...

By default the ReportServer only keeps Execution History for 60 days. I found this with this query:

select

Value

from

ConfigurationInfo

where

[Name]...

Paul,

I really like this idea of handling it with an "error" in the dataset. It's much simpler than manipulating the subscriptions jobs.

Adam,

I probably came across as being critical of you by using the word "roast" and that was not my intent. Perhaps I should have said "being taken to task"...