I would like to put any sql statements which should give me dynamic sql of those statements

yes that is what my script does in the 4th part for which i am not worried but i would like to know how can i implement forst 3 steps...

Also I would like to know if there are any dis advantages by managing security from a web page out of sql server.

I have a script which i want to run from the same stored procedure which locks some tables in the database which contians sensitive data.

Can you let me know how...

Actually i tried all 3 ways and also killed but it didnt roll back, just killed the session.

Not yet, its been 4 days but still doing the shrink with no gain of space till now but i have to stop it and start backing up the database...

The main reason for the shrink is i had to delete un used records of nearly a billion and so want to check how much space i have saved and...

I have deleted so many records for which i am expecting atleast 100gb space back and i am interested to know the reason why it takes so longer.

Is there a way i can check if i have all the indexes in a database through a query. I have 34 indexes in all the databases which is consistent...

I think if the application is MSMS Query then i can get some text result for the above query but for this user ther application used says " Microsoft SQL...

I am getting blank.

I am looking for all obejcts(tables) in the database, I already have default trace job setup in sql 2005 which runs every 15min and records it to the table but...

thanks it worked.

in that case i think i have to change parameter to

alter fnEmp

(

@empid vatchar(5)=null

)

right?

I got the same error and tried different options for protectionlevel but failed with same error.

i tried serverproperty and dont save sensitive but still failed.