it seems to be more of a basic issue rather than microsoft bug....

one idea is basic file is not available/accesible on the target or its a authentication issue...

all i can...

there was an extra double quote....try this

OSQL -l 30 -b -d DCL -S TEST -U dclsql -P test -Q "declare @r INT; execute @r = UPDATE_UNITNAME...

here u go...

declare @test-2 varchar(2000)

set @test-2 = 'dbo.TAccountVendorContact'

DBCC SHOWCONTIG (@test) WITH TABLERESULTS, ALL_INDEXES

both way its fine....though just to avoid any unforseen issues, database blocking....preferable 10gb at once....

try debug the location u r trying to access with xp_cmdshell dir command....

master..xp-xmdshell 'dir '

maybe u need to map a network location before accessing it...if u r not using...

both cluster nodes connects to SAN as central storage....and SAN has to be on one place thus u cant have clustering....if u have SAN on site A and if site...

sorry...w2k3 enterprise is needed

dont worry....windows 2k3 standard supports clustering

in second option batch is not possible.....

BTW....did u tied second statement....it should fail cause all data will go in first row/ first column only....over 8k bites it will fail

ALTER PROCEDURE [dbo].[pr_InventoryList]

@InventoryID

@AcquiredDateLow datetime '20071231'

if @AcquiredDateLow = '20071231'

set @AcquiredDateLow = '%'

Guess this is where u stuck.....

Build new one and configure it as u r expecting it to be, create all settings...

is that problom specific to express edition or u just donno using odbc?

u need to provode what all r&d you have aleady done... try this anyway....

create an odbc connection on prod box to test box using TCPIP, then try this command

try using...

yeap Log-shipping is there in STD edition and the best solutions fro Site A --> B

raid aray configuration tools allows you to select when you are configuring it...i think its ther default value for most of the cases though