Viewing 15 posts - 2,026 through 2,040 (of 2,387 total)
Which version and service pack do you have in SQL Server? Check KB 272220 even though it talks about SQL Server 7.0.
http://support.microsoft.com/default.aspx?scid=kb;%5Bln%5D;272220
April 11, 2003 at 12:56 pm
Close the table, reopen and update it.
Edited by - Allen_Cui on 04/11/2003 11:49:40 AM
April 11, 2003 at 10:03 am
It doesn't have to be 'sa' as long as you login/register SQL Server with SQL Server authentication and with proper permissions.
Grant login "NT Authority\Anonymous Logon" to access your SQL Server...
April 11, 2003 at 9:45 am
Can you check who is owner of the DTS job? Try change it to SQL Server Agent account.
April 11, 2003 at 9:23 am
Do you send SQL Mail in your DTS package?
April 11, 2003 at 8:47 am
Remove the tools does not help the relief of memory constraint. Just don't run them.
If you still want SQL Server to run in this machine, Try to reduce configuration of...
April 11, 2003 at 8:25 am
Which version of SQL Server? MSDE? Just curiously, why do you want to do that? Can you just simply delete the executable programs which you don't need?
April 11, 2003 at 7:43 am
Check your SQL Server errorlog and machine application/system logs first to try to figure out why the database is suspected.
Read BOL "Resetting the Suspect Status" and sp_resetstatus for more information.
...
April 11, 2003 at 7:27 am
Have you tried from control panel --> Add/Remove programs ?
April 11, 2003 at 7:23 am
Ther is no such switch /1GB. /3GB actually allocates 1GB for OS and give the rest memory to applications such as SQL Server. If you don't specific /3GB in boot.ini,...
April 11, 2003 at 6:52 am
You can export/import user database but no system databases from 7.0 to 2000.
April 11, 2003 at 6:47 am
As you already know, you can move the database by detach and attach. You also can backup and restore it.
You can't export and import the system databases from SQL...
April 10, 2003 at 12:52 pm
It is for Win2K Advanced Server. See Below.
boot loader]
timeout=30
default=multi(0)disk(0)rdisk(0)partition(2)\WINNT
[operating systems]
multi(0)disk(0)rdisk(0)partition(2)\WINNT="Microsoft Windows 2000 Server" /3GB /fastdetect
C:\="PC-DOS"
April 10, 2003 at 12:44 pm
Can you post your query too? Do you see any errors in your SQL Server errorlog? Which version and service pack do you have for SQL Server?
April 10, 2003 at 9:35 am
Viewing 15 posts - 2,026 through 2,040 (of 2,387 total)