Hey can anyone help me in writing script that how we can deny permission on mutilple objects at once suppose there is a user A and we want to deny...
I have a question regarding security in sql2000. If you create a login and public (permissions) are default. does a login with a public right can...
I am trying to execute a DTS package. but i am getting an error: Error Source: Microsoft OLE DB provider for SQL Server. Error Description: Error...
dear friends actually i am taking the transaction log backup og 60 databases everyday at the rate after every half hour. now i have to keep last...
Hey! Can anyone please help me and guide me that how i can get the output of sp_helplogins in excellsheet . i get the oupt bit all the output comes...
On dev server for one of the database I woulike to change the path for databa d the log file. for example: current path:- c:program...
one of my end user is getting error in an application:<br />ERROR:<br />"Please Relogin <img src='/community/emoticons/emotion-7.gif' alt=':S'...
can you please guide me the details and safe procedure to migrate database from sql 7 to sql 2000 production cluster. i was thinking to try through...
I am experiencing very bad performance delays today in my production server. I treid follwoing things : 1. through sp_who2 checked if there is any...
I am going to prepare for 70--228 Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition.<br /><br />can anyone...
Can anyone please guide me that how to find that when a particular database was last updated in SQL Server 2000 for example: employee database. if...
I have two servers one is development cluster and another is production cluster. there are abour 30 databases in both of the cluster. I want to...
Actually in one of my production server the SQL log has grown up to 2GB whenever I try to Closes the current error log file and cycles the error log...
1. i have schedule a job od dbstats in my dev server , in that there is a column name for server name.In single servers i am able to retrieve the...
hey friends i need your advice... i want to make a good career as DBA... can you please guide how i can learn sql 2000 and sql 2005... i want to...
it is very urgent and important so please reply soon. thanks a lot i want to explain my scenario once again. 1. i am having access to 12...
Following are the conditions:- 1) I am working 11 sql servers on my machine. 2)i have to create a centarlised maintainance server. 3.i want to run...
Separate names with a comma.
