Yes, Agree with your CSS... but it is very strange that it does work with SQL 2005 but 2008R2 giving me hickups....

I will continue to do further investigation and let...

Interesting,,Never thought about that way shrinking log and mdf.

Let me work around and see what i can accomplish by going into that direction....

About ETL, Yes, it can build but since there are lots of tables used by web app and synonyms from other dbs, so, it was decided that we do total...

Hi SCC

Here is my step

-- Step 1 - Shrink & Backup

DBCC SHRINKDATABASE ('MyTestDb', TRUNCATEONLY);

GO

...

Hi Perry - sorry for the confusion but I miss worded when I mention prod vs. dev..

Actually, on our database production server we have nightly job that calculate data...

Hi Stobe,

Thanks for the detail, It work just what I was looking for.

Thanks.

Thanks guy for the update.

@UMG - It is 2008 R2(RTM) - 10.50.1600.1 SP1

@Modesty... - They way our DW structure is to use perm table than temp and there are lot...

Hi Guys, thanks for your reply and here is my thought:

@Ashish - My job contains 10 steps and each steps are stored procedures and there is no application connect to...

Thanks stewartc

This going to be very handy..

Thank You,

Found my Solution. Here is my final Script...have a fun..

Resolution: Need to add IN clause with my length when i look for Modifer2,3,4.

Drop Table #myProc

create table #myProc

(

id int identity(1,1),

procedure_code varchar(20)

)

insert...

WayneS - It are correct, My sp runs daily but at some point there db goes off line and do not have connection but as soon as connection open for...

Lowell -you are correct, i was asking for BCP but somehow i miss type to xp_cmdshell.

Thanks for the detail i will have to save it to safe location

THanks...

Lowell - dang...you are the MAAANNN...this is great... It worked.

I was looking at the detail on website what are the option we have with xp_cmdshell like -t -u -p but...

Lowell - Awesome it did work for me but I hate to say that i need to have this as comma delaminated file ","

How would I do that with supplying...

Lowell - this is a nice script. It gave me output as "nt authrity\system"

Since, I am new to BCP untility, i am tring to find out how to supply username...