- 博客(8)
- 收藏
- 关注
原创 English 2
<br />I'll call you, either this morning or tomorrow morning.<br />you are either with us or you are not.<br />either the letter got lost or you did not write to me at all.<br /> <br />Meanwhile, my tongue was busy searching out the hole where the tooth h
2011-03-22 21:30:00 400
原创 How to check the service account under which the service running
<br />Created by: WMICodeCreator<br /> <br />c:/Myservice.vbs<br />------------------------------------------------------------------------------------------------<br />strComputer = "." <br />Set objWMIService = GetObject("winmgmts://" & strComputer & "/r
2010-11-23 11:50:00 432
原创 We are looking for an SQL Server DBA
<br />We are looking for an SQL Server DBA. If you are interesting about that. please email me.<br /> <br />Thanks!
2010-11-09 11:45:00 309
原创 Query drive space usage
Use these following codes to query the drive space usage:--save as c:/queryspaceusage.vbs Dim fso, d, dc, s, n Set fso = Wscript.CreateObject("Scripting.FileSystemObject") Set dc = fso.Drives For Each d in dc if d.DriveType = 2 then Wscr
2010-10-28 16:38:00 464
原创 How to refresh database parallelly on sql server
<br />Today. I've got a job to refresh database parallelly where possiable on multiple sql server.<br /> <br />I never did this job before. normally. we did this one by one(the one start must wait for the previous one completed) like use WHILE statements.
2010-08-04 17:41:00 495
原创 How to use ntrights.exe tool to assign user right in windows server env
Sometime, we might need to assign user right to lock page in memory in windows server env. like sql server services account.use this tool:ntrights.exe usage:-m machine to perform this operation on-u user -r revoke the right *** case sensitive+r gran
2010-07-14 15:53:00 722
原创 How to failover automatically in windows server 2008 failover cluster
<br />How to failover automatically in windows server 2k8 failover cluster env.<br /> <br />use the following command:<br /> <br />in 2 nodes env:<br />Cluster.exe /Cluster:clustername group "SQL Server (MSSQLSERVER)" /move<br /> <br />in more than 2 nodes
2010-07-14 15:29:00 367
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人