I was searching a tool capable of showing the Server enviornment on the desktop ..
Well its indeed BigInfo :) .You will find it on Sysinternal site .
Infact there are a lot of other useful tools that you can use ..or simply download the complete suit ..
Here you go ..
http://technet.microsoft.com/en-us/sysinternals/bb897557.aspx
Enjoy (",)
Search This Blog
Tuesday, May 19, 2009
Monday, May 18, 2009
How to see the SSIS packages for the Named Instance (2005/2008) of SQL Server .
-> Go to C:\Program Files\Microsoft SQL Server\100\DTS\Binn [this is SQL Server 2008 but the path would be same for 2005 as well .instead of 100 it will be 90].
-> Find the file MsDtsSrvr.ini.xml and open it in notepad .
-> You will see 10-12 XML format lines .
-> By default you will see :.
-> Remove the DOT (.) and replace it with the server name \instance name .
-> Restart the integertion service from Services console .
Hope this helps .
-> Find the file MsDtsSrvr.ini.xml and open it in notepad .
-> You will see 10-12 XML format lines .
-> By default you will see :
-> Remove the DOT (.) and replace it with the server name \instance name .
-> Restart the integertion service from Services console .
Hope this helps .
Subscribe to:
Posts (Atom)