Viewing 15 posts - 976 through 990 (of 2,387 total)
The increase of backup time during the peak period could be caused by large amount transactions that need to be backed up. The backup job could also be delayed for...
October 15, 2003 at 11:45 am
quote:
but they still can see all the databases, is there a way to hide the databases?
October 15, 2003 at 9:44 am
quote:
1)I tried sp_who2. This tells me who was on the SQL Server, and I was the only one.
October 15, 2003 at 8:05 am
Try to run dbcc dbreindex and statistics update to your database to see whether you have some kind of improvement. If not, do as Antares686 suggested, use Profiler to look...
October 15, 2003 at 7:55 am
Check login webapps server used to access SQL Server has been granted to acces all databases it needs.
quote:
webapp server cannot...
October 10, 2003 at 1:23 pm
Yes, you can restore/attach SQL Server 7.0 database to SQL Server 2000. There are no difference doing such restoration/attachment between clustered and non-clustered SQL Serevrs.
October 10, 2003 at 9:09 am
By default, 'BUILTIN\Administrators' is automatically mapped to 'dbo'. Try to remove it from access all your databases and remove it.
October 10, 2003 at 7:34 am
Before remove it, make sure you have another NT login with 'sa' privilege and do try to remember 'sa' password. Someone is in trouble after removing it.
October 10, 2003 at 7:20 am
quote:
Would it also be a good idea to force it to run on a single processor?
October 10, 2003 at 7:14 am
You can' rename instance but you can create server alias.
October 10, 2003 at 7:10 am
Or script all necessary SPs from old server and recreate them in the new server?
October 9, 2003 at 2:28 pm
quote:
problem is we might have up to 20 people hammering on this thing at a time trying to put files in.
October 9, 2003 at 2:23 pm
I don't have Windows 2003 server yet but I would try to reinstall SQL Server client tools.
Edited by - allen_cui on 10/09/2003 2:16:03 PM
October 9, 2003 at 2:15 pm
Your are right on BCP. I am wondering you could import the text file first into temp table, manipulate the data and insert into destination tables. It could be fast...
October 9, 2003 at 2:12 pm
Viewing 15 posts - 976 through 990 (of 2,387 total)