http://www.sqlmag.com/authors/author/author/5777400/rsscomment/5777400en-USFri, 25 May 2012 08:35:24 GMTFri, 25 May 2012 08:35:24 GMThttp://www.sqlmag.com/article/passwords/resetting-lost-passwords#commentsAnchorTue, 31 Jan 2012 21:54:39 GMT
You can reset a lost or forgot Windows password with 4 methods below: 1. Another valid administrator account which can normally log on. 2. A password reset disk or a repair disc, which is created in advance ( before you lost password ). 3. Third-party software to create a bootable password reset CD/DVD or USB, like Windows Password Recovery Tool 3.0 . 4. Re-install. Will lose data.]]>CarllewwTue, 31 Jan 2012 21:54:39 GMThttp://www.sqlmag.com/article/passwords/resetting-lost-passwords#commentsAnchorhttp://www.sqlmag.com/article/passwords/resetting-lost-passwords#commentsAnchorTue, 31 Jan 2012 21:54:06 GMT
You can reset a lost or forgot Windows password with 4 methods below: 1. Another valid administrator account which can normally log on. 2. A password reset disk or a repair disc, which is created in advance ( before you lost password ). 3. Third-party software to create a bootable password reset CD/DVD or USB, like Windows Password Recovery Tool 3.0. 4. Re-install. Will lose data.]]>CarllewwTue, 31 Jan 2012 21:54:06 GMThttp://www.sqlmag.com/article/passwords/resetting-lost-passwords#commentsAnchorhttp://www.sqlmag.com/article/passwords/lost-passwords#commentsAnchorTue, 31 Jan 2012 21:51:08 GMT
Forgot Windows password?Lost admin password? Have been locked out of computer? Lost computer login passwords, which is a common problem for the computer users. So there are many solutions. One of the popular solutions is as following. 1.log on a computer that is linked to Internet. 2. Download Windows Password Recovery Tool 3.0 from http://www.windowspasswordsrecovery.com 3.Burn the downloaded .ISO file onto a blank CD 4.Insert newly created CD into the locked computer and then reboot it 5.select the account you wanna reset the password.]]>CarllewwTue, 31 Jan 2012 21:51:08 GMThttp://www.sqlmag.com/article/passwords/lost-passwords#commentsAnchorhttp://www.sqlmag.com/article/tsql3/row-concatenation-solutions-aren-t-all-equal#commentsAnchorMon, 02 Jan 2012 19:23:48 GMT
Before all of you give up on the "self referencing" variable, please see the following post over on SSC... http://www.sqlservercentral.com/Forums/FindPost1229018.aspx]]>JEFF MODENMon, 02 Jan 2012 19:23:48 GMThttp://www.sqlmag.com/article/tsql3/row-concatenation-solutions-aren-t-all-equal#commentsAnchorhttp://www.sqlmag.com/article/registry2/change-the-windows-logon-screen#commentsAnchorFri, 02 Dec 2011 01:57:34 GMT
very nicely written article.........!! i too have written a article on how to change startup screen - http://techinfoguru.com/change-startup-screen/]]>neilFri, 02 Dec 2011 01:57:34 GMThttp://www.sqlmag.com/article/registry2/change-the-windows-logon-screen#commentsAnchorhttp://www.sqlmag.com/article/html-application-hta/let-users-get-group-information-themselves#commentsAnchorTue, 29 Nov 2011 14:32:56 GMT
Hi All, I am not able to download the 50583.zip file. Could you please provide me the location where i can download this file. Thanks Venkatesh VR]]>venkateshvrTue, 29 Nov 2011 14:32:56 GMThttp://www.sqlmag.com/article/html-application-hta/let-users-get-group-information-themselves#commentsAnchorhttp://www.sqlmag.com/article/passwords/lost-passwords#commentsAnchorThu, 27 Oct 2011 23:45:54 GMT
If you lost your windows log on password, you can try these methods: Method 1: Log on as admin to reset the password. When installing Windows, it automatically creates an account Administrator and the default password is blank. If you have previously created a password reset disk, you can use it to reset the password also. http://support.microsoft.com/kb/321305 for more info. Method 2: You can try free software such as Ophcrack,Offline NT Password & Registry Editor,PC Login Now and Kon-Boot. More details here: http://pcsupport.about.com/od/toolsofthetrade/tp/passrecovery.htm Method 3: Use 3rd party password recovery tool (eg. Windows Password Rescuer and Windows password tools) to reset your windows password. See help page at http://www.daossoft.com/documents/how-to-reset-window-2000xp-vista-win7-password.html]]>syonxuThu, 27 Oct 2011 23:45:54 GMThttp://www.sqlmag.com/article/passwords/lost-passwords#commentsAnchorhttp://www.sqlmag.com/article/dns/change-dns-ip-address#commentsAnchorTue, 25 Oct 2011 22:01:01 GMT
Seems like an outdated method. Here is an easier way to do it using PsExec and Netsh: http://itswapshop.com/content/how-set-or-change-ip-addresses-gateways-subnet-masks-and-dns-servers-remotely-windows]]>RyanTue, 25 Oct 2011 22:01:01 GMThttp://www.sqlmag.com/article/dns/change-dns-ip-address#commentsAnchorhttp://www.sqlmag.com/article/remote-computing/psexec-to-the-rescue#commentsAnchorTue, 25 Oct 2011 10:36:54 GMT
I am using psexec on windows 7 to log into windows 2003 server. It is giving me the following error: Couldn't access x.x.x.x: Logon failure: unknow user name or bad password. Have read a few articles and tried what was suggested but I still have this problem. Just wondering if someone can help me with it. thanks]]>FaezehTue, 25 Oct 2011 10:36:54 GMThttp://www.sqlmag.com/article/remote-computing/psexec-to-the-rescue#commentsAnchorhttp://www.sqlmag.com/article/windows-2000/restore-missing-printers#commentsAnchorTue, 16 Aug 2011 17:00:27 GMT
I've been unable to have functionality since my printers disappeared in the folder. Your solution was a couple of simple steps and it worked exactly as you described... I appreciate your knowledge and taking time to post this solution. Thank you!]]>Dangerous DanTue, 16 Aug 2011 17:00:27 GMThttp://www.sqlmag.com/article/windows-2000/restore-missing-printers#commentsAnchorhttp://www.sqlmag.com/article/task-scheduling/tired-of-creating-mapi-profiles-try-richprofile#commentsAnchorTue, 16 Aug 2011 01:51:04 GMT
I use the latest version of RichProfile (v5) which is available from http://www.richprofile.com. It has support for Exchange Cached Mode, etc and works fine for our needs.]]>HetTue, 16 Aug 2011 01:51:04 GMThttp://www.sqlmag.com/article/task-scheduling/tired-of-creating-mapi-profiles-try-richprofile#commentsAnchorhttp://www.sqlmag.com/article/vbscript/scripts-for-monitoring-system-performance#commentsAnchorSat, 13 Aug 2011 03:55:53 GMT
the download link is broken. please check and let's know if there's a new link. you may also email the vbs scripts to vgarquero@yahoo.com thanks :)]]>Victor ArqueroSat, 13 Aug 2011 03:55:53 GMThttp://www.sqlmag.com/article/vbscript/scripts-for-monitoring-system-performance#commentsAnchorhttp://www.sqlmag.com/article/remote-computing/netmeeting39969#commentsAnchorSat, 16 Jul 2011 02:29:19 GMT
i have read the article.actually it is nice article.it is informative & interesting too.]]>camerron_bossSat, 16 Jul 2011 02:29:19 GMThttp://www.sqlmag.com/article/remote-computing/netmeeting39969#commentsAnchorhttp://www.sqlmag.com/article/tips/tools-for-troubleshooting-locked-out-accounts#commentsAnchorFri, 01 Apr 2011 09:36:59 GMT
I recommend downloading NetWrix Account Lockout Examiner for such account lockouts. Rather than relying on 3 different tools, the NetWrix tools resolves AD lockouts in one complete solution that alerts administrators of all lockouts in real time, investigates the root causes of the lockouts, such as, mapped network drives, for example, and allows end users to resolve these lockouts on their own via a web-based console. The NetWrix tool is the simple solution to a complex and common problem, allowing users to solve lockouts on their own without much, if any, intervention from the help desk.]]>MelenezFri, 01 Apr 2011 09:36:59 GMThttp://www.sqlmag.com/article/tips/tools-for-troubleshooting-locked-out-accounts#commentsAnchorhttp://www.sqlmag.com/article/tsql3/generating-a-list-of-standard-business-holidays#commentsAnchorWed, 12 Jan 2011 07:21:42 GMT
I wish I’d found this earlier! I’ve been struggling with this problem myself (and have implemented it much less efficiently).

However, I did find an algorithm for calculating Easter for a given year, which might help some folks:

http://www.usno.navy.mil/USNO/astronomical-applications/astronomical-information-center/date-easter

It’s not as elegant as your code for the other holidays-- you’d have to iterate through every year-- but at least it’s a programattic way to do it.]]>ParkerWed, 12 Jan 2011 07:21:42 GMThttp://www.sqlmag.com/article/tsql3/generating-a-list-of-standard-business-holidays#commentsAnchorhttp://www.sqlmag.com/article/installation2/how-to-stop-users-from-installing-google-chrome#commentsAnchorTue, 21 Dec 2010 19:23:20 GMT
Perhaps Google has updated their installation steps as I also followed the directions exactly and Google Chrome did install, however, the user was not able to launch Chrome.

I looked further into this and have found chrome_installer.exe is also being used during the install process...at least when starting the install from http://www.google.com/chrome.

So for XP I added another New Path Rule:

C:\Documents and Settings\%username%\Local Settings\Application Data\Google\Update\Download\*\chrome_installer.exe

Now after going through all the steps starting from http://www.google.com/chrome The Google Chrome Installer application displays the message ’The installer failed to start’ which accomplishes the mission for my XP systems.]]>RichTue, 21 Dec 2010 19:23:20 GMThttp://www.sqlmag.com/article/installation2/how-to-stop-users-from-installing-google-chrome#commentsAnchorhttp://www.sqlmag.com/article/encryption2/safeguard-the-data-on-usb-storage-devices-without-spending-a-dime#commentsAnchorFri, 01 Oct 2010 18:49:11 GMT
Excellent article. Now I have secured my personal USB drive. Keep up the good work Asif!]]>Viktor ZhukovFri, 01 Oct 2010 18:49:11 GMThttp://www.sqlmag.com/article/encryption2/safeguard-the-data-on-usb-storage-devices-without-spending-a-dime#commentsAnchorhttp://www.sqlmag.com/article/tips/prevent-multiple-logons-with-gpos#commentsAnchorThu, 23 Sep 2010 02:09:49 GMT
Logon scripts-based solutions like the one described in this article present too many drawbacks and weaknesses to suit large IT infrastructures’ security requirements:
 
- if a workstation is not connected to the network, scripts cannot run and sessions history is therefore lost
- a logon script runs as a user, and an ill-disposed user can therefore kill the script
- if an untimely reboot occurs, sessions are not suppressed from the database
- ...

More, there’s an app for that: UserLock (http://www.UserLock.com).]]>JM2CThu, 23 Sep 2010 02:09:49 GMThttp://www.sqlmag.com/article/tips/prevent-multiple-logons-with-gpos#commentsAnchorhttp://www.sqlmag.com/article/vbscript/export-ad-data-into-access-so-users-can-run-their-own-ad-reports#commentsAnchorMon, 05 Jul 2010 01:35:22 GMT
This script is great, however has anyone had problems with only getting 1000 results? ]]>ChadMon, 05 Jul 2010 01:35:22 GMThttp://www.sqlmag.com/article/vbscript/export-ad-data-into-access-so-users-can-run-their-own-ad-reports#commentsAnchorhttp://www.sqlmag.com/article/registry2/resetting-administrator-password-to-recover-lost-offline-files-doesn-t-work#commentsAnchorWed, 19 May 2010 22:53:55 GMT
Emm.. you may remember the wrong password or someone hack your computer and change the password.
Whatever it is, you need to get access to you windows 7 now. You can make a Windows password reset disk to reset your password:

1. Login to a computer that can link to Internet. Download windows Password recovery and install it on that PC. Note that: there is a .ISO file. Burn the .ISO file to a CD or a USB flash drive.

2. Get out the newly created CD/USB and insert it to the locked computer.

3. re-booted the locked computer (it’s necessary for you to change your computer’s Setup to make it boot from CD drive or USB drive) and then followed the process of instructions. Just a few steps, the old password was removed.

4. Setting new password.

won’t do any harm to your data, only remove windows password

So, is it easy? Luck!

Related Tutorial: Cant Remember Windows 7 Password ? http://www.windows7password.net/lostforgot-windows-7-password/]]>AlexWed, 19 May 2010 22:53:55 GMThttp://www.sqlmag.com/article/registry2/resetting-administrator-password-to-recover-lost-offline-files-doesn-t-work#commentsAnchorhttp://www.sqlmag.com/article/registry2/resetting-administrator-password-to-recover-lost-offline-files-doesn-t-work#commentsAnchorThu, 13 May 2010 01:49:48 GMT
I usually used the cheapest and easy to use tools, especialy free trial: like Windows Password Recovery tool 3.0 to reset Windows XP password.
Or you can try hacker. O(_)O ~
http://www.windowspasswordsrecovery.com]]>AlexThu, 13 May 2010 01:49:48 GMThttp://www.sqlmag.com/article/registry2/resetting-administrator-password-to-recover-lost-offline-files-doesn-t-work#commentsAnchorhttp://www.sqlmag.com/article/permissions/unlock-user-accounts#commentsAnchorTue, 06 Apr 2010 08:03:07 GMT
Alternatey just use this app to unlock accounts. no nonsense app. http://www.nicetool.net/nicetool/adunlockusers.html]]>RonniTue, 06 Apr 2010 08:03:07 GMThttp://www.sqlmag.com/article/permissions/unlock-user-accounts#commentsAnchorhttp://www.sqlmag.com/article/log-files/delete-files-by-age#commentsAnchorSun, 14 Mar 2010 18:25:37 GMT
This script is no good for general housekeeping, as it assumes that only one file is created each day. It will be OK for anyone who is doing the exact same thing as the author, and deleting log files that are generated daily, but it will not serve anyone looking for a way to clean up zillions of folders on any given drive.


]]>hutchinsonSun, 14 Mar 2010 18:25:37 GMThttp://www.sqlmag.com/article/log-files/delete-files-by-age#commentsAnchorhttp://www.sqlmag.com/article/registry2/resetting-administrator-password-to-recover-lost-offline-files-doesn-t-work#commentsAnchorFri, 29 Jan 2010 01:47:26 GMT
Or free windows password reset methods: http://blog.resetwindowspassword.com/how-to-recover-and-reset-password-in-vistaxp20032knt-for-free/]]>LinkyFri, 29 Jan 2010 01:47:26 GMThttp://www.sqlmag.com/article/registry2/resetting-administrator-password-to-recover-lost-offline-files-doesn-t-work#commentsAnchorhttp://www.sqlmag.com/article/tips/prevent-multiple-logons-with-gpos#commentsAnchorMon, 25 Jan 2010 02:18:46 GMT
I just read this article and i will try this and leave my comment future if need more changes in logout.bat file.]]>ZubairMon, 25 Jan 2010 02:18:46 GMThttp://www.sqlmag.com/article/tips/prevent-multiple-logons-with-gpos#commentsAnchorhttp://www.sqlmag.com/article/remote-computing/command-prompt-tricks#commentsAnchorTue, 29 Dec 2009 17:09:54 GMT
hi, i want to learn how to change someone desktop wallpaper with mine one]]>sonulohat Tue, 29 Dec 2009 17:09:54 GMThttp://www.sqlmag.com/article/remote-computing/command-prompt-tricks#commentsAnchorhttp://www.sqlmag.com/article/html-application-hta/let-users-get-group-information-themselves#commentsAnchorWed, 23 Dec 2009 12:21:00 GMT
It doesn’t allow me to work only for specific OU]]>GebremeskelWed, 23 Dec 2009 12:21:00 GMThttp://www.sqlmag.com/article/html-application-hta/let-users-get-group-information-themselves#commentsAnchorhttp://www.sqlmag.com/article/installation2/how-to-stop-users-from-installing-google-chrome#commentsAnchorThu, 10 Dec 2009 14:32:51 GMT
I followed your directions exactly. Google Chrome still unstalled (XP SP3) Server 2008 GPO But the user was not able to run Google Chrome]]>FrankThu, 10 Dec 2009 14:32:51 GMThttp://www.sqlmag.com/article/installation2/how-to-stop-users-from-installing-google-chrome#commentsAnchorhttp://www.sqlmag.com/article/tsql3/use-t-sql-to-back-up-and-restore-sql-server-user-databases#commentsAnchorWed, 18 Nov 2009 09:42:40 GMT
Hi taersious! I passed your question on to the article’s author, Eli Leiba, who said "No, the restore will fail since its on the same server and therefore the 2000 and 2005 files reside on different locations. The procedure works for 2000 or 2005 servers that have the same directory structures and instance names and reside on different servers. You’ll have to use with move clause, use only backup proc, and then restore dbs one by one with restore TSQL statement. Eli" Please feel free to contact me directly if you have any more questions or feedback. Thanks for reading SQL Server Magazine! Megan Keller Associate Editor, SQL Server Magazine mkeller@sqlmag.com]]>MeganWed, 18 Nov 2009 09:42:40 GMThttp://www.sqlmag.com/article/tsql3/use-t-sql-to-back-up-and-restore-sql-server-user-databases#commentsAnchorhttp://www.sqlmag.com/article/tsql3/use-t-sql-to-back-up-and-restore-sql-server-user-databases#commentsAnchorThu, 12 Nov 2009 09:13:42 GMT
Before I try to use your proc, I need to know more about the inner workings. Can you use this script to take a db backup from an instance of SQL 2000 and restore to an instance of SQL 2005 on the same server? If so, would this render the original (live) database on SQL 2000 unusable? I am looking for a way without detaching the live database to bring a copy online for test in SQL 2005.]]>DrewThu, 12 Nov 2009 09:13:42 GMThttp://www.sqlmag.com/article/tsql3/use-t-sql-to-back-up-and-restore-sql-server-user-databases#commentsAnchorhttp://www.sqlmag.com/article/events-and-monitoring/mimic-vista-s-event-triggers-in-xp#commentsAnchorFri, 30 Oct 2009 10:12:40 GMT
Hi Windows IT Pro, I just had an opportunity to test email.vbs: The default email program *does not* have to be running for the email to go out immediately. Regards, Bret]]>BretFri, 30 Oct 2009 10:12:40 GMThttp://www.sqlmag.com/article/events-and-monitoring/mimic-vista-s-event-triggers-in-xp#commentsAnchorhttp://www.sqlmag.com/article/vbscript/avoid-ugly-computer-inventory-reports-save-your-script-s-output-in-microsoft-word#commentsAnchorWed, 16 Sep 2009 10:25:32 GMT
The code creates two word objects. On closing the document, a second winword.exe process continues to run invisibly. Comment out the second occurrence of "Set objWord = CreateObject("Word.Application")".]]>RichardWed, 16 Sep 2009 10:25:32 GMThttp://www.sqlmag.com/article/vbscript/avoid-ugly-computer-inventory-reports-save-your-script-s-output-in-microsoft-word#commentsAnchorhttp://www.sqlmag.com/article/vbscript/avoid-ugly-computer-inventory-reports-save-your-script-s-output-in-microsoft-word#commentsAnchorWed, 16 Sep 2009 07:04:42 GMT
The error can be resolved by editing the script and changing "your_directory" to be the directory where you have the saved the logo file. (It would be convenient if this defaulted to the same directory where the script file is stored.)]]>robWed, 16 Sep 2009 07:04:42 GMThttp://www.sqlmag.com/article/vbscript/avoid-ugly-computer-inventory-reports-save-your-script-s-output-in-microsoft-word#commentsAnchorhttp://www.sqlmag.com/article/windows-xp2/shortcut-to-lock-windows-xp-workstation#commentsAnchorWed, 26 Aug 2009 08:36:42 GMT
Unfortunately, as Tory Gilbert mentioned above, this shortcut doesn’t work with the Home Edition of Windows XP. It works only on Windows XP Pro computers that are connected to a domain. Thanks for reading Windows IT Pro! Karen Bemowski, senior editor, Windows IT Pro/SQL Server Magazine]]>KarenWed, 26 Aug 2009 08:36:42 GMThttp://www.sqlmag.com/article/windows-xp2/shortcut-to-lock-windows-xp-workstation#commentsAnchorhttp://www.sqlmag.com/article/windows-xp2/shortcut-to-lock-windows-xp-workstation#commentsAnchorTue, 25 Aug 2009 20:14:52 GMT
I have windows XP home sp3, but the shortcut you guys are talking about will work only to bring up the logoff option, and that is obviously not the same as the computer lock. I dont seem to find that option anywhere, but enabling the password request after screen saver, i get the unlock computer box.]]>dageneral Tue, 25 Aug 2009 20:14:52 GMThttp://www.sqlmag.com/article/windows-xp2/shortcut-to-lock-windows-xp-workstation#commentsAnchorhttp://www.sqlmag.com/article/microsoft-management-console-mmc/remote-restart#commentsAnchorWed, 19 Aug 2009 09:09:09 GMT
We use this option all the time in Windows 2003. Is there a comparable option in Windows 2008 SP2 with MMC 3.0?]]>BrandonWed, 19 Aug 2009 09:09:09 GMThttp://www.sqlmag.com/article/microsoft-management-console-mmc/remote-restart#commentsAnchorhttp://www.sqlmag.com/article/tsql3/find-and-replace-keywords-in-stored-procedures#commentsAnchorMon, 29 Jun 2009 16:34:17 GMT
Thank you, found it useful. Added ’and charindex(@myfind,definition) > 0’ to the where clause of the cursor, in order to select only those procedures that actually contain the text to find.]]>AlexMon, 29 Jun 2009 16:34:17 GMThttp://www.sqlmag.com/article/tsql3/find-and-replace-keywords-in-stored-procedures#commentsAnchorhttp://www.sqlmag.com/article/task-scheduling/copy-group-memberships-the-easy-way#commentsAnchorSun, 31 May 2009 12:12:36 GMT
I’m having trouble using this when there are spaces in the SAMaccount Name of the group. Can anyone please help!!!]]>masssimo Sun, 31 May 2009 12:12:36 GMThttp://www.sqlmag.com/article/task-scheduling/copy-group-memberships-the-easy-way#commentsAnchorhttp://www.sqlmag.com/article/tsql3/find-and-replace-keywords-in-stored-procedures#commentsAnchorWed, 06 May 2009 16:51:41 GMT
Actually, I have three questions: 1. MSysObjects was in ACCESS 2007: SELECT [Name] FROM MSysObjects WHERE [Type]={1, 5, -32768, -32764, -32766, -32761} And Left([Name],1)<>"~" ORDER BY [Name]; {Table, Query, Form, Report, Macro, Module} only select one for [Type] 2. Why are semicolons avoided in SQL 2008? 3. Business Contact Manager for Outlok 2007 REQUIRES SQL 2005. Is here a way to use SQL 2008 to set up ts database? Thank you.]]>BenWed, 06 May 2009 16:51:41 GMThttp://www.sqlmag.com/article/tsql3/find-and-replace-keywords-in-stored-procedures#commentsAnchorhttp://www.sqlmag.com/article/registry2/automatically-moving-users-to-a-new-print-server#commentsAnchorWed, 22 Apr 2009 00:55:59 GMT
yes i can see the code but i dont understend were i put my old/new server config old server mccprn new server mccpro and my code is if not exist %SystemRoot%\system32\prnmgr.vbs copy \\servername\prnmgr.vbs %SystemRoot%\system32 if not exist %SystemRoot%\system32\con2prt.exe copy \\servername\con2prt.exe %SystemRoot%\system32 if not exist %SystemRoot%\system32\prnadmin.dll copy \\servername\prnadmin.dll %SystemRoot%\system32 if exist %temp%\printers.txt del %temp%\printers.txt if exist %temp%\parseprint.txt del %temp%\parseprint.txt if exist %temp%\printout.txt del %temp%\printout.txt REM *Makes sure that prnmgr.vbs, prnadmin.dll, and con2prt.exe exist on the workstation* %systemroot%\system32\regsvr32.exe /s %systemroot%\system32\prnadmin.dll >nul REM *Registers prnadmin.dll* CScript //H:CScript //S 1>nul 2>nul REM *Sets Cscript as the default script language for the local PC’s OS and sends output to a file* prnmgr -l >%temp%\printers.txt REM *Prints a list of attached network printers to a text file* find "PrinterName" %temp%\printers.txt >%temp%\printout.txt REM *Finds the line PrinterName and sends to a new text file* FOR /F "tokens=2,2 delims=: " %%i in (%temp%\printout.txt) do @echo %%i>>%TEMP%\parseprint.txt REM *Parses and leaves only the UNC name of network printer to a text file* FOR /F %%i in (%TEMP%\parseprint.txt) do if "%%i"=="\\printserver\X001" prnmgr -dc "\\printserver\X001" && con2prt /cd "\\newservr\hplaserj"]]>EranWed, 22 Apr 2009 00:55:59 GMThttp://www.sqlmag.com/article/registry2/automatically-moving-users-to-a-new-print-server#commentsAnchorhttp://www.sqlmag.com/article/registry2/automatically-moving-users-to-a-new-print-server#commentsAnchorTue, 21 Apr 2009 13:03:48 GMT
You can obtain the script by clicking the "Download the Code Here" button at the top of the page. Thanks for reading Windows IT Pro! Karen Bemowski, senior editor, Windows IT Pro]]>KarenTue, 21 Apr 2009 13:03:48 GMThttp://www.sqlmag.com/article/registry2/automatically-moving-users-to-a-new-print-server#commentsAnchorhttp://www.sqlmag.com/article/registry2/automatically-moving-users-to-a-new-print-server#commentsAnchorTue, 21 Apr 2009 02:25:03 GMT
can some one send me acopy of you script i dont understend were i put my old/new server config thx]]>EranTue, 21 Apr 2009 02:25:03 GMThttp://www.sqlmag.com/article/registry2/automatically-moving-users-to-a-new-print-server#commentsAnchorhttp://www.sqlmag.com/article/tsql3/find-out-what-s-going-on-inside-your-partitions#commentsAnchorThu, 09 Apr 2009 18:45:33 GMT
Nice Report]]>FarhadThu, 09 Apr 2009 18:45:33 GMThttp://www.sqlmag.com/article/tsql3/find-out-what-s-going-on-inside-your-partitions#commentsAnchorhttp://www.sqlmag.com/article/remote-computing/command-prompt-tricks#commentsAnchorWed, 04 Feb 2009 12:18:49 GMT
Lrure i would like to know how to make my PC on my school server a "ghost" as u said in one of your posts can u give me detailed instructions]]>mikeWed, 04 Feb 2009 12:18:49 GMThttp://www.sqlmag.com/article/remote-computing/command-prompt-tricks#commentsAnchorhttp://www.sqlmag.com/article/task-scheduling/copy-group-membership-from-user-to-user#commentsAnchorTue, 27 Jan 2009 11:14:55 GMT
The code might not be working for you because the code in Listing 1 was wrapped to multiple lines. Unlike most Windows shell scripting commands, wrapping For commands can cause them to fail, especially when you’re using the /F switch to parse a file’s contents. I hunted down the original CopyUsersGroups.bat script, in which no lines are wrapped. I placed this script in the 94471.zip file. In addition, I placed the original sample .ini file (utils.ini) that you can adapt and use. You can obtain CopyUsersGroups.bat and utils.ini by clicking the "Download the Code Here" button at the top of the page. If you find that the original CopyUsersGroups.bat script doesn’t work for you, check to see if your .ini file’s path (i.e., the path you set to the cfgfile variable in the script) includes spaces. One limitation of using the For command to parse files is that spaces in a file’s path will cause the For command to fail. If your .ini file’s path includes spaces, see the article "Two Tricks for Your Scripting Toolbelt" (enter 38418 in the InstantDoc ID box or go to http://windowsitpro.com/article/articleid/38418/38418.html) for information on how to handle those spaces. (The typical technique of enclosing the file path in double quotes doesn’t work in this situation.) "Two Tricks for Your Scripting Toolbelt" was originally accessible only to VIP members, but I now opened this article up for public viewing in case you need to read it. If you’re still having problems with the script after trying the original script and handling any spaces, please let me know. Karen Bemowski, senior editor, Windows IT Pro and SQL Server Magazine]]>KarenTue, 27 Jan 2009 11:14:55 GMThttp://www.sqlmag.com/article/task-scheduling/copy-group-membership-from-user-to-user#commentsAnchorhttp://www.sqlmag.com/article/task-scheduling/copy-group-membership-from-user-to-user#commentsAnchorMon, 26 Jan 2009 12:49:36 GMT
Has anyone gotten the copyusersgroups.bat to work?]]>bbeers Mon, 26 Jan 2009 12:49:36 GMThttp://www.sqlmag.com/article/task-scheduling/copy-group-membership-from-user-to-user#commentsAnchorhttp://www.sqlmag.com/article/vbscript/script-inventories-remote-computers-and-writes-the-information-to-a-database#commentsAnchorWed, 21 Jan 2009 08:50:22 GMT
You can download Computer_Inventory.vbs by clicking the "Download the Code Here" button, which is right under the Executive Summary at the top of the page. In case you’re not a VIP subscriber, I opened up the article for public viewing. I hope you find the script helpful! Karen Bemowski, senior editor Windows IT Pro, SQL Server Magazine]]>KarenWed, 21 Jan 2009 08:50:22 GMThttp://www.sqlmag.com/article/vbscript/script-inventories-remote-computers-and-writes-the-information-to-a-database#commentsAnchorhttp://www.sqlmag.com/article/vbscript/script-inventories-remote-computers-and-writes-the-information-to-a-database#commentsAnchorFri, 16 Jan 2009 23:50:10 GMT
Can i get Computer_Inventory.vbs romeshb@hotmail.com]]>RomeshFri, 16 Jan 2009 23:50:10 GMThttp://www.sqlmag.com/article/vbscript/script-inventories-remote-computers-and-writes-the-information-to-a-database#commentsAnchorhttp://www.sqlmag.com/article/pst-files/outlook-archive-splitting#commentsAnchorFri, 16 Jan 2009 01:28:56 GMT
You can split the PST file with PST Splitting software. Download the Application from here. http://www.repairpst.info/qd.php?questionid=13&pg=splitting_oversized_pst_file_software]]>PiyushFri, 16 Jan 2009 01:28:56 GMThttp://www.sqlmag.com/article/pst-files/outlook-archive-splitting#commentsAnchorhttp://www.sqlmag.com/article/vbscript/avoid-ugly-computer-inventory-reports-save-your-script-s-output-in-microsoft-word#commentsAnchorFri, 19 Dec 2008 16:46:56 GMT
I emailed Mauro Magni about your experience with AutoInventory.vbs. Hopefully he’ll know what the problem is and how to solve it. Thanks for reading Windows IT Pro. Karen Bemowski, senior editor Windows IT Pro, SQL Server Magazine]]>KarenFri, 19 Dec 2008 16:46:56 GMThttp://www.sqlmag.com/article/vbscript/avoid-ugly-computer-inventory-reports-save-your-script-s-output-in-microsoft-word#commentsAnchorhttp://www.sqlmag.com/article/vbscript/avoid-ugly-computer-inventory-reports-save-your-script-s-output-in-microsoft-word#commentsAnchorFri, 19 Dec 2008 11:14:34 GMT
I’m getting an error and no report data. The error is (just after "I’m building the document": c:\inventory\inventoryreport.vbs(297,1) Microsoft Word: This is not a valid file name. Any ideas why it’s trying to name the report inventoryreport.vbs? Cheers, Gary]]>GaryFri, 19 Dec 2008 11:14:34 GMThttp://www.sqlmag.com/article/vbscript/avoid-ugly-computer-inventory-reports-save-your-script-s-output-in-microsoft-word#commentsAnchorhttp://www.sqlmag.com/article/windows-shell-bat-and-cmd/automate-the-windows-2003-defragmenter-without-paying-extra#commentsAnchorTue, 16 Dec 2008 21:34:26 GMT
All the very best to everyone for christmas and a good start to the new year.]]>leoTue, 16 Dec 2008 21:34:26 GMThttp://www.sqlmag.com/article/windows-shell-bat-and-cmd/automate-the-windows-2003-defragmenter-without-paying-extra#commentsAnchorhttp://www.sqlmag.com/article/vbscript/avoid-ugly-computer-inventory-reports-save-your-script-s-output-in-microsoft-word#commentsAnchorTue, 28 Oct 2008 12:59:41 GMT
Brilliant!]]>AshleighTue, 28 Oct 2008 12:59:41 GMThttp://www.sqlmag.com/article/vbscript/avoid-ugly-computer-inventory-reports-save-your-script-s-output-in-microsoft-word#commentsAnchorhttp://www.sqlmag.com/article/events-and-monitoring/mimic-vista-s-event-triggers-in-xp#commentsAnchorFri, 24 Oct 2008 08:02:20 GMT
Hi Jian, Good tool. Thanks :-) Question: Without my testing, does anyone know if the default email program has to be running for the email to go out immediately? Or, is the message stored in the Outbox until the next time the email program runs and does a send/receive ? Thanks, Bret]]>BretFri, 24 Oct 2008 08:02:20 GMThttp://www.sqlmag.com/article/events-and-monitoring/mimic-vista-s-event-triggers-in-xp#commentsAnchorhttp://www.sqlmag.com/article/events-and-monitoring/mimic-vista-s-event-triggers-in-xp#commentsAnchorTue, 21 Oct 2008 13:14:00 GMT
Would Eventtriggers monitor any log file instead of just the Windows Event logs?]]>FungpiewTue, 21 Oct 2008 13:14:00 GMThttp://www.sqlmag.com/article/events-and-monitoring/mimic-vista-s-event-triggers-in-xp#commentsAnchorhttp://www.sqlmag.com/article/remote-computing/command-prompt-tricks#commentsAnchorThu, 09 Oct 2008 05:20:48 GMT
in reply to Hundredsouls, what’s wrong trying to impress your friends? Adults impress their friends, neighbours, colleagues also by grooming and big cars, talk posh although it’s sh^tty, so dont give us any of those grow up cliche, an old fa^t aint of no use no no one, leave us alone and if you are of no help, no one loses.]]>RhinoThu, 09 Oct 2008 05:20:48 GMThttp://www.sqlmag.com/article/remote-computing/command-prompt-tricks#commentsAnchorhttp://www.sqlmag.com/article/remote-computing/psexec-to-the-rescue#commentsAnchorWed, 08 Oct 2008 11:30:14 GMT
Great. I have many more examples of the amazing and talented psexec at work. I should document them some time.]]>netmarcos,netmarcos Wed, 08 Oct 2008 11:30:14 GMThttp://www.sqlmag.com/article/remote-computing/psexec-to-the-rescue#commentsAnchorhttp://www.sqlmag.com/article/events-and-monitoring/mimic-vista-s-event-triggers-in-xp#commentsAnchorWed, 08 Oct 2008 09:42:18 GMT
Hi Brian, I contacted Jian Bo about the error you’re encountering. He recommends that you try the following code instead: sch = "http://schemas.microsoft.com/cdo/configuration/" Set cdoConfig = CreateObject("CDO.Configuration") With cdoConfig.Fields .Item(sch & "sendusing") = 2 ’ cdoSendUsingPort .Item(sch & "smtpserver") = "" .update End With Set cdoMessage = CreateObject("CDO.Message") With cdoMessage Set .Configuration = cdoConfig .From = "from@me.com" .To = "to@me.com" .Subject = "Sample CDO Message" .TextBody = "This is a test for CDO.message" .Send End With Set cdoMessage = Nothing Set cdoConfig = Nothing In this code, you’ll need to replace with your mail server. Please let me know if this works for you. Thanks, Karen Bemowski, senior editor Windows IT Pro, SQL Server Magazine]]>KarenWed, 08 Oct 2008 09:42:18 GMThttp://www.sqlmag.com/article/events-and-monitoring/mimic-vista-s-event-triggers-in-xp#commentsAnchorhttp://www.sqlmag.com/article/remote-computing/psexec-to-the-rescue#commentsAnchorTue, 07 Oct 2008 12:19:03 GMT
psexec is a valuable tool but for the above tasks it is not necessary. builtin tools, such as tskill.exe and logoff.exe both supports remote logoff. Murat Yildirimoglu]]>MuratTue, 07 Oct 2008 12:19:03 GMThttp://www.sqlmag.com/article/remote-computing/psexec-to-the-rescue#commentsAnchorhttp://www.sqlmag.com/article/events-and-monitoring/mimic-vista-s-event-triggers-in-xp#commentsAnchorTue, 07 Oct 2008 11:05:59 GMT
Thanks for the article. I get the following error when I run the email.vbs script. Can someone recommend a fix? Thanks, Brian CDO.Message.1 error ’80040220’ The "SendUsing" configuration value is invalid.]]>BrianTue, 07 Oct 2008 11:05:59 GMThttp://www.sqlmag.com/article/events-and-monitoring/mimic-vista-s-event-triggers-in-xp#commentsAnchorhttp://www.sqlmag.com/article/remote-computing/psexec-to-the-rescue#commentsAnchorSat, 04 Oct 2008 11:13:54 GMT
Great article Tim. Thanks for sharing this gem. Congrats on the first of many I’m sure.]]>MikeSat, 04 Oct 2008 11:13:54 GMThttp://www.sqlmag.com/article/remote-computing/psexec-to-the-rescue#commentsAnchorhttp://www.sqlmag.com/article/remote-computing/psexec-to-the-rescue#commentsAnchorFri, 03 Oct 2008 12:38:02 GMT
Good article TIm. One more reason to "Let the ways of the command prompt", and since TS is still a big part of our life I hope you cover other non GUI ways to negate the errors of the "carbon units". Curt Spanburgh]]>CURTFri, 03 Oct 2008 12:38:02 GMThttp://www.sqlmag.com/article/remote-computing/psexec-to-the-rescue#commentsAnchorhttp://www.sqlmag.com/article/tsql3/queries-dragging-try-defragging#commentsAnchorFri, 26 Sep 2008 10:03:47 GMT
From: AMMCOLLO Forgot to add ,all servers are virtual (VMWare).]]>AustinFri, 26 Sep 2008 10:03:47 GMThttp://www.sqlmag.com/article/tsql3/queries-dragging-try-defragging#commentsAnchorhttp://www.sqlmag.com/article/tsql3/queries-dragging-try-defragging#commentsAnchorFri, 26 Sep 2008 10:03:33 GMT
This stored Proc has been very useful. Good Job !!! But I have been getting an error with the execution ’N’ option: the error is : Line 135, Ambiguous name column ’Type_Desc’. The SQL version is 2005 SPK2 64bit and the OS is windows 2008 64 bit. everything runs well on the same table of info/indexes in SQL 2005 SPK2 32bit and OS of windows 2003 R2. Any Ideas ? Bad data or indexes?]]>AustinFri, 26 Sep 2008 10:03:33 GMThttp://www.sqlmag.com/article/tsql3/queries-dragging-try-defragging#commentsAnchorhttp://www.sqlmag.com/article/smtp/have-you-checked-your-smtp-mailbox-temporary-tables-lately-#commentsAnchorFri, 19 Sep 2008 11:26:31 GMT
would be nice to see the whole article even though I have a full subscription.]]>jhendoFri, 19 Sep 2008 11:26:31 GMThttp://www.sqlmag.com/article/smtp/have-you-checked-your-smtp-mailbox-temporary-tables-lately-#commentsAnchorhttp://www.sqlmag.com/article/remote-computing/command-prompt-tricks#commentsAnchorThu, 18 Sep 2008 03:29:53 GMT
GOOD]]>ashokThu, 18 Sep 2008 03:29:53 GMThttp://www.sqlmag.com/article/remote-computing/command-prompt-tricks#commentsAnchorhttp://www.sqlmag.com/article/remote-computing/command-prompt-tricks#commentsAnchorThu, 18 Sep 2008 03:28:54 GMT
hai]]>ashokThu, 18 Sep 2008 03:28:54 GMThttp://www.sqlmag.com/article/remote-computing/command-prompt-tricks#commentsAnchorhttp://www.sqlmag.com/article/registry2/change-the-windows-logon-screen#commentsAnchorThu, 11 Sep 2008 14:57:01 GMT
You’re not creating a Key you want to create a String Value and name is Ginadll and then in it give the name of the file (msgina2.dll or whatever).]]>gogododo Thu, 11 Sep 2008 14:57:01 GMThttp://www.sqlmag.com/article/registry2/change-the-windows-logon-screen#commentsAnchorhttp://www.sqlmag.com/article/tips/how-to-access-directory-services-restore-mode-on-a-remote-dc#commentsAnchorThu, 04 Sep 2008 09:25:03 GMT
Nice Tip! You are a Genius.Q]]>paulThu, 04 Sep 2008 09:25:03 GMThttp://www.sqlmag.com/article/tips/how-to-access-directory-services-restore-mode-on-a-remote-dc#commentsAnchorhttp://www.sqlmag.com/article/tips/how-to-access-directory-services-restore-mode-on-a-remote-dc#commentsAnchorTue, 02 Sep 2008 04:59:04 GMT
it can help me to some extend]]>SamuelTue, 02 Sep 2008 04:59:04 GMThttp://www.sqlmag.com/article/tips/how-to-access-directory-services-restore-mode-on-a-remote-dc#commentsAnchorhttp://www.sqlmag.com/article/performance/thank-you-microsoft#commentsAnchorSun, 31 Aug 2008 05:05:23 GMT
2008 - take a look a Vista. Enough said.]]>hildaSun, 31 Aug 2008 05:05:23 GMThttp://www.sqlmag.com/article/performance/thank-you-microsoft#commentsAnchorhttp://www.sqlmag.com/article/tips/how-to-access-directory-services-restore-mode-on-a-remote-dc#commentsAnchorWed, 27 Aug 2008 11:40:22 GMT
Superb! Great article - thanks!]]>AshleighWed, 27 Aug 2008 11:40:22 GMThttp://www.sqlmag.com/article/tips/how-to-access-directory-services-restore-mode-on-a-remote-dc#commentsAnchorhttp://www.sqlmag.com/article/tsql3/find-any-string-in-any-sql-code-in-any-database#commentsAnchorWed, 06 Aug 2008 00:10:37 GMT
Msg 102, Level 15, State 1, Line 1 Incorrect syntax near ’00293’.]]>yangWed, 06 Aug 2008 00:10:37 GMThttp://www.sqlmag.com/article/tsql3/find-any-string-in-any-sql-code-in-any-database#commentsAnchorhttp://www.sqlmag.com/article/registry2/change-the-windows-logon-screen#commentsAnchorTue, 05 Aug 2008 02:40:45 GMT
I have test it in windows xp, I changed this bitmap of 101, i thought the logo will change before logoin ,but the bmp appread when i shutdown the computer. :) I didn’t use registry entry, because i installed two windows xp system.]]>wangTue, 05 Aug 2008 02:40:45 GMThttp://www.sqlmag.com/article/registry2/change-the-windows-logon-screen#commentsAnchorhttp://www.sqlmag.com/article/tsql3/find-any-string-in-any-sql-code-in-any-database#commentsAnchorThu, 31 Jul 2008 19:54:28 GMT
in case of sql server 2005 and 2008 "sys.sql_modules" category view is more useful than "syscomments" system table. in addition [syscomments].[text] column size is too small to store the source code of big(?) SPs, UDFs, Views. in this case source code is devided into multiple rows and your code might not work properly...]]>Doe YullThu, 31 Jul 2008 19:54:28 GMThttp://www.sqlmag.com/article/tsql3/find-any-string-in-any-sql-code-in-any-database#commentsAnchorhttp://www.sqlmag.com/article/tsql3/find-and-replace-keywords-in-stored-procedures#commentsAnchorWed, 30 Jul 2008 15:46:49 GMT
One improvement to the script seems to be to retain object-level permissions, since DROP-and-CREATE will lose all permissions previously granted.]]>RaymondWed, 30 Jul 2008 15:46:49 GMThttp://www.sqlmag.com/article/tsql3/find-and-replace-keywords-in-stored-procedures#commentsAnchorhttp://www.sqlmag.com/article/internet/put-ie-7-0-s-toolbar-back-where-it-belongs#commentsAnchorMon, 14 Jul 2008 23:10:12 GMT
You got to love the registry, Thanks mate]]>ShawnMon, 14 Jul 2008 23:10:12 GMThttp://www.sqlmag.com/article/internet/put-ie-7-0-s-toolbar-back-where-it-belongs#commentsAnchorhttp://www.sqlmag.com/article/passwords/managing-the-administrator-account-password-on-servers-and-workstations#commentsAnchorFri, 11 Jul 2008 17:17:28 GMT
Another nice trick is to have the .bat file have two lines one with the /ADD and the other with just the ---> net user Administrator xus9drapHacH /y <--- first line to add the account if it is not there, and the second line without the /ADD to reset the password if the account exists. Just make sure both the lines are the same passwords!]]>CHADFri, 11 Jul 2008 17:17:28 GMThttp://www.sqlmag.com/article/passwords/managing-the-administrator-account-password-on-servers-and-workstations#commentsAnchorhttp://www.sqlmag.com/article/tsql3/nifty-ways-to-use-for-xml-path-concatenation#commentsAnchorThu, 10 Jul 2008 10:12:10 GMT
Very useful. FullQuery could be enhanced by excluding included columns by adding the restriction "AND ic.is_included_column = 0" just before the line "ORDER BY ic.key_ordinal". Add another column to the select list and another derived table to separately see the list of included columns.]]>DonThu, 10 Jul 2008 10:12:10 GMThttp://www.sqlmag.com/article/tsql3/nifty-ways-to-use-for-xml-path-concatenation#commentsAnchorhttp://www.sqlmag.com/article/tsql3/adventures-with-big-data-how-to-import-16-billion-rows-into-a-single-table#commentsAnchorFri, 13 Jun 2008 13:00:27 GMT
What a great article and a good tip to know about BCP with the 4-Byte Integer. But the best part was the persistant dealing with the problem and the willingness to persit in waiting for the results. I have been through these "nail biters" before and it takes nerves of steal to pull them off. Great Job. Curt Spanburgh. MVP Dynamics CRM.]]>CURTFri, 13 Jun 2008 13:00:27 GMThttp://www.sqlmag.com/article/tsql3/adventures-with-big-data-how-to-import-16-billion-rows-into-a-single-table#commentsAnchorhttp://www.sqlmag.com/article/remote-computing/command-prompt-tricks#commentsAnchorMon, 09 Jun 2008 05:28:25 GMT
Hmm.... i have been reading through these comments, and for god sakes how many children use this site! If you are actually intrested in becoming a programmer i suggest you enroll on a course, even a home learning course. At the very least you caould buy a book. Your not gonna learn to code in C+ or VB from a few comments of a post, so I don’t see the point in trying. I feel sorry for the people that actually are trying to help people here. Fair enough if you are having debugging problems and need some help with some code, but children trying to "impress" thier friends is ridiculous, do something constructive, like your school work!]]>Hundredsouls Mon, 09 Jun 2008 05:28:25 GMThttp://www.sqlmag.com/article/remote-computing/command-prompt-tricks#commentsAnchorhttp://www.sqlmag.com/article/server-systems/server-uptime#commentsAnchorWed, 21 May 2008 16:34:58 GMT
I guess Microsoft wasn’t releasing critical security updates every month back then... LOL]]>MarcWed, 21 May 2008 16:34:58 GMThttp://www.sqlmag.com/article/server-systems/server-uptime#commentsAnchorhttp://www.sqlmag.com/article/tsql3/making-sense-of-sysperfinfo#commentsAnchorTue, 13 May 2008 10:18:04 GMT
Thanks, readers, for your feedback. I’m glad you found this article useful. I’ve changed the access level to registered user to make the article available to more people. Anne Grubb, Web site editor, SQL Server Magazine]]>AnneTue, 13 May 2008 10:18:04 GMThttp://www.sqlmag.com/article/tsql3/making-sense-of-sysperfinfo#commentsAnchorhttp://www.sqlmag.com/article/tsql3/making-sense-of-sysperfinfo#commentsAnchorTue, 13 May 2008 05:19:27 GMT
Thanks, great start for using counters.]]>AlexanderTue, 13 May 2008 05:19:27 GMThttp://www.sqlmag.com/article/tsql3/making-sense-of-sysperfinfo#commentsAnchorhttp://www.sqlmag.com/article/file-systems/synchronizing-mdb-files#commentsAnchorThu, 08 May 2008 18:33:56 GMT
Very useful < had the exact same problem; appied the method described here and the method worked perfectly. I did not have to go in and set policy for individual .mdb files. Once I "enabled" the ploicy without any extensions in the field, I rebooted and Voila! SyncCity]]>michaelcurrie11 Thu, 08 May 2008 18:33:56 GMThttp://www.sqlmag.com/article/file-systems/synchronizing-mdb-files#commentsAnchorhttp://www.sqlmag.com/article/tsql3/t-sql-function-finds-almost-any-kind-of-date#commentsAnchorMon, 05 May 2008 13:28:50 GMT
If anyone has issues with the matirx etc. Please just email me at michaelberry67@yahoo.com and I would be happy to help!]]>MichaelMon, 05 May 2008 13:28:50 GMThttp://www.sqlmag.com/article/tsql3/t-sql-function-finds-almost-any-kind-of-date#commentsAnchorhttp://www.sqlmag.com/article/task-scheduling/tired-of-creating-mapi-profiles-try-richprofile#commentsAnchorThu, 01 May 2008 14:05:37 GMT
Outlook Profiler works so much better...]]>pcunite2Thu, 01 May 2008 14:05:37 GMThttp://www.sqlmag.com/article/task-scheduling/tired-of-creating-mapi-profiles-try-richprofile#commentsAnchorhttp://www.sqlmag.com/article/migration/your-non-vista-option#commentsAnchorMon, 21 Apr 2008 21:17:06 GMT
good process]]>hilalyaman Mon, 21 Apr 2008 21:17:06 GMThttp://www.sqlmag.com/article/migration/your-non-vista-option#commentsAnchorhttp://www.sqlmag.com/article/migration/your-non-vista-option#commentsAnchorMon, 21 Apr 2008 21:16:38 GMT
good]]>hilalyaman Mon, 21 Apr 2008 21:16:38 GMThttp://www.sqlmag.com/article/migration/your-non-vista-option#commentsAnchorhttp://www.sqlmag.com/article/tips/an-alternative-to-windows-vista#commentsAnchorThu, 17 Apr 2008 03:06:17 GMT
When I first started reading this article in the mag I thought ’Great, an alternative to Vista, about bloody time’, but then I saw the articles author, and I became sadly depressed again! If ANY Microsoft people read the article, then please, please, take up the idea! Windows XP Classic would be so much better than Vista. Personally we’re waiting for Windows 7, so we can migrate straight from XP to that and by pass Vista altogether. To the editors of WindowsITPro, if you’re going to run April fools, please make the article smaller, or more humourious so that its an obvious joke. I think too many people will take this as a legit article, and get their hopes up, as no one really notices/bothers to read the article authors!]]>BenThu, 17 Apr 2008 03:06:17 GMThttp://www.sqlmag.com/article/tips/an-alternative-to-windows-vista#commentsAnchorhttp://www.sqlmag.com/article/ip-addressing/change-ip-settings-in-a-snap#commentsAnchorWed, 16 Apr 2008 07:39:47 GMT
Near the top of the page, you’ll find a blue "Download the Code Here" button. Just click it to download the 96113.zip file, which contains the SetIP.cmd script.]]>KarenWed, 16 Apr 2008 07:39:47 GMThttp://www.sqlmag.com/article/ip-addressing/change-ip-settings-in-a-snap#commentsAnchorhttp://www.sqlmag.com/article/ip-addressing/change-ip-settings-in-a-snap#commentsAnchorTue, 15 Apr 2008 15:01:29 GMT
where can I get SetIP.cmd ?]]>kjhdsfTue, 15 Apr 2008 15:01:29 GMThttp://www.sqlmag.com/article/ip-addressing/change-ip-settings-in-a-snap#commentsAnchorhttp://www.sqlmag.com/article/tips/an-alternative-to-windows-vista#commentsAnchorTue, 08 Apr 2008 09:38:26 GMT
I agree with sccdsbit. Not very professional]]>seanTue, 08 Apr 2008 09:38:26 GMThttp://www.sqlmag.com/article/tips/an-alternative-to-windows-vista#commentsAnchorhttp://www.sqlmag.com/article/remote-computing/command-prompt-tricks#commentsAnchorThu, 03 Apr 2008 13:19:18 GMT
i am on a school computer right now and most of this stuff isn’t working .. it may be because i am not on an admin account but is there a way to become an admin... thanks for the help.]]>toddThu, 03 Apr 2008 13:19:18 GMThttp://www.sqlmag.com/article/remote-computing/command-prompt-tricks#commentsAnchorhttp://www.sqlmag.com/article/tips/an-alternative-to-windows-vista#commentsAnchorThu, 03 Apr 2008 12:24:32 GMT
I am not a fan of April Fool’s Day in any way shape or form. I get particularly aggravated when I spend my valuable time reading an article only to find that it was an April Fool’s joke. Worse still is that some people don’t read far enough to determine that it is a joke. They simply go away thinking the misinformation is true. Please do not include such "jokes" in the future. They are not funny.]]>RobThu, 03 Apr 2008 12:24:32 GMThttp://www.sqlmag.com/article/tips/an-alternative-to-windows-vista#commentsAnchorhttp://www.sqlmag.com/article/tips/an-alternative-to-windows-vista#commentsAnchorThu, 27 Mar 2008 14:49:51 GMT
Most people should remember that XP had the same reception as Vista. Like many people, I hated XP when it came out. Now I can’t stand working on someone’s 95 or 98 box, although W2K is still OK with me. One thing’s clear, if your brand new "loaded" pc/laptop runs like crap because of Vista, somthin ain’t right. Thanks to Dell, we still have an OS option.]]>KenThu, 27 Mar 2008 14:49:51 GMThttp://www.sqlmag.com/article/tips/an-alternative-to-windows-vista#commentsAnchorhttp://www.sqlmag.com/article/tips/an-alternative-to-windows-vista#commentsAnchorThu, 27 Mar 2008 09:57:18 GMT
This is great news!!! Microsoft needs to follow the same suite with Server 2008 as well. That is one of the biggest boxes of crap since Vista. M$ should make XP and 2003 work properly instead of forcing new crap down our throats. It costs industry untold mega-dollars each time M$ releases new stuff. In fact, most companies haven’t recovered form the XP and 2003 upgrades. Then to force Vista and 2008 down our throats very shortly after - as well as Exchange 2007 (another box of crap) is just bad for business and the economy. Then again, M$ has more money than the economy so how would they know anyway. I say just fix the good stuff and we can all get on with making money for “our” stock holders and not just make more money for M$ stock holders. But what do I know. I’ve only been dealing with this stuff since the early 90’s and make my living form it now.]]>AbbyThu, 27 Mar 2008 09:57:18 GMThttp://www.sqlmag.com/article/tips/an-alternative-to-windows-vista#commentsAnchorhttp://www.sqlmag.com/article/tsql3/display-dates-in-the-format-you-need#commentsAnchorTue, 04 Mar 2008 11:26:28 GMT
I contacted the author, Roy Byrd, about your question. He noted that, "The problem is the format parameter ’hh:mm:ss’ uses the ’mm’ instead of the ’nn’ for the minutes value. The ’mm’ in the format paramter is for months. The correct format is ’hh:nn:ss’ if minutes are desired. The following script declare @Datefield datetime set @Datefield=’10/9/2007 2:27:45’ select dbo.FormatDate(@Datefield,’hh:mm:ss’) returns 02:10:45 showing the value of the month is 10 in the ’mm’ position. If the format is changed to use ’nn’ in the minutes position, 02:27:45 is returned. The T-Sql statement SELECT CONVERT(varchar(10), @DateField, 108) returns 02:27:45." I hope that answers your question. If not, please let me know. Karen Bemowski Senior editor SQL Server Magazine, Windows IT Pro, Scripting Pro VIP]]>KarenTue, 04 Mar 2008 11:26:28 GMThttp://www.sqlmag.com/article/tsql3/display-dates-in-the-format-you-need#commentsAnchorhttp://www.sqlmag.com/article/tsql3/display-dates-in-the-format-you-need#commentsAnchorMon, 03 Mar 2008 13:01:32 GMT
Possible time conversion issues: I have a date source value of Datefield = ’10/9/2007 2:27:45’ Using formatdate(DateField, ’hh:mm:ss’) returns 14:10:45. Using SQL onversion CONVERT(varchar(10), DateField, 108) returns 14:27:45 Can you confirm the results?]]>ElieMon, 03 Mar 2008 13:01:32 GMThttp://www.sqlmag.com/article/tsql3/display-dates-in-the-format-you-need#commentsAnchorhttp://www.sqlmag.com/article/tsql3/strim-strips-out-non-alphanumeric-characters#commentsAnchorThu, 21 Feb 2008 15:31:41 GMT
OptimalSolutions, thank you for pointing out the problems with the listing links--although I’m sorry that the problem occurred. I totally understand your frustration. Readers have been reporting multiple similar problems over the past couple months. If it only were a matter of QA checking on our side, the problem wouldn’t exist. However, the problem stems from several technical issues out of the editors’ control, related to our Web hosting and production processes. This isn’t to make excuses, rather to say that we editors are as frustrated as you are about it. I will report it ASAP to our Web team and will do what I can to keep the issue from happening again! Thanks for your patience. Anne Grubb, Web site strategic editor, SQL Server Magazine]]>AnneThu, 21 Feb 2008 15:31:41 GMThttp://www.sqlmag.com/article/tsql3/strim-strips-out-non-alphanumeric-characters#commentsAnchor