Viewing 15 posts - 3,796 through 3,810 (of 9,253 total)
sqlfriends (1/8/2014)
Thanks, I cannot find any information on line about Public role has connect permission to a database.Could you provide a link that tells public role has connect permission.
That's not...
January 8, 2014 at 12:02 pm
yes it will have connect permission, it will also default to the public database role for access
January 8, 2014 at 10:34 am
sqlfriends (1/7/2014)
Thanks, it adds it to each database, but didn't grant any permission,But I guess it defaults to connect permission, that is just what the vendor product needs
It will default...
January 8, 2014 at 5:15 am
thanks for posting back, this will certainly help others i'm sure
January 8, 2014 at 5:10 am
mbrady (1/7/2014)
The PRIMARY filegroup is set to Autogrow by 10 GB unrestricted on a drive with 770 GB free space remaining.
Do you have the local security policy "perform volume...
January 8, 2014 at 1:46 am
What is the file max size set to?
January 8, 2014 at 1:30 am
Have you read the articles I supplied??
January 8, 2014 at 12:32 am
kyle.hanson (1/7/2014)
The publisher and the distributor are not firewalled between each other and are currently working together when it comes to replication.
Ok but different instances on different servers?
Where are snapshots...
January 7, 2014 at 12:21 pm
Firstly, a couple of questions,
Are the servers all firewalled from each other?
Are the instances all default instances?
The snapshot files are delivered via means of an NTFS share. Accessing a...
January 7, 2014 at 4:18 am
Even more worrying, why are all the connections using system administrator??
January 7, 2014 at 2:24 am
JoshDBGuy (1/6/2014)
January 6, 2014 at 5:11 pm
Ginga (1/6/2014)
The in place upgrade went ahead this weekend just gone and it was a simple, albeit lengthy process. I decided to shut...
January 6, 2014 at 11:17 am
What command did you use to check the frags?
Can you post the before and after outputs?
January 6, 2014 at 1:04 am
VossSQL (1/3/2014)
I understand that SHRINK data/log files should be the last option due to all problems it generates. But how can I proceed on the following situation?
SQL Server 2008 R2....
January 4, 2014 at 3:33 pm
cherish.j.wang (1/3/2014)
I am confused recently weeks for SQL Server 2012 Alwayson AG HA could not failover automatically when SQL Service is running as built-in account.
according
From Microsoft SQL Server 2012 online...
January 4, 2014 at 11:24 am
Viewing 15 posts - 3,796 through 3,810 (of 9,253 total)