Hi Darkmunk,

I have this problem in my third party application. If a user clears a field, it leaves an empty string in a VARCHAR field, which is not the same...

I was wondering what factors the optimizer might use when deciding to use local or remote data in a query involving a linked server, having suffered collation problems before when...

Um, can't help feeling we're flying in ever-decreasing circles here!

@@ERROR will return a non-zero value if you attempt to insert a duplicate value...

I agree, consumers are reshaping the way the Web is used, and business is having to adapt

I played Call of Duty with my kids on the Xbox at the weekend and ended up getting completely fragged .

I wonder if SQLServer...

Hi

From BOL

"Because @@ERROR is cleared and reset on each statement executed, check it immediately following the statement validated, or save it to a local variable that can be checked later."

Any...

A global brand which displays astonishing corporate arrogance, spying on its customers, missing a surge in demand for significant new technologies, delivering faulty product which blows up in the customers...

Without wishing to provoke discussion , I think you have globalisation (i.e. the U.S.) to thank for that.

My dad told me the same,...

Hi,

You could write the filename to a table on your target system once the copy had completed (verify that the file is present in the target directory and that its details...

Aha,

I see from the link that as I am a Brit, I should insist on the proper use of 'Milliard' for 10⁹ and 'Billion' for 10¹².

PS:

I stopped at Trillion because I didn't know what came next...

Hi

Re the number conversion.

At the risk of exposing myself to public humiliation, I wrote a script which does this for integers, but I figured that the bit after the decimal...

PS:

My prime suspects for memory/resource eating applications affecting include Virus checkers running out of control and terminal sessions not releasing their resources.

If bouncing SQL Server has no effect on the...

Hi Harley,

found this link on the internet to DBCC MEMORYSTATUS, it seems to be an undocumented DBCC command for Microsoft tech support. If you have DBCC access through SQA, you might...

Aye,

but that applies to my systems

...nothing ventured, nothing gained.

David