Is there deffinatly a column called PriceIndexID in PricePeriod?

If not which table is the column in as the join is wrong.

Also I would read this on catch all queries http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/...

Sounds like you want a file watcher task.

Yesterdays article was on such a thing http://www.sqlservercentral.com/articles/SSIS/91068/

Does the below work?

DECLARE @Latitude float = 8.4827

DECLARE @Longitude float = 76.9192

DECLARE @ID int = 1

UPDATE [MarvelTour_DEV].[dbo].[LocationCopy]

SET

LocationGeography = geography::STGeomFromText('POINT('@Longitude+' '+@Latitude+')', 4326)

WHERE LocationID = @ID

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...