What scirpt did you use? If you ran the sp_help_revlogin script, the logins are there. Logins are only at the server level. Users are at the database level.

Yes, just change the destination to 2005.

those statements will update EVERY record.

Are you using SQL 2000? You posted this in 2005, so I wanted to be sure. You could potentially do this in DTS, but it would have to be completely...

Gus, best of luck and hope things keep going through the holidays. Definitely sounds bad, and I know I'd be looking if that happened at RG.

I think part of the decision by MS was so they could use the VS framework, which gives them some nice features without a lot of coding.

However, I think it...

When you go to restart the database engine, it will ask you to stop the Agent, which is dependent on it. SSIS and SSRS shouldn't necessarily be an issue.

Dave,

Thanks for the challenge. Looking forward to seeing the entries.

Do you mean have SQL Server connect to a web service, not a client connect to SQL Server hosting a web service, correct?

There is a task in SSIS that can...

Cast the data first to char, then replace, then cast back. However I didn't think CHAR(13) was valid in a datetime field. I'd do a SELECt first aftetr casting to...

I don't think that SQL Server publishes SNMP information, but I thought What's Up could monitor some things in SQL Server.

I did find this no Windows SNMP for SQL Server:...

Cars are tempting, but with my dream car in the garage, hard to argue for funding for another 😛

I do mess with wood, have built some pens and would like...

Don't shrink it too far. As you add logins and objects it needs to grow a little. I'd give it a 10% pad over what's used and you should be...

I hate in place upgrades. It's a gamble to me, and one that's not usually worth taking. Better to have a second system in place.

What do you mean by autogrowth going above a certain percentage? The autogrowth is by a number or a percentage and is fixed. Do you mean the total size of...