Viewing 15 posts - 3,901 through 3,915 (of 9,241 total)
muthukkumaran Kaliyamoorthy (11/7/2013)
I want to add/install 3rd SQL “instance3”....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 7, 2013 at 8:23 am
you can use a single one, it's probably easier to store the mapping files with the VM. I have done this in the past.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 7, 2013 at 8:19 am
If your procedure only accepts a scalar value why are you dumping the value provided to the sp into a cursor looping through sys.database_principals??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 7, 2013 at 8:13 am
A port in the high end range is usually good, say 50000 - 60000.
Where firewalls are in place and you wish to connect via the instance name you'll need the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 6, 2013 at 12:03 am
You must grant share permissions on the share itself and ntfs permissions on the folders\files. Where the 2 combine the most restrictive applies, this is the default when creating a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 5, 2013 at 12:14 am
yes i see what you mean, the following shows correctly the server role members but probably shouldnt be granted to ordinary users
grant VIEW ANY DEFINITION TO [youruser]
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 4, 2013 at 9:36 am
durai nagarajan (11/4/2013)
Thanks for you replyAre there no other alternative to this.
You could use a manual log backup instead of a differential and restore WITH NORECOVERY, MOVE.
The easiest option...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 4, 2013 at 5:06 am
assuming you havent disabled row or page locks on the index it would generally start with a row lock but as Gail said it depends on how much data is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 4, 2013 at 5:00 am
it's detailed in Books online and requires membership of the Public role
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 4, 2013 at 4:57 am
Krishna1 (11/4/2013)
Need to create 3 users, please guide what roles to selected for these users
1. User who can run DDL commands
2. User who can excute procedures/views/triggers, view/add/delete/modify data
3....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 4, 2013 at 4:47 am
query the file C:\windows\system32\drivers\etc\services and find a free port. perform a netstat -n to confirm that no other service on the machine is listening on that port.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 4, 2013 at 4:32 am
this is a common problem that is encountered with log shipping and mirroring when the servers are using disparate drives\paths.
Best way is to
run the LSCopy and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 3, 2013 at 11:41 am
Firstly, don't use administrative shares for file\folder access, create a new share at the appropriate folder level and ensure you set the following for the account the SQL Server agent...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 3, 2013 at 11:31 am
another user encountered this previously and the recommendation from Microsoft was the following (in order from highest to lowest priority)
Public
Private
iSCSI
Personally I have always used the following
Public
iSCSI
Private
The Public network is usually...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 3, 2013 at 11:28 am
the first item to tackle is why the network connection is lost. Also, the implementation of an extra network may help to maintain connectivity between sites.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 3, 2013 at 11:24 am
Viewing 15 posts - 3,901 through 3,915 (of 9,241 total)