Viewing 15 posts - 2,896 through 2,910 (of 9,253 total)
thats what i said, check the user 😉
October 2, 2014 at 8:49 am
solomon.jernas (10/2/2014)
HIHow to apply patches in Sql server 2005 Active/passive cluster ,what are the steps need to be follow..
We will be initiate production server..
Please anyone help to us..
Regards,
solomon
Which patch(es)...
October 2, 2014 at 2:38 am
you dopn't set a default schema for a windows group, look at the default schema for the user
October 2, 2014 at 2:35 am
DudeGuy (9/30/2014)
The problem ISN'T NETWORK
using conventional mirroring, the...
October 2, 2014 at 2:34 am
sqlfriends (10/1/2014)
Just list of the above.For that, don't I need to create the users in the database?
Thanks,
Yes, but do the users in question need to create database users?
October 1, 2014 at 10:32 am
sqlfriends (9/30/2014)
There are 4 GIS people who knows SQL and often do queris and import/export tables, create tables/views/sprocs etc in the...
October 1, 2014 at 10:18 am
great, thanks for replying as this may help others in the future 😉
October 1, 2014 at 5:31 am
sej2008 (10/1/2014)
yes I have given administrator the permission to access my shared folder on primary server.
The administrator has nothing to do with it, when a service runs as local system...
October 1, 2014 at 5:15 am
Just the instance name is required not the full servername
/QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=Autotest
/SQLSYSADMINACCOUNTS='Domain\administrator' /SAPWD='Test@123'
September 30, 2014 at 8:44 am
sylvain.desmarais 74280 (9/30/2014)
September 30, 2014 at 8:41 am
With modern R10 controllers you actually get more for your buck. They are able to spread requests to multiple disks in the array to share the workload. This has a...
September 29, 2014 at 4:18 pm
The listener always connects to the primary replica and based on the user connecting dictates the view they will see
September 29, 2014 at 1:01 pm
DavidB 36561 (9/28/2014)
I had checked DBCC OPENTRAN (Distributed was 0 but very large number Non distributed) and then dm_exec_sessions first and there were no long running transactions and no-one...
September 29, 2014 at 12:59 pm
samalex (9/28/2014)
I've made similar restores without issue with just running sp_dropserver and sp_addserver to fix the server name
I would say you've been lucky up til now
September 28, 2014 at 10:18 am
sej2008 (9/27/2014)
I am doing log shipping on same machine between two instances using Localsystem account for sql agent service on windows server2008 R2
OK got this so far
sej2008 (9/27/2014)
September 28, 2014 at 5:12 am
Viewing 15 posts - 2,896 through 2,910 (of 9,253 total)