Very useful queries ... Thanx alzdba !!!

If you are 'rolling your own' so to speak, then I agree to a limited degree with the posted issues. If not, this it's called a DMS (Document Management System)...

and one more link ...

http://www.sswug.org/see/22238/

I just returned from 'Beta' SQL 2K5 Admin Training. The instructor mentioned that Replication on SQL2K was designed for hundreds (low) of subscriptions and that SQL 2K5 was designed for...

Just one day to gather roles and responsibilities ? Well, there are good posts to go by and lots of information out on the web. I'd really think twice though...

mkeast is correct I've just perfomed the same test and it works (I should have tried it first ... doh !).

user --> long_password

password --> 0123456789abcdefghijklmnopqrstuvwxyzZZZZZZZZZZZZZZ

Maybe it's a service pack issue...

I do not know of any limitations but apparently the problem does exist ... Here's a link I googled ...

http://archives.devshed.com/a/ng/373-78/Password-Length-Issue-With-SQL-Server-2000

No you do not need WIN 2K SP4, SP3 works.

As for your dilemma, either copy model.mdf/ldf files from another server as mentioned above or rebuild model and you should be...

'isql' is still supported as a 'deprocated feature' (it may go away at any time). It is recommended that you use 'osql' instead (the flags are pretty much the same)...

To cut directly to the chase:

use master

go

dbcc errorlog

go

checkpoint

go

It works well as a scheduled task.

Here's a few specific code snippets for your perusal:

---

--- to add a SQL user as 'dbo'

---

 use master

 go

 exec sp_addlogin @loginame='user_name', @passwd='user_password', @defdb='user_database'

 exec user_database..sp_adduser @loginame='user_name'

 exec user_database..sp_addrolemember @rolename='db_owner', @membername='user_name'

 go

 checkpoint

 go

---

--- to add a...

My 'gut' feeling is that you'll be OK based on the fact that the new CPUs are 6+ times faster than the old ... and if they are Xeon CPUs,...

Quite possibly the alert did not fire because many things use tempdb. If tempdb or it's log is full seemingly innocuous code like sp_who, select statements and many other things...

Then for striping, I'd suggest trying to put your backup 'stripes' on separate disk controllers if possible. Good Luck !

Not a problem. As far as striping goes, I've had the best performance gains overall when striping to either 4 or 6 files. (it's depended on hardware ... CPUs, disks,...