definately interview question.... 🙂

but as per my thoughts :-

1) unattended itself clearify the setup which left in between

2) to build 1000 server, you can restore the image of working server

http://www.sqlservercentral.com/articles/Database+Administration/62480/

when you saying connecting to server local, is that mean thats what you mentiong while connecting. Try to change it to actual servername istead of local.

i am able to get the result from both way using exec tablevariabletest(your sp)

There is no clustered index on the table and I need to create one, will fill factor 0.

How will this impact space utilization on disk? What about white space...

unfortunately I dont have 2000.

but once you open query analyser and on your left if you open object browser, you will be able to do whatever I already suggested...

it means you know how to do it in 2005/2008. Why not use that database in SSMS instead of EM.

In EM, you can try this :-

1) Right Click on table...

I am learning new things on Stock market trading....which is totally different of IT but interested.

I like it because it need the deep analysis like DBA work and if...

do you have any other small database for test?

just for test, can you try this:-

backup source database

resotre on destination.

configure distributor on both if its merge,peer-to-peer or transactional replication.

then configure publisher...

i will suggest insetead of shrinking the log, change the DB to simple recovery.

are you not getting it in result pane?

What I mean was if there are any indexes on your table or not. If its then how much fremented they are?

Update stats I mean how much...

what i can assume is, you restored the backup after replication configuration(if this is not the case then dont read further).

Can you try to restore some old backup of...

depends on latency you configured and the way confliction will handled.

where DELIVERY_date=( GETDATE()-1)

*

DOES NOT return any data...I'd appreciate your help very much. Thanks in advance.[/quote]

because your delivery_date is not the datetime type. Can you confirm this?