Hi GT,

I am new to SQL server.. I check my login under LoginProperties --> Server Roles --> here i have everysingle roles assigned it to me. ( i guess than...

Hi Matt,

Yes, you are correct they both are on different DNS. So, what are the option i have here?

Please advice,

Muthukumaran,

Here are the errors that i have received so far.

Error # 1

Message

Executed as user: NT AUTHORITY\SYSTEM. Login failed for user 'MySystem_NT\ServerB$'. [SQLSTATE 28000] (Error 18456). The step failed.

Then I...

Bhuvnesh,

You mean in Job Property --> Steps --> Edit --> Advanced --> Run as User. At this screen I have following user

[dbo],

[gues],

[INFORMATION_SCHEMA],

[NT_AUTHORITY\NETWORK_SERVICE],

[NT AUTHORITY\SYSTEM],

[SERVER_B\SQLserver2005MSFTEUUser$SERVER_B$MSSQLSERVER],

[sys]

I have tried to select every...

Does your problem Resolved?

I am having same issue where I have READ-ONLY access to my REMOTE Server. I have SP which call several table from remote server. When I run...

Jack - Thanks but I found my way around. Cool..Appriciated.

Jack - I will bother you last time.

Question - Does SQL 05 allow Temp (##) table when you create Trigger?

Please advice,

Is is possible to add INSERT INTO statement Before/After SEND_Mail to get updated ROW into audit table like who updated their reocords??

Please advice,

Thanks budy..just asked Admin and received whole db.bak.

Cool..

Thanks.

Thank You all for giving me your feed back.

I have used Powell option and it did work for me very smooth.

Again, Thank you all for helping me...

Chris - It is DTS pkg that extract data from db. Yes, It is a DBA role and table might contain row between 20 - 1500. It is once a...

Christopher,

Its very nice query but here is my issue which is little bit different than above,

I am having same issue on SQL 03 where I can not use Row_Number()

What I...

Guys..this is great.

First of all thank you very much to arr.nagaraj. I followed your instruction and SP_Start_Job did work with my two box.

Here is the step:

Created last step...

Guys this is great feed back.

Here is my action plan.

I will try to follow nagarajan instruction where I will use sp_start_job by using link server to kick off...

Alright so let me see if I understood correctly,

When my schedule SP runs on Server A at the successful there should be a script that update a table. Lets call...