Out of interest, did you use services.msc or SSCM to change the service accounts?

If services.msc, remove the user from the admin group and use SSCM to change the service account...

You would have to set the fileattachments property of the send mail task to an expression which takes in the dynamic filename.

Is the filename generated already within the SSIS package...

Service packs are version specific but not edition specific

So, you can get SQL 2008 SP2 and this will apply to SQL 2008 Standard, Enterprise, Express etc

But if you got SQL...

There is the autorefresh option on the properties of the report, so you can have it refresh every X amount of seconds.

So I guess it would just be a case...

Sorry, it might just be me reading this but it doesnt seem very clear.

How do you determine which value should go in which textbox?

But it looks like you need nested...

Robert Davis (6/25/2012)

---

We told Brent about that bug in the script last week. He said he'd look at it as soon as he could. that line you mentioned should be...

You need between 1.5 and 2.2 times the space to create the constraint, so if your table is 10GB you need between 15GB or 22GB space. You could get...

Following on from Adi.

Please detail exactly what you are trying to acheive.

Supply DDL, DML and sample data along with the expected outcome (2nd link in my signature will help you...

The main two I didnt do to good on where designing a server & db solution and designing a monitoring strategy. Both bars the same on that one.

Then High...

Congrats - somewhere good and with good prospects I hope.

Just been given the go ahead to rebook 70-450 for Thursday, think I will book an earlier one around 8 or...

As Gail said, I would first ask the auditers what they define as monitoring and what they want you to monitor.

Then you can take it from there as what to...

What is the question?

Yeah very basic, can buy my copy off me for £60 if you want? Wasn't worth it though, will be putting that back up on Amazon when I get...

Accessability, scaleability, security.

1 - how will your users access your machine to run the reports?

2 - is your machine powerful enough to handle your daily work load and all of...

You need to have the reporting services service running on a server somewhere, this can be the same server as your SQL server or a different server, that is up...