Viewing 15 posts - 7,741 through 7,755 (of 9,253 total)
Hawkeye_DBA (8/23/2010)
here's what I normally run: exec sp_change_users_login 'auto_fix', '<user name here>', NULLIs this incorrect????
that would only work when the login already exists on the server. To auto fix...
August 23, 2010 at 8:50 am
As i suspected you are using file share quorum.
To recap, these are the quorum models in Windows 2008 clustering
Node Majority—There's no file-share witness or disk witness and votes are...
August 22, 2010 at 3:19 pm
pshaship (8/21/2010)
I believe, QUORUM will be assigned when add the second node (correct me if we miss anything here)
no, no , no , no , no. The quorum is present...
August 22, 2010 at 12:07 pm
use the following syntax
GRANT <permission>, <permission>, ... ON OBJECT::dbo.mytable
TO [user1], [user2], [user3], ..........
August 22, 2010 at 12:03 pm
I'm a big fan of HP kit, in my experience it is far more reliable\superior to Dell.
August 21, 2010 at 4:34 am
Derrick Smith (8/20/2010)
when you try to auto_fix a db user that doesn't have a matching login created on the server. It's not a case of missing parameters as mentioned earlier.
When...
August 20, 2010 at 5:39 pm
Hmm, did you execute these queries under the context of your problem database?
The second query returns only the default database user accounts (as you would see in the master or...
August 20, 2010 at 10:37 am
you're welcome friend!
If you're on LinkedIn join my network and maybe recommend me if you can!
Regards
Perry
August 20, 2010 at 9:22 am
could you post the output of the following queries when run against your database
select distinct sp.name, sp.sid from sys.server_principals sp, sys.database_principals dp
where sp.type = 'S'
and not exists (select sid...
August 20, 2010 at 9:21 am
Using truncateonly will shrink the file to the last used extent
DBCC SHRINKFILE (LogicalFileName, truncateonly)
Specifying a size will shrink and re arrange the file to free potentially more space (2GB in...
August 20, 2010 at 8:51 am
personally i would use the same file size, or maybe just one slightly smaller about 2048 MB minimum. The local controller will not have the overhead of the storage network...
August 20, 2010 at 8:24 am
Hawkeye_DBA (8/20/2010)
try to run EXEC sp_change_users_login Auto_Fix, 'username'
that's because you have some parameters missing. if autofixing the database user account you need to supply a password and null for the...
August 20, 2010 at 8:20 am
After deploying a clustered SQL Server instance I always check my resource dependencies.
😎
August 20, 2010 at 7:03 am
Viewing 15 posts - 7,741 through 7,755 (of 9,253 total)