By the way, the best page I know covering the topic is http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/intlfeaturesinsqlserver2000.asp

Steve

When I was coding Oracle, I had a coworker that really enjoyed using Textpad. I went mostly went with the tools Oracle provided for me. In SQL Server, I use...

Jerome,

If you're using Unicode, you don't have to worry about switching code pages when switching languages. You do have to think plenty about sort orders.

Are you sure you want your...

Jim,

What you're saying doesn't make sense from the code you're showing. As far as SQL Server is concerned, table case_roles should not have any update locks, because you are simply...

Steve,

That seems to be the answer. After getting a bit of an education on Windows Services I changed the service account. The message doesn't come up anymore.

Steve

Thanks, Steve, that's about what I needed:

EXEC master..xp_cmdshell 'osql -Smy_server -Umy_user -Pmy_password -imypath\myscript.sql -n'

The site where I found that appears to be gone, but it can still be found here:...

mrd101,

Is there a reason you like embarcadero over Query Analyzer?

Steve

I think that did it. Thanks. Now all I have to do is test it in the real code.

print 'Test: ' + master.dbo.fn_varbintohexstr(0x0000119300001F48000000270000188A00001B6400000000)

Output:

Test: 0x0000119300001f48000000270000188a00001b6400000000

Steve

>> what version of SQL Server are you running on?

SQL Server 2000 MSDE

>> eventually plugged through with the help of a function.

I tried this, but I'm not getting anywhere with...

I'm not sure I'm following. This works:

ALTER FUNCTION GetTableName (@str1 NVARCHAR(100), @str2 NVARCHAR(100))

RETURNS NVARCHAR(200)

AS

BEGIN

RETURN RTRIM(@str1) + @str2

...

Figured as much. Thanks.

Steve

I can see how you might have been confused. I meant to say, "I have an extended stored procedure built". As you probably know, an extended stored procedure is nothing...

Typist. Dvorak at work, QWERTY at home. I have a Kinesis Classic at work. We have an MS Natural (split) and a standard keyboard at home.

I'm almost up to...

Oh, I went and expressed the wrong disk. At $14 it is no great loss, but it is a little embarrassing. The readme you referred to above first says that...

Beware. Don't do what I did.

There are different ways to get SP2 for MSDE. The only one that has merge modules is the one that MSDN Universal subscribers can request.

Steve

...