All the pieces from above, all put together.

SELECT 'ALTER LOGIN ' + QuoteName(name) + ' WITH CHECK_POLICY = ON;'

FROM sys.server_principals

WHERE [type] = 'S' -- SQL Server...

So...

David,

This is definitely an excellent, thought-provoking article. Thanks!

Hi Anil,

This is actually a good example of why you need to provide accurate test data to demonstrate the issue that you're having. The test data did not work for...

I'm surprised that nobody has yet pointed to the excellent DelimitedSplit8K function, developed here on this web site. (Actually, I bet Jeff's getting ready to showcase it later tonight!)

I used...

Tara-1044200 (8/10/2010)

DECLARE @rowcount int

SET @rowcount = 100000

SET rowcount 100000

WHILE @rowcount >0

BEGIN

BEGIN TRAN

Update dbo.Employee set jobcode = 1 Where jobcode <> 1

SET @rowcount =...

Might I suggest the SQL Server 2008 Upgrade Technical Reference Guide?

You probably need to convert those to varchar(max) first.

Don't forget to run the SQL 2008 upgrade advisor - it will...

Here's my two cents worth:

1. You're running on MSDE.

2. As Gail pointed out, this...

Anil,

This method, just for SQL 2005+, utilizes a CTE to build a dynamic tally table. Not much else is different.

-- declare and initialize variables

DECLARE @CNTPRD INT;

SET @CNTPRD = DATEDIFF(D,'2005-12-31',GETDATE());

-- this...

See how this works for you.

-- since you already have a clustered index, we need to dump the table to a temp table

-- where we can build the clustered index...

BTW, you've been posting in the SQL 7/2000 forums. Is it safe to assume that this code is for SQL 2000? If not, what version are you using?

Thanks for the table structure and inserts... good to see that you've learned!

How does this work for you?

DECLARE @CNTPRD INT;

SET @CNTPRD = DATEDIFF(D,'2005-12-31',GETDATE());

-- these two lines of code are to...

Okay, I just noticed that part of what you are doing is based on the previous record. This will require a different approach.

Do you have any indexes on this table?...

Your insert statements don't run...

Msg 109, Level 15, State 1, Line 54

There are more columns in the INSERT statement than values specified in the VALUES clause. The number of...

Jeff Moden (8/8/2010)

Thanks, Drew. Rumor has it that it's also pretty touchy about special characters like...