Viewing 15 posts - 1,951 through 1,965 (of 2,387 total)
From BOL.
"After you upgrade from SQL Server 7.0 to SQL Server 2000, it is recommended that you repopulate full-text catalogs and update statistics. Both operations can be time-consuming, but will...
April 23, 2003 at 9:21 am
By default, MSDE 2000 will use NT authentication only after successfully installed. If you like to change it to use SQL Server authentication, you can modify the registry key.
April 23, 2003 at 8:26 am
You have different sort order setting in your SQL Server than the master database you tried to restore. That is the problem.
Rebuild master database with correct sort order which is...
April 23, 2003 at 7:12 am
The share directory is the place your database backups have to be and those backups will be used to database restoration in standby server. The standby server has to be...
April 23, 2003 at 6:50 am
Example,
WHILE 1 = 1
BEGIN
SET ROWCOUNT 10000
DELETE FROM YourTable WHERE xxx = yyy
IF @@ROWCOUNT = 0
...
April 22, 2003 at 2:39 pm
Please ensure the share can be accessed by both SQL Server service accounts and enter 'network share name for backup directory' in UNC format, for exampe, \\tstsql01\logshipping, in the wizard.
...
April 22, 2003 at 2:30 pm
There is not such bulk deletes in SQL Server. Delete large amount data will generte large transaction log entries but if you delete the records in batchs, for example, 10000...
April 22, 2003 at 1:57 pm
Do you have performance issue in select statement too? Can you post your update statement? Have indexes be defined properly on the table? What is "OLE DB Provider Options" setting...
April 22, 2003 at 1:23 pm
If you install SQL Server 2000 and SP3 directly (without go through SP1, SP2), Both EM and sp_server_info will give you identical SP information. But if you already have SP2...
April 22, 2003 at 1:02 pm
Natalie,
You have 8.00.679(SP2) from EM is because you have applied SQL Server hotfix MS02-061 for Slammer Virus. 8.00.534 (SP2) is real service pack you have.
Apply hotfix seems it doesn't...
April 22, 2003 at 12:39 pm
When select lagre amount data with EM and your EM could froze. Many reasons could be the cause, for example, the CPUs usgae is very high, busy disk I/O and...
April 22, 2003 at 12:35 pm
I saw the difference in my servers too but it is caused by the installation of hotfix.
Can you post your SQL Server version from both sp_server_info and EM property?
April 22, 2003 at 12:17 pm
As long as 'dbo' is granted to this user, you don't have to assign other database roles. 'Public' is default for all users.
You may have two tables with same table...
April 22, 2003 at 9:48 am
Viewing 15 posts - 1,951 through 1,965 (of 2,387 total)