Well I haven't hit 50 yet, good grief just a few months away though.

Scary to look at this thread, I've been in this business longer than some are old.

Un...

Hey Frank glad you got the link.

Do note it took ages to get the hat, just got mine at home last week. Can't tell when I posted the original...

Why does a 3 gig DB shrink to 180mb, was it the logs ?? if it was you could have considered stopping the db, copying the mdf, then attach...

Frank I just reread part of your note.

DB2 on Windows is a mistake, I don't know what IBM was thinking but the problems are infinite. It works, and is...

I have been going through the same thing. I did a mix of manually creating the change owner and a couple of automated scripts.

One problem I had was that...

Well don't let them convince you the conversion from MF to FP (Fischer Price) is an easy thing.

If nothing else the FP version tends to be a release or so...

Sorry to hear that Frank, I support DB2 on NT and AIX along with SQL Server. Although as of late I am doing mostly SQL Server.

I haven't found any...

The thing that drove me crazy is the server is in the glass house, I really can't / don't go in there.

With remote desktop it didn't hit me...

There is a registry change needed. I had the same problem, made the change and everything was fine.

Can't find it right now, but I'll dig a little later.

Note it...

You really don't have to go through all of this.

Run SQL Server under a Domain account, have it set up NON logon.

Remove Builtin Admins.

Leave yourself via NT auth and make...

Well if the backbone is fast enough, maybe even dedicated nics to the backup server ok.

it introduces another variable to deal with.

Some network overhead,

And I just like having...

I never use Nvarchar unless needed. The application people probably won't know the difference. I have converted from Nvarchar to VarChar and never heard a word.

KlK, MCSE

Personally I would never backup directly to a network share, admin or otherwise.

Backup locally, then either xcopy, or have the backup program read from a share on the db server...

Well if you have ever had the opurtunity to support any of the other major DBMSs, IMS, DB2 Mainframe or Fischer Price (Unix or NT) or Oracle. What requires...

Well I'll probably get flamed a little here, but here goes.

And some of this I continue to blame MS for making SQL Server too easy to use.

I am moving a...