if you follow the ideas from Gail and Grant together , you are done .

Is it a cluster ??you are talking about nodes

If yes then SSMS is not cluster aware .you need to install it again on a the other node .

Only Analysis...

use this and let me know .

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=3c856b93-369f-4c6f-9357-c35384179543

2. Can I select the D:\Microsoft SQL Server for Client componets, Integration services and Reporting services OR Do I need to keep the default path C:\program files

Abhay: you can...

If your users also uses Windows OS you should use Windows authentication .SA authentication should used when the connection is coming from Non-windows machines .

If your clients are on windows...

Will try to make things clear here .After going through it in case there are any questions ,please let me know .

a 32 bit machine can only use pointers with...

You got the answer ....:-)

I was thinking it other way sa if you need to add stars to marks ...

But still if you need it i have copied the small...

Give me the table structure ....

Is it a SP or a query :

do some testingon the query .Run it a few times and note the time.

if the 2nd or 3rd run does not run quickly...

since there is no datetype column in the table , there is no other way ...

you need to add that column to your table ...

if you are saying that baseprice1 is Jan and baseprice3 is march then the below query will work :

Your question is still not very clear my friend .Try to write...

agreed with Neal ...also check the table size of all the tables for some more idea :

sp_msforeachtable "sp_spaceused '?'"

Note : this will not show the size of system tables

1) find out the database acting as publishers :

use distribution

go

select distinct publisher_db from dbo.MSarticles;

2) use those databases run sp_helppublication to get the details .

3) you can also use...

its possible ........databases can be different ...

for your second query : its very much possible..

Very busy right now ....wil reply later ...till then do soem research 🙂

use tablediff utility : C:\Program Files\Microsoft SQL Server\90\COM

give source and destination [servername , tablename , databasename]..

simple to use (consult BOL).

make sure that the table has unique/primary key (clustered index)

HTH