Hi Simon

It entirely depends upon the table purpose 😀

Hi Santosh

As every one suggested, you cant shrink log if this is in ful recover mode( can but...

Which version of SQL are u using??

For 2005 you can use Performance Dashboard, I have tried Idera SQL Check, there is a free version, i am not sure that this will work for 2000, please give...

Hi Koltas

I used to have this situation earlier in my work , when we migrated, we migrated the...

Thanks Guys, I have no Indexes, its a Heap table, As i said i tried to Clean the table using DBCC CleanTable Command, this took me lots of log space,...

think that this problem has been faced only when you drop the table column, SQL reuses the space without releasing this, not sure about null's

🙂

are u looking for a third party tool ???

yes i tried, but it dint work, i also tried to shrink files, i dint work either, i read some where about DBCC Cleartable, i am reading about that, not...

Ops Steve, thats my mistake, that explains to it self that it is a computer name, 😀

Thanks Adi, i have the same doubt, i might be wrong, wondering if there is any ways on 2005 to do this

🙂

Are you using 2005, this is a intresting question, i am wondering that there will be some DMV's on 2005, if you are using a performance dashboard then you can...

You can use the Import and Export wizard for this purpose, it does BCP and back end, is this a on off job , or a regular job, whats the...

Enable triggers and use Host_Name () function if you are using a Domain login, or use trace to get the login, if this is what you are looking for

🙂

Thanks Guys, I am looking forward to change to 2008, next year, I will make this as 2 statements for time being .

Thanks for all the posts

Cheers

🙂