Viewing 15 posts - 4,246 through 4,260 (of 9,253 total)
after granting the roles you would need to DENY delete not REVOKE
March 17, 2013 at 1:21 pm
What is it you are not clear on?
Do you understand the concept of public and private keys?
March 17, 2013 at 2:22 am
You cant view them, to understand what they are check books online for more info.
March 17, 2013 at 2:20 am
clintonG (3/16/2013)
Here is one solution perhaps the best I've learned so far:// Transact-SQL
REVOKE privilege_name
ON object_name
FROM {user_name |PUBLIC |role_name}
// Example
REVOKE DELETE
ON TransactionRecordsTable
FROM employee
REVOKE only clears the granted permission,...
March 16, 2013 at 1:31 pm
clintonG (3/14/2013)
March 16, 2013 at 12:40 pm
use either
computername\instancename
computername, portnumber
IPaddress\instancename
IPaddress, portnumber
March 16, 2013 at 8:04 am
GilaMonster (3/15/2013)
MyDoggieJessie (3/15/2013)
so there's no difference between 2 files of 140GB and 4 files of 70GB, it's still 280GB total space.
To add to the above, remember that when adding multiple...
March 16, 2013 at 8:01 am
The shared databases represent only the upper layer of the shared objects. At the base level, each cluster node that is part of the failover instance shares the virtual IP,...
March 16, 2013 at 7:57 am
SQLCrazyCertified (3/15/2013)
GilaMonster (3/15/2013)
Check log_reuse_wait_desc in sys.databases for why...
March 16, 2013 at 7:45 am
pradeep.mohan (3/15/2013)
I configured log shipping based on server host name in both production and DR server and its working fine. Now our company decided to change server IP's for both...
March 16, 2013 at 7:42 am
why do you feel the need to backup to multiple files, do you have multiple backup devices?
March 16, 2013 at 7:28 am
No problem, mine doesn't give object schema but that would be easy to obtain by joining to the sys.schemas catalog.
March 14, 2013 at 12:50 pm
I prefer mine below
SELECTOBJECT_NAME(i.object_id) AS TableName
, ISNULL(i.name, 'HEAP') AS IndexName
, i.index_id as IndexID
, i.type_desc AS IndexType
, p.partition_number AS PartitionNo
, p.rows AS NumRows
, au.type_desc AS InType
, au.total_pages AS NumPages
, au.total_pages *...
March 14, 2013 at 7:34 am
Is it a custom script, can you post details of what it does?
March 12, 2013 at 4:20 am
Aside what Kevin has said, what size are the 12 x SAS drives?
March 11, 2013 at 5:14 am
Viewing 15 posts - 4,246 through 4,260 (of 9,253 total)