Hello All, We have a requirement to restrict a user/group on Production server to use limited resources, i.e. RMA/CPU. Do we have any option in SQL...
Hello Everyone, I got a requirement to copy the backup file from Production to some other shared folder on other machine automatically once the...
Hello All, I have created a alert in SQL Server to send a notification to a Operator when ever a specific error is occured, I have create the same...
Hi, Any Help is really appreciate​d System.Data.SqlClient.SQLError: cannot Restore the file "_log" because it was originally written with sector...
Any script available to store the information in a user table from sysprocesses view?
Hello everyone, I got a requirement to track all the information like the users connecting, queires executing by them and time, etc. I think we can...
Hello All, We have a job which runs DBCC checkdb on a database which is scheduled to run daily; from last couple of days we are getting database...
Hello All, Can some one please help me that how can we get the min value from the set of given values I.e if we give a query like "select min(1,2,3)...
I am unable to create database objects owned by me under my own login!! I am sys admin on the server. In other words, I cannot do something like...
Any one please help me.........
Here i forgot to mention the database name I.E "ReportServer". i think this database is created when they installed the reporting services. Shyam...
Hello All, We are supporting a SQL Server which has Reporting sevices and Analysis services, we dont have much information about the databases on...
Hello All, I need some information about the AWE. In last month one of our server got restated and AWE was not started automatically and it was...
Hi I am unable to increase Width of the column say from 250 to 1000. The error which i am getting is "900 is the maximum allowable size of an...
Hello Mr. Ashwin, I Think the error which u got is not on SQL Server 2000 with sp4. SS Shyam Sunder Gajendula...
The following are the details of the database. SQL Server 7(SP4) Database has three datafiles in the primary file group(XX_01Data, XX_02Data &...
Separate names with a comma.
