try to register the new sql server from any other sql server. Are you still getting the same error? If not then the problem is with account which you configured...

havent tried with oracle but I use linked server quiet often between sql server and other microsoft product(like excel).

I think for oracle you just need to mention the correct...

I never suggested to use the query in hint...I was just giving explnation on the use.

And like you also mentioned, he need to familarise with the term first before use.

thats why I suggest you to have a look of the use of the system database in sql server.

For example .. if you loose msdb, you will loose all jobs....

You must give priority to system database(specially master/model/msdb/resource/distribution(if applicable)) and then user database.

I will suggest please read...

urmarke (10/22/2010)

Select fielda,fieldb,fieldc from TbleA inner join TblB on TbleA.FieldX = TbleB.FieldY where ...

My question is on indexes. Do indexes include the filter part ie. the where clause or just...

its because if your OS get corrupt and you not able to get hold of your C drive.

you need permission to run xp_cmdshell, if id not belongs to sysadmin then provide grant permission on that id and add that user in master as well

what is your query?

Also go in ssms--serverobjects--linked server--expand your linked server cataloges.

Are you able to see the database and tables in expansion, if so then right click on table...

the problem is with linked server which you are using in your query. Check either linked server working properly or not.

-- I am assuming that format to extract mail id will be always like ' to mailid....'

--so scripted accordingly

declare @start2 int

declare @start3 varchar(100)

declare @start4 int

set @mail= 'I want write...

Gail, Why cant he shrink the file(log)?

But will help if its not.

If the log chain is broken after shrinking the log.

Have a look of

http://support.microsoft.com/kb/873235

saying

Important After you manually...

using SSMS-- right click on database--tasks--shrink--files--select the file type as log and shrink.

Make sure you take the fresh full backup after this activity, if you taking regular log backup.

SELECT a.agentid,c.restid,c.plancode

from #a1 a, #c1 c

where c.restid not in (select restid from #b1)