ok this is what i used.

EXEC sp_columns_ex sqlserver_name, NULL, db_owner, db_name, NULL

Thanks for all you replies.

This is what I did, I restricted access to all the tables for the user 'abc' for 'Select' ing data from the tables. But this causes another problem, that...

thnks.

Ok here is what i did. i uninstalled MS SQL Server Tools and then installed MS Visio. Next i installed MS SQL Server Tools and then upgraded to SP2. It...

i will re-install the tools thanks

CREATE PROCEDURE usp_UPD

AS

DECLARE @tName VARCHAR(30)

DECLARE @CURSOR_USERNAME CURSOR

SET @CURSOR_USERNAME = CURSOR FAST_FORWARD

FOR

SELECT name FROM sysobjects WHERE xtype='U'

OPEN @CURSOR_USERNAME

FETCH NEXT FROM @CURSOR_USERNAME INTO @tName

WHILE (@@FETCH_STATUS = 0)

BEGIN

UPDATE [dbname].[dbo].[@tName]

SET vchBy = 'XYZ'

WHERE vchBy...