what that infrastructure would look like? multiple sql server instances? how do you synchronize them?

I am concerned with changes to table strcuture.. for example removing columns, changing data types. I am not talking about data or rows.

I am concerned with change to the underlying...

Well clustering only allows you a passage to the SQL data files which sit on shared drive.

how do you make changes to the database structure while its being used by...

i think sql 2008 had the capability to wall off any users including dbas from being able to see the data in the database.

Ok will go ahead and run this:

DBCC SHRINKFILE (<FileName>, <TargetSize>) WITH NO_INFOMSGS

lets see what happens..

will shrink not mess up the log shipping configuration?

I dont have any replication setup.

And 99% of the space in the transaction log file is free. But how do I reclaim it without messing up log shipping?

yuppp.... thats what happened

trace files dont go back to last week when the changed happened. any other place I look?

I am trying to open available .trc files but get access denied error. Not sure why that is.

DBCC CHECKDB WITH ALL_ERRORMSGS, NO_INFOMSGS

comes back with nothing. and all it says is

Command(s) completed successfully.

I tried the following but not luck

declare @str1 varchar(1000)

set @str1 = '"C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTexec.exe"'

set @str1 = @str1 + ' /f S:\Microsoft SQL Server\MSSQL.1\MSSQL\JOBS\Locations\Main.dtsx'

print @str1

exec master..xp_cmdshell @str1

still cant figure it...

Tim

Thanks for responding.. can you give me a little more detail on how would I accomplish this in script component.

thanks

works like a charm.. thanks

interesting approach.. i will give this a shot. thanks