I executed below query where in found the Pages count is 5000

but how big index is it, i didnt come to know

=========================

SELECT

s.[name] AS [Schema],

o.[name] AS [Table], ...

Gila, How do i get to know abt it??

can you help me with the query

thanks All, yes the DB owner was NULL.. i have changed that with

sp_changedbowner 'username'

🙂 thanks All...

Thanks Anthony & Gail 🙂

Anthony yup i was talking abt LDF Files.

Full Recovery model

yes, backup of Transacvtion Log is been taken.

I just want to set the log file size to 500 MB.. so that incase it exceeds it will overwrite the...

bhuvnesh, u mean to say that by adding an additional parameters in sp we can extend the columns more than 1024?

Actually the information in the report which is required itself is more than 1024 columns...

how to get rid of this?

hi Perry,

No its the Development Server, i have done with moving of dsatafiles to other location only for One DB..In sometime i am going to do it for all

thanks Perry, great paul 🙂 It worked

Good Idea if i have one or two DB's..

But there are 170 + Db's :w00t:

I did, Execute the Alter Datafile query

i got outut - the files are moved . next time when DB starts..

Fine enough..then i took the DB to OFfline state..

Now i am...

Thanks lowelll, willl try giving u complete proper info

Hi Anthony,

I have modified the Script, i need one more help in the script

What i have done is if the Script fails for any DB it will entry the record...

Thanks Sure 🙂