Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.
Public Sub TotalPrivateDaysFromRtoA() Dim cnn As Object Dim CRecordset3 As Object ' Create a connection object Set cnn = CreateObject("ADODB.Connection") ' Connect to the database cnn.Provider = "SQLOLEDB" cnn.Open "Server=vaio;Database=Product;User Id=admin;Password=asd345po" If cnn.State <> 1 Then MsgBox "Could not connect to the database" Exit Sub End If ' Open recordset BeginNextRecordset Set CRecordset3 = CreateObject("ADODB.Recordset") CRecordset3.Open "EXEC sp_TotalPriceperMoth", cnn, adOpenDynamic, adLockPessimistic Sheets("Sheet1").[B4].CopyFromRecordset CRecordset3 cnn.Close Set cnn = Nothing End Sub
|Stored Proc - Rewrite||42||55|
|I need help with an EXCEL Nested formula.||5||20|
|RESTORE MASTER DATABASE -- NOW||2||14|
|use of sqlCmd command through exec master..xp_cmdshell||7||10|