I guess, we may not be able to connect to the servers which are not in our network. you may have to RDP into them ... This is what I...

select is_published,is_subscribed ,* From sys.databases

DECLARE @SageDataBase NVARCHAR(60);

SELECT @SageDataBase = ACSODBC

FROM tblCompany...

Thank you very much for all your inputs. We successfully migrated to new domain with out any issues. After seeing the responses, I just backedup all my dbs, scripted logins...

Thank You. That makes sense.

Where are you getting tex.BoatID from?? which table is it in?? you should alias some table with tex, the error message says there is no column with tex.BoatID.

Hi , Did you ever get answer for this? I am trying to find out some information about this keep alive property in SQL server. basically, I want to disable...

does

sp_help tablename

help you??

for me

select convert(datetime,convert(char,getdate(),100)) it worked perfect.I just don't want seconds and msecs.

Awesome...Thank you for the very quick post.

Thanks eveyone for your replies...It worked with the 2 single quotes

Thank you Matt...

Its my dream to work at Microsoft....I would love it.

The other option you may have to check is, make sure that port 25 is enabled...sometimes the antivirus may disable this port...

Open the replication monitor, click on the publication in the left window and go to the agents tab where you will find all the 3 agents. you can right click...

you may have to check maximum size settings for the database !!