When you create the subscription you should of given it a username and password, that user needs access to the file share your saving to in the subscription.

Run a trace for the application in question. You say excel, now depending on the version depends on the application name.

We run 2007 so I would trace for the...

The only real advise I can give for the moment would be to read the "skills measured" section of the MS learning website on the exams.

Also if not already get...

What you want is a not in, not just <>.

This should help you on the right tracks,

http://blog.datainspirations.com/2011/01/20/working-with-reporting-services-filters-part-4-creating-a-not-in-filter/

Pretty much the same as IIF but if you want to do >0 and then a different colour for > 10 you would have

=IIF(Fields!FREECASH_AMOUNT.Value > 0, "black",IIF(Fields!FREECASH_AMOUNT.Value > 10, "black","yellow")))

So...

Another one for the colour would be to use the switch function as well, but IIF does it just as good.

Tyipcally I use switch as it can be a bit...

Use VARCHAR(MAX), which will store upto 2GB worth of data.

I have done a check on our domain, and the reverse DNS comes back to the two IP's in the UK and are rDNS'ing via our ISP so all good...

So if I change the PTR to map to companyabc.com instead of the hostname, then in theory it should work.

Thanks Howard, I have checked our hosting domain controllers which govern the "hosted" lan, and can confirm that there is a PTR record for the IP address, in the reverse...

I suggest reading up on deadlock management.

Use the link in my signature to the Guide for the Accidental DBA and take a look in the handling deadlocks chapter

GilaMonster (8/10/2012)

---

anthony.green (8/9/2012)

---

As a checkpoint rights information relating to the transaction log as well as dirty pages to disk, if the transaction is not commited by the time the checkpoint...

Welcome to SSC.

If you would be so kind as to follow the second link in my signature on posting code and data for the best help, I am sure some...

Your first error that database already exists, is because you already have a database with that name.

Drop the existing database or change the name of the database in your script.

The...

How are you performing the backups?

Maintenance plan? Script in a job? Manual running of a script?