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.
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...
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...
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...
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...
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...
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...
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...
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...
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...
I have the transactional replication configured on one of my server. Subscriber is also on the same server. Server is rebooted and after that...
Could any body share the script that gives the login information in database level like the following.
Could any body share the script to show the Indes size and Datasize in GB of a database
I need to register a server using windows authentication.
While registering the server iam getting the error -
"Cannot generate SSPI context"....
The following command calling a DTS package. We have around 100 DTS packages in the server. Can any body share the command or script to view ,...
Did any of you see that a database is set to autogrow and there is space on the drives, but it not grow when the space got filled up ?
As a part of tracking database growth iam looking for a script which gives
datafile , occupied space and Free space for datafiles and log...
We have a production databases and in some tables (randomly), rows
with duplicate primary key values are coming up. I cannot understand
iam facing a CPU hike for the following processes
SPID StatusLoginDBName nd CPUTime DiskIO LastBatch ProgramName...
Iam getting deadlocks frequently for the last few days.
when i check the spid with dbcc input buffer iti sshowing the following command....
Separate names with a comma.