Viewing 15 posts - 31 through 45 (of 125 total)
I end up deleting the user from the database and reassign the rights for that user at the server level.
Anyway it is kind of interesting
May 11, 2007 at 9:04 am
I have the same issue on a SQL Server 2k5 with Win2K3. My feeling is that is some new thing in SQL 2k5.
sp_change_users_login
'Update_one'
May 10, 2007 at 8:40 am
i think the application runs better and has much more features, but from admin point of view - day by day tasks I sometimes miss the EM
May 4, 2007 at 9:08 am
that would be quite true for rebuilding system databases
May 3, 2007 at 5:44 pm
I miss seeing easyly when a job had failed or a database been marked suspect because datafiles wasn't available
April 27, 2007 at 8:57 am
Unless it is a read only type of database, whatever uncommited transactions you might have had in the log file(s) are gone.
You can try creating a new database with the...
March 2, 2007 at 8:13 am
Sorry guys, my mistake, my scenario wasn't quite accurate. I try to simplify it as much as I could, but I end up getting it wrong.
Here I am try...
January 31, 2007 at 12:26 pm
Do you guys know about a good article\book that talkes about maintaining and debuging a replication setup.
From my experience is not difficult to configure replication, the trick is to...
December 4, 2006 at 1:38 pm
You might not have Integration Services installed.
November 3, 2006 at 2:53 pm
I couldn't find a way to right click on a database, back it up and in the same time schedule that backup. It helped me a lot in 2k to schedule databases...
October 27, 2006 at 8:17 am
Looks okay to me. Should I look for something specific?
October 13, 2006 at 6:27 am
Just a regular server, no clustering involved, and no HD compression enabled.
Anyway it looks like an anomaly, a reinstall of the OS/SQL Server might fix it. I just wanted to know if...
October 12, 2006 at 9:14 am
I am positive, here is the output of msinfo
Drive C:
Description Local Fixed Disk
Compressed False
File System NTFS
Size 14.65 GB (15,726,702,592 bytes)
Free Space 1.35 GB (1,448,914,944 bytes)
Volume Name Local Disk
Volume Serial Number 88C94C44
Partition Disk #0, Partition #0
Partition Size 14.65 GB (15,726,703,104 bytes)
Starting...
October 11, 2006 at 2:05 pm
Viewing 15 posts - 31 through 45 (of 125 total)