Viewing 15 posts - 2,131 through 2,145 (of 2,387 total)
Read Following KB for support network database files.
http://support.microsoft.com/default.aspx?scid=kb;en-us;304261
March 14, 2003 at 7:12 am
You may try to delete it from sysusers table directly.
The public role is a special database role to which every database user belongs to the role by default.
March 13, 2003 at 2:53 pm
Can you use select statement to list all your users in Access or able to export the users into a table or text file?
Once you have have users name list,...
March 13, 2003 at 1:04 pm
Are these database warm standby from log shipping or replication?
March 13, 2003 at 9:08 am
Quoted from sp3readme.
"If SP3 Setup detects user databases or filegroups that are not writable, it:
Applies the SP3 replication updates to all writable user databases.
Writes a list of the non-writable...
March 13, 2003 at 8:54 am
Use following commands to verify the database collation and sort order.
select DatabasePropertyEx('msdb','Collation')
go
select DatabasePropertyEx('msdb','SQLSortOrder')
go
And use trace flag T3608 for your MSDB restoration or re-attachment.
http://support.microsoft.com/default.aspx?scid=kb;EN-US;224071
March 13, 2003 at 7:34 am
In SQL Server, System admin (sa) or logins with 'sa' privilege are the database adminsitrator who are able to do anything.
You can create and maintain two database roles with proper...
March 12, 2003 at 7:02 pm
Sort order 51 is Dictionary order, case-sensitive, for use with 1252 character set.
sp_helpsort
March 12, 2003 at 12:52 pm
sp_who2 should be enough to tell you who are connecting this database. you have to kill all connection to this database before rename it.
use master
go
sp_renamedb 'CE85Test', 'CE85TST'
go
March 12, 2003 at 9:05 am
MSDE doesn't have EM but if you have other SQL Server installations, you should be able to use the EM for your MSDE.
Or change the following registry key with...
March 12, 2003 at 8:19 am
I would check whether user who is configured in Oracle Linked server 'Warehouse' in SQL Server has select permission to 'Products' table in Oracle side.
March 10, 2003 at 2:21 pm
Do you query other tables with nothing too?
Try select * from openquery(Warehouse, 'select * from SYS.ALL_USERS'). It should give all your username in Oracle database.
How to you configure Oracle Linked...
March 10, 2003 at 1:50 pm
Viewing 15 posts - 2,131 through 2,145 (of 2,387 total)