Thank you for your nice explanation the reason why i ask this kind of question is that when i used xp_smtp_sendmail it is in dll form and is added as...

when you say object name did you check not only tables but also views and store procedures? Dont know if this will help but you can try it anyway

--CREATE TABLE...

What i think of is to create a login user for that 3rd party database only (depends upon you what they can/can't access) and when they register the server using...

Did you restart the server after you used sp_dropserver and sp_addserver?? because i think the changes will take effect after you've restart the server

sorry for the inconvenience guys there has been a problem posting the script because it outputed in only 1 line please try the script below and message me if its...

Jeff Moden (1/22/2008)

It was a real life coach... I think Karthik can go a long way if he...

Just like human torch said "Flame On!!!!" peace to all :):D

correct me if im wrong if you are running this query:

INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:\Test.xls', 'SELECT * FROM [Sheet1$]')

SELECT * FROM Table1

it means that you need to create test.xls in...

Just be sure there are no scripts, procedures views etc in relation to the old name if you want to rename it because it can cause the script, sp ,views...

Thanks for the response... So thats the only way to trace an alteration in a table??

Actually i made 1 script that will do what i need it is just that the backup to another server is my issue but anyways i can manually do the...

Thanks for the quick replies just thought of making a script that do all the jobs like:

1. backup databases from a server to another server

2. restore databases

3. Create server/database user/log-ins

4....

You can also use sp_makewebtask

exec sp_makewebtask @outputfile = 'C:\mypath\lester.xls',

@query = 'select * from table',

@colheaders =1,

@FixedFont=0,

@resultstitle= 'My Title',--Name...

Thank you very much so dumb to ever think of it hehehehe

Thanks for the responses really this article is great i just adapted the sp_makewebtask and it works perfectly..