Viewing 15 posts - 35,446 through 35,460 (of 39,720 total)
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,...
January 6, 2004 at 10:29 am
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...
January 6, 2004 at 10:25 am
Using Mozilla 1.5 here and I see standard HTML. Reload doesn't bring in the Active X control, but otherwise works fine.
January 6, 2004 at 10:21 am
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...
January 4, 2004 at 6:19 pm
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...
January 2, 2004 at 1:10 pm
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...
January 2, 2004 at 11:02 am
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...
January 2, 2004 at 11:00 am
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...
January 2, 2004 at 10:41 am
Not entirely sure, but I'd say 3rd party app as well.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
January 2, 2004 at 10:36 am
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
http://www.sqlservercentral.com/columnists/sjones
The Best...
January 2, 2004 at 10:35 am
It can help, each file uses a different thread, so this can be benficial. More physical drives can help as well.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
January 2, 2004 at 10:33 am
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]...
January 2, 2004 at 10:22 am
Wouldn't recommend it:http://www.sqlservercentral.com/columnists/sjones/autoclosefordatabases.asp
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
January 2, 2004 at 9:57 am
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...
January 2, 2004 at 9:55 am
Viewing 15 posts - 35,446 through 35,460 (of 39,720 total)