Steve,

I have thought for a while that it would be great if we had the ability to personalise the content of the newsletter. For example, being able to include or exclude particular...

Hi there,

sp_helpUser?

Is your collation case sensitive?

David

Are you using mixed mode authetication, are the 'non-sa' accounts windows authenticated?

David

Hi,

you said 'for the past few days'. Has your server been performing satisfactorily up until now? Have you changed anything on the server that might have triggered this problem?

Depends if the ink fades and it ceases to be legal tender

David

Or NWDC-NET\Username ?

My father worked hard all his life, and found time for his many hobbies. He was looking forward when he retired to spending a bit more time on them, entomology, mathematics...

Or you could define a separate view for each language

David

Hi Wayne,

thanks for that tip, it certainly worked from SQA. I am speculating that for some reason the Win2K3 environment is not accessible to the command shell as executed from...

Hi

check out the following command in BOL which will change the ownership of an object

   EXEC sp_changeobjectowner 'objectname', 'newownername'

This may well affect your app, but it depends on how your...

Hi,

are you using the Ramdom2 column for replication purposes, or do you just want a column with a random number in it.

You can convert NEWID() to a positive integer using the...

Hi Steve,

I think NT backup will automatically skip open files / files in use by default. There is a health warning on using the registry key setting to override this,...

Morning all:

Postscript on the upgrade to Windows 2K3 of my SQL2K server.

Everything seems to work with a couple of strange exceptions. My DR file shipping procedure, which uses xp_cmshell 'XCOPY...

Oops, just realised you said a row,

 still, if you put the contents of the row into a temporary table, you can use the technique above to return the two values...

Something like this?

CREATE TABLE #sillyexample (sillyint INT)

GO

INSERT INTO #sillyexample (sillyint)

SELECT 101

UNION SELECT 202

UNION SELECT 303

UNION SELECT 404

UNION SELECT 505

UNION SELECT 606

UNION SELECT 707

UNION SELECT 808

UNION SELECT 909

GO

SELECT sillyint FROM #sillyexample...