Viewing 15 posts - 571 through 585 (of 611 total)
Typically that's too much at the low end (unless SQL's sharing with other apps) and too little at the higher end.
The one thing I don't like is the "Rule...
March 17, 2013 at 12:37 pm
I see your point.....
My thought was that if a user did not necessarily have sysadmin rights but still had rights to take a database offline, that the act of bringing...
March 17, 2013 at 9:07 am
I use SQL Server in varying editions across my network and use the Access Switchboard to allow simplified access for clients to the database. All each client requires is...
March 17, 2013 at 7:12 am
Logins created within the instance have by default no automatic access to any database within that instance. Each created user needs to be explicitly mapped to a database and...
March 17, 2013 at 7:05 am
If that was the case he wouldn't be able to take the database offline in the first place. He was quite clear that he could see the database (the...
March 17, 2013 at 6:29 am
If he is a member of the DDL-ADMIN fixed role he could take a database offline (as far as I am aware) and then bring it online.
He wouldn't...
March 17, 2013 at 6:25 am
@sqlcharger: Lopsided is a good way of putting it! It sounds very badly sized at the time of purchase!
Anyway, I use a practice of reserving 2GB...
March 17, 2013 at 6:20 am
This may be a silly statement, but your question suggests you aren't testing the migration before you put it into production. If that is the case then you could...
March 17, 2013 at 6:10 am
Oooooops! It would appear I am talking out of holes normally reserved for other purposes!
That is exactly the procedure I saw but I didn't read it properly!...
March 14, 2013 at 1:16 pm
You can enter the key during the installation. It is a part of the setup routine so you can't miss it! If you elect to install the evaluation...
March 14, 2013 at 8:48 am
I am not sure I understand exactly what you are asking.
If the mirror fails, the first thing I would do is break the mirror and check my backups to ensure...
March 14, 2013 at 8:34 am
Is it possible you had a drive failure in an array? I ask because some of the databases may have had no transaction log information on the failed drive,...
March 14, 2013 at 8:24 am
How do you know synchronisation is not happening? If in the SMSS the principal shows synchronised and the mirror shows restoring then it should be ok. What does...
March 14, 2013 at 8:15 am
What about using:
exec sp_MSforeachview 'select top 1 from ?'
March 14, 2013 at 8:11 am
Viewing 15 posts - 571 through 585 (of 611 total)