sp_help_revlogin on the MS Technet site can script out old logins that you can transfer to the new server. DTS has a "TRansfer Users" task as well in SQL 2000.

Also,...

We see similar ones on our DB2 machines at times and usually use the IDS to trace back where the source is and use a firewall to block the IPs...

Using Mozilla 1.5 here and I see standard HTML. Reload doesn't bring in the Active X control, but otherwise works fine.

Will a view not work?

If not, then a trigger might be the best way to ensure things are up to date. Set up one for inserts, separate fro updtes, third...

I'm thinking the same thing.

I think you'd have to do fulls periodically. At least to keep recovery.

If you do the file backups, then you can probably restore these, ignoring the logs, but it would...

Tend to agree, don't like to see threads closed. If the suggestion worked, let us know, but I like to have others be able to continue the thread if need...

Interesting question. I assume that the Verify backup does just that. Personally we take a slightly different tact.

Each day the backup file is named with the time it starts are...

I'd use a central procedure that takes the parameters and then calls one of 10 or so subprocedures that performs the search. Seems like a pain, but you set it...

Not entirely sure, but I'd say 3rd party app as well.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

I believe it's a byte issue, 256 possible values, -1 for no indexes (0), -1 for clustered (1), maybe a few system items, 255 might be locked out.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best...

It can help, each file uses a different thread, so this can be benficial. More physical drives can help as well.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

I ran this from one session:

CREATE TABLE [dbo].[tbltest] (

[Pkey] [int] IDENTITY (1, 1) NOT NULL ,

[fname] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[lname] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL

) ON [PRIMARY]...

Wouldn't recommend it:http://www.sqlservercentral.com/columnists/sjones/autoclosefordatabases.asp

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

Tend to agree with the above recommendation. Backup and restore works fine for me as a one time shot, but for continual movement of changes, I like to have a...