Viewing 15 posts - 3,586 through 3,600 (of 9,244 total)
Igor Micev (2/8/2014)
The idea was to use versioning only for the session from which the SP was run.
In that case you need
Alter database mydb set read_committed_snapshot on
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 8, 2014 at 4:56 pm
ramana3327 (2/8/2014)
I have one more question what about the"" Listner". In some blogs they are saying listener is optional in...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 8, 2014 at 11:11 am
use the command line to enable it as follows
Dism /online /enable-feature /featurename:NetFx3 /All /Source:<drive>:\sources\sxs /LimitAccess
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 8, 2014 at 11:09 am
SQL!$@w$0ME (2/7/2014)
Does it mean we run SP installer from active node?
Yes
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 7, 2014 at 7:36 am
Something else has grabbed the single connection, an application srevice most likely. Do the following
-m"SQLCMD"start the sql instance in...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 7, 2014 at 7:05 am
sql_dba123 (2/7/2014)
But since SSRS 2008 and above don't require IIS, you may have to install IIS in the SSRS server
SSRS still uses the same drivers that IIS uses, HTTP.sys...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 7, 2014 at 5:59 am
DuncEduardo (2/7/2014)
Net Admin initially said that these methods can be resource-heavy and the preference is Tokenisation. However, having examined the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 7, 2014 at 5:25 am
Lowell (2/5/2014)
would you consider adding a CLR procedure that gets the data instead? that seems like a much better way to go.
That only gets the drive level info and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 7, 2014 at 3:51 am
a simple WMI query via WMIC can get this info and can be run via the agent
wmic volume get blocksize, capacity, "free space", name
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 7, 2014 at 3:31 am
halifaxdal (2/5/2014)
I tried to use it but the first thing is, off course, prompt me to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 7, 2014 at 3:24 am
halifaxdal (2/5/2014)
Maddave (2/5/2014)
The MSSQLSERVER in the service name shows it is a default instance, so you should just be able to put in the hostname of the server.
Unfortunately still not...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 7, 2014 at 3:22 am
DuncEduardo (1/30/2014)
so how would you ensure PCI Compliance by protecting the clear text information being passed to server from application?
Secure and encrypt channels between the client and server. IPSec, when...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 7, 2014 at 3:16 am
SQLisAwE5OmE (2/4/2014)
I have read that for sql 2005 you do the upgrade to the active node first and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 7, 2014 at 3:10 am
Read this[/url], it may help in the future
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 7, 2014 at 3:08 am
consult this article first
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 7, 2014 at 3:05 am
Viewing 15 posts - 3,586 through 3,600 (of 9,244 total)