I agree. I have been using DBCC commands in 2005 for months with few issues. That is an odd phrase.

This article, will ok, was not a best practices. It was...

Sad but true stories. We could sit around and talk for hours about the foolish. I think Sean is right - SQL Server has been advertised as easy and wizard-friendly....

I agree with Remi - it is better to have a target list rather than a * - you know what you have.

Patrick,

maybe we can meet outside and have some from this green stuff they used to drink in France. (You remember?!?)

Laughing. I do. I have not gathered up my courage to...

Congratulations Frank. Now you can go outside once in awhile and look at that bright thing in the sky.

Firefox just released version 1.0.1.

I have used it for about a year. There are some sites that require IE (everything shows up "off" in Firefox) but I would say...

Could you make this a stored procedure? Then you could run it with a EXEC command.

No problem.

From Microsoft:

[SQL Server Developer edition] includes all of the functionality of Enterprise Edition but with a special development and test end-user license agreement (EULA) that prohibits production deployment (for complete...

I could find nothing on standard to enterprise, but there were two articles on upgrading evaluation to retail - I assume the information is the same.

http://support.microsoft.com/kb/237303

http://support.microsoft.com/default.aspx?scid=kb;en-us;281574

Be...

Declare @evalue varchar(?)

SELECT @evalue = master..xp_repl_encrypt @number1 output

INSERT tblpassword (column name 1, column 2)

values ('IT', @evalue)

****

I know it is optional, but I always list the columns to be inserted.

This should...

You will find the error handling in T-SQL to be, well, primitive. There is no function that returns the line number for an error. One reason may be that databases...

What do you mean by implement? S-locks are assigned by SQL Server based on the query.

I have had most of the major certifications (meaning I like to take multiple choice tests). Do I plan to keep them updated? No. I do not (literally) have the...