Tag: DATABASE
Storagegroup Mailbox Creation
by Installer on Mar.12, 2012, under Exchange 2007
This video provides a walk through on how to create a new storage group and a new mailbox database in Microsoft Exchange Server 2007 using the Exchange Management Console.
Exchange 2010 Add and Remove Mailbox Database
by Installer on Jun.01, 2011, under Exchange 2010
Learn how to add and remove an Exchange 2010 Mailbox Database. www.brickhouselabs.com
Exchange 2010 New Mailbox For Existing User
by Installer on May.27, 2011, under Exchange 2010
Learn how to create a new Exchange 2010 mailbox for an existing Active Directory user. www.brickhouselabs.com
Create New Exchange 2010 Mailbox and User Account
by Installer on Apr.18, 2011, under Exchange 2010
Learn how to create a new Exchange 2010 Mailbox and Active Directory User Account in this tutorial. www.brickhouselabs.com
Exchange 2010 Move Mailbox Database
by Installer on Apr.11, 2011, under Exchange 2010
Learn how to move a Mailbox Database (Information Store) within Exchange 2010 using the Exchange Management Console. www.brickhouselabs.com
Exchange 2010 Mount and Dismount Mailbox Database
by Installer on Apr.08, 2011, under Exchange 2010
Tutorial how to Mount and Dismount an Exchange 2010 Mailbox Store for offline maintenance. www.brickhouselabs.com
Creating Exchange 2010 Database availability group (DAG) – Part 1
by Installer on Apr.03, 2010, under Exchange 2010
This is part 1 in a series of tutorials entitled – Creating Exchange 2010 Database availability group (DAG) – The new high availability solution for Microsoft’s messaging platform.
Exchange 2010: High Availability and Disaster Recovery
by Installer on Apr.03, 2010, under Exchange 2010
Simpler-Webb talks about the new high availability and disaster recovery improvements in Exchange 2010.
MSSQL Search & Add Query Using Vbscript
by Installer on Feb.23, 2010, under MSSql Query
With This VBScript you can search into a field for Value and add it (if you want).
If you use the following script you Dont need to open ”SQL Server Managment Studio”.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 | Do Searchdata = InputBox("Please enter the Value", "Input") Loop Until Searchdata = "" cnstring = "Provider=SQLOLEDB.1;Password=PASSWORD;Persist Security Info=True;User ID=USERNAME;Initial Catalog=USERNAME;Data Source=192.168.2.2;" cmdtext = "SELECT * FROM DATABASE where FIELD_NAME = "& Searchdata &"" Set cn = CreateObject("adodb.connection") Set cmd = CreateObject("adodb.command") cn.connectionstring = cnstring cn.Open cmd.activeconnection = cn cmd.commandtext = cmdtext Set rs = CreateObject("adodb.recordset") rs.cursortype = 3 rs.locktype = 3 rs.Open(cmd) While Not rs.EOF And Not rs.BOF 'WScript.Echo rs.Fields.Item("FIELD_NAME").Value Data = rs.Fields.Item("FIELD_NAME").Value 'WScript.Echo Data rs.MoveNext Wend rs.Close cn.Close If Data = "" Then WScript.Echo "Ta Dedomena den Yparxoun sti Vasi" answer=MsgBox ("Do you want to Add the "& Data &" ", 36, "ADD THE VALUE ") If answer = 6 Then cnstring = "Provider=SQLOLEDB.1;Password=PASSWORD;Persist Security Info=True;User ID=USERNAME;Initial Catalog=USERNAME;Data Source=192.168.2.2;" cmdtext = "INSERT INTO DATABASE (FIELD_NAME) VALUES (" & Data & ")" Set cn = CreateObject("adodb.connection") Set cmd = CreateObject("adodb.command") cn.connectionstring = cnstring cn.Open cmd.activeconnection = cn cmd.commandtext = cmdtext cmd.Execute cn.Close WScript.Quit Else WScript.echo "NO" WScript.Quit End If Else WScript.Echo "Ta Dedomena Yparxoun Sti Vasi" End If |
