No problem   The most useful invention ever created for converting procedural code to set-based code (IMHO) is the inner join to a basic...

It's a variation of the "knapsack" problem.  This is a very old problem, and if you've ever spent time trying to squeeze one more thing into a suitcase for a...

Oh my...  I haven't tested any of these on 64-bit Win2003 or SQL 2005.  They were only tested on SQL 2000, 32-bit.  XP's on SQL 2005 have been deprecated but...

Hi Noel,

I see your point about the scans.  The problem is that SQL 2005 generates a "random IV" to encrypt with.  So this prevents you from encrypting a your search...

You can't connect anonymously to SQL Server.  You're connect string indicates you're using Windows Integrated Authentication to connect to SQL Server.  All this means is when you connect to SQL...

Not exactly what you want, but close:

CREATE TABLE #test ([ID] INT NOT NULL IDENTITY(1,1) PRIMARY KEY,

 [Date] DATETIME,

 Val CHAR(1))

INSERT INTO #test ([Date], Val)

SELECT '2006-06-01', 'A'

UNION ALL SELECT...

Why not just create a table and kick off an INSERT INTO with your SELECT statement above?  You'll save each day's call totals in the table every night.  You could...

Presumably your browser is connecting anonymously to your web server.  When you connect to the web server anonymously, everything it does and all of its interactions with the server and/or...

"Length of service shows loyalty."

I agree, but it's not necessarily an indicator of the employee's loyalty to the company.  A job change on my (or your) resume might very well be an...

Hello.

Are you using ASP or ASP.NET?

Go into EM and make sure that your Windows ASP(.NET) user account has access to your SQL Server.  When you access an ASP.NET app anonymously...

Thanks for the clarification Chris.  I just find it a little annoying, based on my experience, that a candidate who has been at the same job for 10 years gets...

Good article, although I do disagree with one point you made:

"If the candidate has had one position in the last ten years and the employment was continuous, than that resume...

Ahhh they're all on the same server.  Yes, 4 part naming will do the job.

I agree that the OP will get more info back than he needs with C2 auditing (DDL, logins, security info, etc.)  I haven't seen any head-to-head comparisons but I imagine the...

Assume it's SQL 2000 since you specified Query Analyzer.  If you're going to go through all of that, why not just turn on C2 Auditing:

USE master

EXEC sp_configure 'show...