Shrink & Truncate Log File SQL 2005

Problem

Shrink log file cannot effectife resize truncate log file in sql, use to query step this type. With decrease log size them.

Solution
This Step can used in here :
1) Get Name for name in show result

USE <database>
exec sp_helpfile

2) Execution resize increasing log data size with query :

USE <database>
GO
BACKUP LOG <database> WITH TRUNCATE_ONLY
GO
DBCC SHRINKFILE ("name log", 1)
GO
DBCC SHRINKFILE ("name data", 1)
GO
exec sp_helpfile

3) See size capacity in log file.

Port Forward / NAT Remote Desktop with Modem Linksys Problem

Problem
If anytihing to do remote computer other site in office location. Example: can access office A in Jakarta city and Office B Medan City. We used Remote desktop connection (RDP). Setting allow RDP port in linksys.

Solution
1) Open modem setting, example : 172.16.10.6
2) select single port fordwarding. Select Application and gaming --> add application : RDP, External port : 3389, internal port: 3389, protocol : tcp/udp, ip address: 172.16.10.15
3)Save settings. See Picture

4) select port triggering and application : rdp , start port : 3388,  end port: 3389, protocol : tcp and udp, ip address : 172.16.10.15

5) Save settings. See Picture

Problem share printer 0X0000000d canon mp250

Problem
if you are connnect printer from other computer ms windows xp to ms windows vista or ms windows 7. example used printer canonmp250 and problem found with detail : operation failed with error 0X0000000d (see picture)

Solution
1) Install driver in computer printer location (Computer A), ip address : 172.16.10.16 and share this printer
2) Install driver in computer get share with (Computer B) and used port LPT1
    Get printer with share :
    Start --> Run --> cmd
    net use LPT1 \\172.16.10.16\canonmp2 /persistent:yes
3) Create Batch file and save startup menu start.

Connection C# and SQL Server 2005

Programming in C# .NET in ms visual studio net 2003 used SQL server 2005 connection :
1) Create database hwsw in sql server 2005 with table inventory and field is : idinventory, nameinventory, transaction inventory. etc
2) Create Form in C# net and drag datagrid in toolbox, with source code below:
             string connectionString = "Data Source=172.16.10.14;Initial Catalog=hwsw;Integrated   Security=False; User id=xxx;Password=xxxx";
            string sql = "SELECT * FROM inventory";
            SqlConnection connection = new SqlConnection(connectionString);
            connection.Open();           
            sCommand = new SqlCommand(sql, connection);
            sAdapter = new SqlDataAdapter(sCommand);
            sBuilder = new SqlCommandBuilder(sAdapter);
            sDs = new DataSet();
            sAdapter.Fill(sDs, "inventory");
            sTable = sDs.Tables["inventory"];
            connection.Close();
            dataGrid1.DataSource = sDs.Tables["inventory"];
            dataGrid1.ReadOnly = true;
            save_btn.Enabled = false;

Send email automatic with blat

Every day we can check connection server by email, and .log file server can be send my email automatically. See below command prompt we used basic. Step by step used blat send email :

1. Download program blat in http://www.blat.net
2. copy to drive c: in folder blat
3. Create script and save blat.bat
del c:\ReportServer\log_RPing\ping_%date:~7,2%%date:~4,2%%date:~10,10%.log
echo "---------------STATUS SERVER----------------" >> c:\ReportServer\log_RPing\ping_%date:~7,2%%date:~4,2%%date:~10,10%.log
ping -n 1 172.16.10.1 >nul &&(echo Router is ON>> c:\ReportServer\log_RPing\ping_%date:~7,2%%date:~4,2%%date:~10,10%.log )||( echo Router is -------OFF>> c:\ReportServer\log_RPing\ping_%date:~7,2%%date:~4,2%%date:~10,10%.log )
c:\ReportServer\blat.exe c:\ReportServer\log_RPing\ping_%date:~7,2%%date:~4,2%%date:~10,10%.log -t mnasrul@gmail.com -s "Report Daily Server Ping %date:~7,2%%date:~4,2%%date:~10,10%" -f h20026@ddssz.com -server mail.duduuuu.com

4. Create schedule in windows
5. See email send by blat report my server status :

--STATUS SERVER--: Router is ON & DB-SVR is ON

Virtual Box (virtual pc)

Virtual Box is a virtual machine for used pc installation, management, configuration, such as operating system windows xp, linux etc. with virtual box we can make problem and handling data error with customer presentation.
Using virtual any operating system to analyst and learning about information technology implementation program, after we make program coding for Axapta and implement for windows server or windows 7 and debug. For analyst viruses windows can implement to and change theme. See picture left them.

a great brother

a great brother!