thanks a lot john that script is working well but for some of the tables it is giving and error that object name 'Name_of_table' is invaild...
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...
Thanks a lot satya I tried with the following script to deny the permission on all tables in database XYZ to user name = ABC use XYZ declare @user...
thanks a lot can you please give me an example how to use cursor suppose with 10 tables, actually i never treid this before.moreover i have to do...
I am sorry..I found it out how to do through EM but can anyone suggest me that which T-SQL can help me to revoke the rights for a user to...
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...
what it will return if it is 64 bit
Thanks a lot satya...I got the script from the link below: http://www.sqlteam.com/item.asp?ItemID=11672 link. I am not able to use the link to...
Thanks a lot friends.... actually the recovery model is full in all the databases of all servers. I am taking the transaction log backup through...
thanks actually my case is different. i want to delete the transaction log backups files if they are more than tow days older. please suggest...
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...
thanks a lot to everyone
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...
Thanks a lot. i think you have misunderstood. I donot want to move the files anywhere but want to change the path of the data and log files . can...
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...
THIS IS FROM USER HOW IS FACING PROBLEM: ERROR: don#%92t know how long I have been logged web, maybe 15-20 min, but I was just going to save a...
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...
thanks but i am not having that much time please guide me some shortcut to know about the faults in the performance.
Separate names with a comma.
