Home » Windows (Page 4)
Category Archives: Windows
How to get list of all available parameter of .EXE file ?
Today, We discuss How to get list of all available parameter of .EXE file OR How to find list of SQL Server setup parameters ? Major problem is of all available parameter details. Sometime, We need to pass parameter to .EXE file to get some different & superior functionality. We can get details of available … Continue reading
How to find/modify SQLServer Agent logfile location?
1. To get the location of SQLServer Agent log file, the log file is called SQLAGENT.out DECLARE @AGENT_ERRORLOG NVARCHAR(255) EXECUTE MASTER.DBO.XP_INSTANCE_REGREAD N’HKEY_LOCAL_MACHINE’, N’SOFTWAREMICROSOFTMSSQLSERVERSQLSERVERAGENT’, N’ERRORLOGFILE’, @AGENT_ERRORLOG OUTPUT, N’NO_OUTPUT’ SELECT @@SERVERNAME SERVERNAME, @AGENT_ERRORLOG AGENTERRORLOGLOCATION This command will work for both default & named instance. 2. To modify location and name of SQLServer Agent log file USE [MSDB] … Continue reading
How to move file through FTP by CMD ?
CMD code to upload file direct into root of FTP site of server @ echo off REM ******** this batch file is to upload file echo user username> ftpcmd.dat echo password>> ftpcmd.dat echo bin>> ftpcmd.dat echo lcd D:\Filelocation>>ftpcmd.dat echo put filename.csv>> ftpcmd.dat echo quit>> ftpcmd.dat ftp -n -s:ftpcmd.dat 172.xx.xx.xxx del ftpcmd.dat CMD code to upload … Continue reading
MSSQLFUN – Year 2012 Review
The WordPress.com stats helper monkeys prepared a 2012 annual report for this blog. Here’s an excerpt: 600 people reached the top of Mt. Everest in 2012. This blog got about 2,000 views in 2012. If every person who reached the top of Mt. Everest viewed this blog, it would have taken 3 years to get … Continue reading