Hi, I receive this error message in one of my servers : "Failed to reserve contiguous memory of size = 131056." I have enabled AWE memory on this...
Hi , I changed a database to Single_user mode. I executed some commands and I tried to kill a process and it is taking a long time. So, I restarted...
Hi, I have a database of size around 7 GB. I created a maintenance plan which backups the database and also updates the statistics in the database....
Hi, In my appliaction, I have a stored procedure which calls 11 different stored proceudres within it (all in a single batch). That is causing...
Hi, I have 1000 records in one table with a clustered index on one column( for convinience let's take it as eno). Now, I want to insert a record...
I have a "heap" with non-clustered indexes on it. If I run the dbcc showcontig command, it shows the fragmentation level of that index or data page....
Hi All, I ran the performance monitor and found the results in this way: Target Server Memory > Total Server Memory (always) Buffer Cache Ratio :...
Hi, http://www.sql-server-performance.com/sql_server_performance_audit2.asp In this article, it is mentioned that if the number of user...
Hi, I have enabled c2 audit mode in my Test Server. But my problem is that, it is creating a trace file and it is storing data in that trace file....
Can any one help me out on how to uninstall one instance of SQL Server on a Failover Cluster. I have multiple instances running on it. If I...
Hi, I have granted some permissions to an user using "Grant Permission " some time ago. I would like to know the permissions which have been granted...
Hi, I have granted some permissions using "Grant" permissions some times ago. I do want to know what are all the permissions I have granted to that...
Hi, Can anyone help me out in transfering the DTS package from one server to another( Live to Test)? Thanks in Advance, N.Babu
Hi, My database size is 150 GB and our server have 4 GB RAM and 8 processor. By running the performance monitor, i observed that there is...
I have a login name (Babu) with SID (12345). I have mapped this login to a database named (Babu_Test). Now, I want to delete this login "Babu". I...
Hi, I have a DTS package stored in "Local Packages". I now want to save the DTS Package in a text or VB file and I want to restore it in case of...
Hi, Can anyone help me out in How to create a view from two tables which are located in two different servers? Thanks in Advance. Regards,...
Hi, Is there any Client Third Party tools to use SQL Server 2000 from GUI version of MANDRAKELINUX I have a MANDRAKELINUX client in my network, I...
How to install sql server service pack 3 a in a failover cluster having active/passive configuration. Can any one help me? N.Babu Godson Samuel
Separate names with a comma.
