Found a solution to the fireFox authentication issue

Type about:config into the address bar and click on the button to bypass the warning.

find the entry that reads network.automatic-ntlm-auth.trusted-uris and add the...

Yeah, tell me.

I have one question you may be able to answer. When I connect using fireFox it asks me for my network credentials before continuing. Any idea...

Yes, just double checked. Closed all instances of IE, ran a new instance as an administrator, same issues.

Yes, we'd already ploughed through that articel and were using both trace flags. But the message we keep getting in "The system database cannot be moved by RESTORE"

I've run some more tests and what I'm getting is that the PreExecute() executes as soon as the entire data flow starts, the PostExecute() executes as soon as the data...

Thanks Phil, the component does exactly what I need and has solved the issue admirably.

Yup, all tables had their statistics updated with FULLSCAN after migration, and the migration actually occurred 4 years ago and statistics have been updated frequently since then to ensure that...

Brendan: The only thing which makes multiple procedures for parameters a pain is where I have 5 or 6 optional parameters with multiple combinations - it would mean hundreds of...

Breandan: This has work very well for me in the past where we have been able to do it.

In our situation we had a complex query that was required to...

Good point, that had slipped my mind. Thanks.

Gilamonster: I was expecting to see exactly what you showed, and it was the fact that I wasn't that was causing me confusion. I tried the procedure without clearing...

I don't want to use the option RECOMPILE. These procedures are almost always driving the websites and get hit magnitudes more than our in-house apps, so it is going...

Grief, were you sitting on the forum!!! That was an incredibly fast response - thanks! :w00t:

I think the word I'm looking for is "bugger". I was really hoping that...

I'll dig back through the history and check the semaphores.

As for anything running, we couldn't see anything at all, no index rebuilding, dbcc's, page spltting, etc.

The only thing that i...

Was this ever resolved?

I am encountering the same issue with my SQL Server.

It is on a server dedicated to SQL Server with nothing else running on it. Occasionally I...