Dear
Can we use this thread for any IT related discussions, ranging from Software development, Maintenance, support, Networking, and hardware (client/Server) issues.
Please post your questions here to get going
Printable View
Dear
Can we use this thread for any IT related discussions, ranging from Software development, Maintenance, support, Networking, and hardware (client/Server) issues.
Please post your questions here to get going
I remember there was a thread with same title :roll:
can't find it any more :(
My bro accidentally uninstaled google chrome...I've reinstalled it but is there any way to recover my lost bookmarks... renaming bookmarks.bak din't work...
DevudaQuote:
Originally Posted by dev
What version of windows is that? there should be tool in windows that allows you to recover lost data!
Raghu, it's XP...
does any one know the 'DOS' to find a list of Servers on given domain?
I prefer DOS over VB script :)
cmd > net view
not very sure though :lol:
sorry, i wanted to find the number of SQL server 2008 on windows 2003.. but your command will give all the windows server, any wayQuote:
Originally Posted by Raikkonen
if you type in OSQL -L would give you the list, but if you want to complicate things, like i alwys do :lol: the following SQL script will do
/* Gives a list SQL servers on a given domain */
CREATE PROCEDURE dbo.ListLocalServers
AS
BEGIN
SET NOCOUNT ON
CREATE TABLE #servers(sname VARCHAR(255))
INSERT #servers EXEC master..XP_CMDShell 'OSQL -L'
-- play with ISQL -L too, results differ slightly
DELETE #servers WHERE sname='Servers:'
SELECT LTRIM(sname) FROM #servers WHERE sname != 'NULL'
DROP TABLE #servers
END
exec ListLocalServers
i don't have any servers installed at my home.. :oops:
i will try to read and understand this at office :lol: