Viewing 15 posts - 1,831 through 1,845 (of 2,387 total)
You have to either clean up your data or add additional unique column such as identity column to create the constraint. Strongly suggest you to clean the data.
May 13, 2003 at 1:16 pm
SETUSER can be used by members of the sysadmin fixed server role to adopt the identity of another user in order to test the permissions of the other user.
Only...
May 13, 2003 at 6:50 am
We are running SAP too and the application servers connect to database using TCP/IP. Maybe you should search SAP notes for those errors.
May 12, 2003 at 2:14 pm
quote:
TCP/IP were failing at random.
Do you see any error messages for above failing?
Check the...
May 12, 2003 at 1:48 pm
Do you have any workstations configured with named pipe in client network utility to access SQL Serevr without going through your application servers?
You can change the network access order by...
May 12, 2003 at 1:03 pm
From BOL.
"Error 9002
Severity Level 19
Message Text
The log file for database '%.*ls' is full. Back up the transaction log for the database to free up some log space.
Explanation
The specified transaction log...
May 12, 2003 at 11:54 am
What is your TEMPDB collation? It should be same as your server collation.
Edited by - Allen_Cui on 05/12/2003 08:48:51 AM
May 12, 2003 at 8:48 am
Have you corrected the sysservers system table with procedures after renaming the server?
sp_dropserver old_name
GO
sp_addserver new_name, local
GO
Use sp_helpserver to find out the server name.
Edited by - Allen_Cui on 05/12/2003 08:32:50...
May 12, 2003 at 8:32 am
Did you get this error from EM in the machine your SQL Server installed? Can you try to use EM from another machine? Any service pack for SQL Server?
May 12, 2003 at 8:03 am
Did you receive this error message by tring to add new login or grant existing login to access database?
What is your database collation?
May 12, 2003 at 7:28 am
Have you tried to use sp_change_users_login?
May 12, 2003 at 7:13 am
'sa' means 'System Administrator' here.
Is same account used for SQL Server service too? I would try to change service account to system account in SQL Server Agent property to see...
May 9, 2003 at 11:32 am
Those servers may be in different domain than others that you have permission to start/stop services.
You can remote manage those serevers to start/stop services but you need to be...
May 9, 2003 at 9:52 am
As you know, trigger doesn't work with select statement.
Maybe using third party tools to examine the transaction log files is another option.
Edited by - Allen_Cui on 05/09/2003 09:35:59...
May 9, 2003 at 9:35 am
Is this you are looking for?
When you change the name of the computer that is running Microsoft® SQL Server™ 2000, the new name is recognized during SQL Server startup. You...
May 9, 2003 at 9:23 am
Viewing 15 posts - 1,831 through 1,845 (of 2,387 total)