A feature is officially intuitive if it takes fewer than 5 posts from senior members to explain how to click on it.

:laugh:

I did, and it worked.

Sadly I added the 'WHERE CHARINDEX' bit...

Forgot this bit:

[font="Courier New"]Table 'UnwantedChars'. Scan count 1, logical reads 1, physical reads 0, read-ahead reads 0

CPU time = 0 ms, elapsed time = 0 ms.

[/font]

Jeff, Flo, Phil

You will be pleased to see me using a customized tally table here together with a WHILE loop...

[font="Courier New"]SETNOCOUNT ON;

--DROP TABLE dbo.UnwantedChars

CREATE TABLE dbo.UnwantedChars (BadChar VARCHAR(1) NOT NULL);

--...

:laugh:

Very good.

Though I notice that you didn't say what they were faster than - flowing amber, perhaps? 😉

I was given some written English today (from a native speaker) which looked for all the world as if it had been 256-bit AES encrypted.

I rang him instead. :Whistling:

Oddly...

Jeff,

Who needs pretty colours anyway?

Black-and-white courier new 10pt FTW!

I find it just as easy to read and it copies just fine into SSMS, every time.

The effort going into the server-side...

Ashish Pathak (5/1/2009)

---

I have gone through the entore thread. Could you please tell me how my solution is so suboptimal. Will it not work in any condition or will it...

Agreed!

I have the oddest feeling that they don't have separate dev/test/prod environments.

Maybe I am wrong...?

Paul

I used a tally table of course!

😀

nataliehinnen (4/30/2009)

---

The response noted here:

Yes, I knew about how the SQL Server resolves objects when the owner is not given, Sybase did the same thing, back in the day. ...

Barry's advice is sound but I would like to add an alternative view:

If there are to be a large number of users and updates would be frequent (the number of...

Grant Fritchey (4/30/2009)

---

The question bugging me is, how the heck did you know that? There are so many changes between 2000/2005 and then on top of it to 2008. I...

Flo, Ihr Englisch ist viel besser als mein Deutscher!

Hmm. Babel fish - obviously. Isn't Ihr rather formal? Should it...