Setup Outlook for Gmail
If you’re setting up Outlook 2003 to work with Gmail for the first time, you’ll need to: Check the below URL for detail or click here : http://mail.google.com/support/bin/answer.py?hl=en&answer=13278
» Read moreCheck The Temperature Of Your CPU
if your PC keeps crashing for no apparent reason, and if those crashes tend to occur when the machine is busy doing lots of things, there’s a pretty good chance that the problem is down to an overheating CPU. Maybe one of the fans in your system has stopped working,
» Read moreRead Data from Excel (VBÂ Code)
Private Sub cmd_browse_Click() On Error Resume Next Dim FNum As Integer Dim txt As Recordset On Error GoTo FileError CommonDialog1.CancelError = True CommonDialog1.Flags = cdlOFNFileMustExist CommonDialog1.DefaultExt = “xls” CommonDialog1.Filter = “Excel file|*.xls|*.*” CommonDialog1.ShowOpen FNum = FreeFile pathtxt.Text = CommonDialog1.FileName Close #FNum Dim cnExcel As New ADODB.Connection Dim rs As New
» Read moreAccess SQL Server Instance from the network
Whenever we create any SQL instance and after that if we want to access from our network. We need to setup some setting on Client Machine also! This is only point that people missed Now we need to install the Client Network Utility on Client Machine and following setting needs
» Read moreVB Code for Log or Tracking
Dim LFNum As Integer Dim PLFName As String ‘blnfileopen As Boolean Public Sub OpenFile() LFNum = FreeFile PLFName = App.Path & “proglog” & Format(Day(Date), “00”) & Format(Hour(Time), “00”) & Format(Minute(Time), “00”) & Format(Second(Time), “00”) & “.txt” Open PLFName For Output As LFNum Print #LFNum, “Logging Started at…..” & Date; “
» Read moreLinked Server
——————————————————— Create Linked Server through Scripts ——————————————————— USE [master] GO EXEC sp_addlinkedserver @server=’dsql2k’, @srvproduct=”, @provider=’SQLNCLI’, @datasrc=’source_name’ GO USE [master] GO EXEC master.dbo.sp_serveroption @server=N’dsql2k’, @optname=N’rpc’, @optvalue=N’true’ GO EXEC master.dbo.sp_serveroption @server=N’dsql2k’, @optname=N’rpc out’, @optvalue=N’true’ GO select * from master.dbo.sysservers ————————————————————————— Alternative Script to Create Linked Server and Mapping of Users ————————————————————————— Use
» Read moreSQL Backup Plan with Dynamic file Name
DECLARE @day VARCHAR(5) DECLARE @month VARCHAR(15) DECLARE @year VARCHAR(5) DECLARE @hour VARCHAR(5) DECLARE @filename VARCHAR(500) SET @day = DATENAME(DAY, GETDATE()) SET @month = DATENAME(MONTH, GETDATE()) SET @year = DATENAME(YEAR, GETDATE()) SET @hour = DATENAME(HOUR, GETDATE()) SET @filename = ‘D:DATABASE Backupdb_name_’ + @day + @month + @year + @hour + ‘.bak’
» Read moreMove SQL Server Databases Using Detach and Attach
–How to move SQL Server databases to a new location by using Detach and Attach functions in SQL Server –Prerequisites –Note You can determine the name and the current location of all files that a database uses by using the sp_helpfile stored procedure use go sp_helpfile go –Detach the database
» Read moreNews – Announcement for Blog
Dear/Respected All, I am pleased to announce that today i am going to start my blog http://varindersandhu.in The primary objective of my blog is to share my experience and notes with all technical persons. It would mean the world to me if you’d stop by my blog at some point.
» Read more