Viewing 15 posts - 31 through 45 (of 47 total)
This is how I handle this situation:
1. run sp_dropuser for the database
2. for SQL logins run sp_addlogin. for Windows logins run sp_grantlogin
3. run sp_grantdbaccess for the login(s)
4. run sp_addrolemember...
August 27, 2003 at 6:54 am
Use sp_purge_jobhistory to purge the job history.
August 26, 2003 at 6:39 am
How are you doing the counts in EM? If you are just looking at properties of the table, then you can possibly get a wrong count in EM. I am...
August 25, 2003 at 1:40 pm
Look up "guest user" in BOL. It has a pretty decent explanation.
August 21, 2003 at 12:16 pm
Try this: sp_password [ [ @old = ] 'old_password' , ]
{ [ @new =] 'new_password' }
of course, you must be logged in...
August 21, 2003 at 12:11 pm
Look at these KB articles as possible causes and resolutions to your problem:
http://support.microsoft.com/?id=307356 INF: Understanding Merge Replication Article Processing Order
...
August 20, 2003 at 7:08 am
Is this a fresh installation of MSDE or are you applyint a service pack to an existing insallation? Also, exactly how are you installing (i.e. command line parameters)?
August 19, 2003 at 7:45 am
The data space and memory limits are the same. However, there are other differences you need to look at. It would be too lengthy to mention here, but you need...
August 15, 2003 at 1:59 pm
SQL Server 2000 dynamically acquires and frees memory as needed. It is typically not necessary for an administrator to specify how much memory should be allocated to SQL Server, although...
August 13, 2003 at 9:36 am
Renaming a Server (From BOL)
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 do...
August 12, 2003 at 1:29 pm
The only way I know would be if you had scripted the job and kept the query. Then you could rebuild the job through the query.
August 11, 2003 at 9:44 am
There is a Maintenance Plan wizard you can use in Enterprise Manager. It will guide you as to what type of maintenance you will need. It is not the end...
August 8, 2003 at 1:47 pm
Or, you can use the dbcc shrinkdatabase command. See below:
DBCC SHRINKDATABASE
( database_name [ , target_percent ]
[...
August 8, 2003 at 6:29 am
Thanks for the reply, but I take exception with what you said about ALL publications. You CAN reinitialize a single article for Transactional push subscriptions. I do this a lot....
July 11, 2003 at 1:34 pm
Viewing 15 posts - 31 through 45 (of 47 total)