Hi Iam looking for a script to get the sql server instances running on the server. [:(] Kindly share if you you have the command or script. gopi
Hi All, Iam looking for a script that gives both sql server version and service pack installed for both 2000 and 2005 servers. I tried @@version and...
Hi All, Thanks for the help. I was able to load the server list.
Hi All, I was using a taxi server to connect to sqlservers. Now we are shifting to another taxi server. I have registered around 200 sql servers in...
Thanks satya !
Hi all, Iam looking for a script that will show only the current running jobs in a server. I queried in sysjobhistory table for run_status 4 (In bol...
Hi, I used to use the following command which tells in which node the instance is currently running. Exec master..xp_cmdshell 'net user' gk
Thank You Satya, I tried fn_get_sql , but it will show only if we are executing a proc. Adhoc queries are not captured. How to check the text of...
Hi, Is there any system table where we can view the commands for the user processes. We used to use dbcc inputbuffer() Is this information is...
Windows Server 2003 Standard Edition with Service pack 1
Windows Server 2003 Service pack 1
Hi, Iam facing an issue with the Management Studio in SQl Server 2005. The server has been installed on Windows 2003 server that met all the pre...
Thanks Dill, Is there any way we can send the excel file through sql mail. thanks gk
is there any way to send the Excel file from the database server thorough mail. Mail server is configured for sql server and is working fine with...
Thank you mohammed, it was really help ful for me.
Hi, I have a script to collect the logins and the users information from the database. I have the requirement to run on master database and it...
Hi, Is there any command to check the Total (Defined) space in a drive through sql server , as xp_fixeddrives will give only free space in the...
Hi, I have moved one backup file from one server to another. But when checked the consistency of database backup it is showing incomplete in header...
Hi, I have the transactional replication configured on one of my server. Subscriber is also on the same server. Server is rebooted and after that...
Hi this is my small cute messy scriptfor the above requirement. create table #userinfo ( login varchar(20)NULL, db_owner char(1) NULL default 'N',...
Separate names with a comma.
