Hi All

Thanks so much for all your input. I appreciate it. It's working fine now.

THANK YOU

Anche

Hi All

Thanks for ALL your responses, REALLY helped alot...

I get the following error:

Procedure prc_Performance_proc has no parameters and arguments were supplied...

The Code for prc_Performance_proc:

Hi, me again...

Is there a script that shows you how long a job has been running?

Thanks

A

Hi

Thank you all for your responses. Much appreciated...

Anchelin

Hi thanks for your response...

But the servers are not on the same network... server on network A and server on network B...so I can't do the Import\Export wizard...

Or can I do...

Hi All

Thanks for all your input... I altered my table and everything seems to be fine now.

How can I ever repay you guys?

Thanks again...

Anchelin

Hi All, thanks for all your replies!!

See code below:

Hi Mohammed

Thanks for all your input much apprecited. I have another question though, I run the following script to see if SQL Agent running:

if exists ( select * from master.dbo.sysprocesses...

Thanks Mohammed

I didn't even see that one (duh Anchelin), I think it was a case of I saw it there but not really.

Again...

Hi

I'm a newbie in SQl server so the last 3 points doesnt ring a bell. the first 4 i did.

Help PLEASE!?

THANK YOU Mohammed

MUCH APPRECIATED!!!!

Anchelin

Hi

Yes, but I want to know if there is a way to see the current run time of a job while it is executing. Like if I start the job...

Hi

Thank you very much!!!Exactly what I needed. Again;THANKS!!!:

Hi Nali

I need to see the status of Agent within SQLServer for a current server.

Anchelin

Hi Mohammed

When I open SQL Server 2005 Surface Area Configuration; and click on the Surface Area Configuration for Features; it gives me that error.

Any idea??

Anchelin