Sometimes you want to run your profiler as a different user than the user that is logged onto the machine and uses a template of your choice then the following lines in a batch file can help you.
SET SSMSEXE=C:\Program Files\Microsoft SQL Server\100\Tools\Binn\PROFILER.EXE
C:\WINDOWS\system32\runas.exe /user:Domain\otheruser /savecred "%SSMSEXE% /S spa /T mytemplate"
Launching Management Studio with Domain\OtherUser,windows authentication and dv_dev as default database.
SET SSMSEXE=C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe
C:\WINDOWS\system32\runas.exe /user:Domain\OtherUser /savecred "%SSMSEXE% -s spa -d DB_Dev -E -nosplash"
Tested under SQL Server 2008R2 only.
Monday, April 4, 2011
IIS Manager Crashes on Start Windows 7, IIS 7.5, Power Shell 5.1. Here is the error I got in the event viewer. IISMANAGER_CRASH IIS Ma...
Update: 1/27/2013 I have got a very good response and feedback for the tool, I am working on the new version of it and soon will be relea...
If you have played with or is using System.DirectoryServices.ActiveDirectory, you might jump into the consclusio that "DirectorySearche...
Failed to open the connection. Details: [Database Vendor Code: 4060 ] Failed to open the connection. temp_62a7065e-b077-44f0-8593-7dca04303...