Viewing 15 posts - 826 through 840 (of 859 total)
for ssd's the trim function clears the NAND cells of old data speeding up the read write process by not having "dirty" NAND memory. Windows 7 from what i...
March 16, 2012 at 12:02 am
Ideally every time a new update comes out. realistically we install updates at least once a month if they are needed.
As far as how to reboot the servers? ...
March 15, 2012 at 5:10 pm
PaulB-TheOneAndOnly (3/15/2012)
Koen Verbeeck (3/15/2012)
It seems there are 2 correct answers :w00t:Finally! I knew quantum mechanics would sooner or later apply to our trade 😀
but alas the entanglement does not...
March 15, 2012 at 8:51 am
I wonder why he would need the backup. Would not an SQL select statement to.csv or similar work better. Unless the ENTIRE database is needed for some reason?...
March 15, 2012 at 7:35 am
to add the insert you just need to change each block of code like the one below. Also i dont think you need the dynamic SQL as i believe...
March 14, 2012 at 11:22 pm
This should be what you are looking for. First one checks if the object exists in the sys.objects "Table" and then drops it if true, the second checks if...
March 14, 2012 at 4:11 pm
SQL Guy 1 (3/13/2012)
But can we restore a database in at least one connection is not closed ?
no Restore requires exclusive access to the database. with the canceling...
March 13, 2012 at 5:22 pm
lyang 88644 (3/13/2012)
March 13, 2012 at 3:57 pm
and I don't mind using sql injection with 29 stored proc.
with sql injection an attacker can execute arbitrary code including possibly dropping tables if the permissions are not set correctly....
March 13, 2012 at 2:48 pm
shank-130731 (3/13/2012)
<%
'REMOTE CONNECT STRING
Set MM_SQL31_STRING = Server.CreateObject("ADODB.Connection")
MM_SQL31_STRING.Provider = "SQLOLEDB"
MM_SQL31_STRING.Properties("Data Source").Value = "SQLB31.webcenter.com"
MM_SQL31_STRING.Properties("Network Library").Value = "dbmssocn"
MM_SQL31_STRING.Properties("Initial Catalog").Value = "ukk"
MM_SQL31_STRING.Properties("User ID").Value = "ukk_admin"
MM_SQL31_STRING.Properties("Password").Value = "ukk2000"
MM_SQL31_STRING.open
%>
Set connOrders = Server.CreateObject("ADODB.Connection")
connOrders.Open(MM_SQL31_STRING) '<-- LINE 111
I...
March 13, 2012 at 2:13 pm
ok i have an idea of how to attack this. it may have the potential for sql injection as we are going to pass a file name as a...
March 13, 2012 at 12:29 pm
after playing with it in SSMS and figuring out what most of the code did that was the only part i was wondering about. i joined up here to...
March 13, 2012 at 12:10 pm
Lynn Pettis (3/13/2012)
Here is a rewrite of the TVF as an inline TVF without a loop:
looking at your code the only thing i dont understand (after looking at it and...
March 13, 2012 at 11:57 am
Long story short, I don't really want to get up that early to VPN in and press F5 once.
That's one of the great things about being a DBA, long...
March 12, 2012 at 5:21 pm
MR@SD (3/12/2012)
To change the password try to use sp_password (see help for details on it).
not what the OP is looking for.
im guessing you have tried closing SSMS THEN moving or...
March 12, 2012 at 4:32 pm
Viewing 15 posts - 826 through 840 (of 859 total)