is there a script where i can find on whole server any views which are using select *. I wud like to know the db and view name.

or

atleast if i...

I looked out but didnt find any which suits my criteria.

just as we get gragmentation report from SSMS when right click on DB, I need something like that which reports...

How cud i verify my access and how can i make an existing user as sysadmin.

I am the sysadmin on the server but still says

" Property owner is not available for database mydb . This property may not exist for this object or may...

is this a rare issue?

I tried but it says db is read-only and cannot do it. I dont think tht works, there shud be some other go.

Philip

can you pls elaborate the above statement from...

we have db's with same schema in the same instance, and this query is ran in all the db's and they run very gud except this db. what might be...

I want to do this off peak time for allthe DB's. What is the best way to implement it by sheduling a job.

when i run all alter table commands of...

I can find which talbes has "mycolumn" but how cud i find which database has that column, because i need to search 87 databases in a server.

Do we also need...

How about changing INt to varchar(5), where it has millinons of records.

How can i find all the objects using that column so that i can change it later. will i lose any data in conversion of datatype.

I wud like to change collation for database,tables and columns in it. BUT when i change collation at DB level it is changing at table level but not at column...

Here is the error:

Msg 468, Level 16, State 9, Line 56

Cannot resolve the collation conflict between "Latin1_General_CI_AI" and "Latin1_General_CI_AS" in the equal to operation

I worked around this sql but i...

So 1st i need to find where that column is used in whole databases then change it every where.

Is there any script which will find column and change datatype at...