The defense for this was that SSWUG were acting as a collation service so that all relevant links were present within their site.  There is something to be said for...

Here in the UK anti-fit jeans are being marketed

I've been wearing them for decades and I can buy 6 pairs for the price of...

master..xp_fileexist 'c:\test'

I don't have a SQL7 box to hand but in 2000 you do the following within Enterprise Mangler

• Right click on the server and select properties
• Choose the "Server settings" tab
• Under default...

Grant permissions to a role rather than a user and then assign users to the role.  A user is more likely to leave than a role is to become obsolete.

USE...

try exec sp_changedbowner 'domain\user'

The thing with sp_addalias is that many logins can be aliased to one user.

Does your ASP page use SQL Authentication or Windows Authentication?

I've found that in some cases I have to fully qualify a stored procedure name with the database.owner.storedprocedure.

exec sp_addalias 'domain\username' , 'dbo'

These days the correct method is to make your user a member of the db_owner role.

The downside (and I use the term loosely) is that they...

Yes it is possible, just don't do it.

http://www.sqlservercentral.com/columnists/rmarda/letsblockthedba.asp

Change you SA password and see who complains, then shoot them.

If you don't want to go down to the second you could try SMALLDATETIME which has half the storage requirements.

The strange thing is that both types store two numbers, in...

Yes, it is an unusually poor effort from Microsoft.

One particularly annoying function is that when you script a trace one of the first comments is that you cannot script to...

I tried the following

DECLARE @sText VARCHAR(250) ,

 @sRep VARCHAR(250)

SELECT @sText = 'This is'+CHAR(10)+CHAR(13)+'is a'+CHAR(10)+CHAR(13)+'test' ,

 @sRep = REPLACE(@sText,CHAR(10)+CHAR(13),' ')

PRINT @sText

PRINT @sRep

You've probably tried this already but try replacing just the CHAR(10) and...

I've not had a problem with

DECLARE @vbCRLF CHAR(2)

SET @vbCRLF = CHAR(10) + CHAR(13)

SELECT REPLACE(@myVarChar,@vbCRLF,' ')

A psychopath likes money, power and sex?  Presumably normal people are happy with two out of the three?

Actually, the more I read the article the more it sounded like Tony...

One thing to watch out for is the default language under which your server is configured.

If it is US_English then CAST('01/05/2004' AS SMALLDATETIME) will give 5th January 2004.

To get around...