Details are missing..

In VS2008, are you creating forms or debugging someone's created forms?

Where is the SQL 2005, is it in the same domain,then how are you connecting to it using...

What sort of free training are you looking for?

There are some training videos in this site also, but they are on a topic wise,

and do not follow a traditional...

Hey Sanket !

What Jeff had replied is an apt reply, for such things you gotta search google...

In the Job Step,

Give a Step Name,

Then under type select Transact SQL

Under database choose the database name where the stored proc exists,

Under Command have this code..

EXEC p_test_cmd

Regarding...

Well, I am sorry for the code that I posted in the previous reply, it does not solve the entire problem. I did not see that you need to search...

System DB's

http://msdn.microsoft.com/en-us/library/ms345408.aspx

User DB's

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

I am Clueless !

Try creating the Linked Server from GUI and use the ServerName,Port No..

rsteckly (11/23/2009)

---

Hi,

I'm wondering how you search all the columns of a particular table for a value. We received data that was coded '99999' for all nulls; I need to...

Did you check the protocols that are enabled on your Linked Server?

Is the...

AVB (11/23/2009)

---

Bru,

I'm assuming your not running SQL 2000. Is that correct? I had to edit the proc to run on 2000. You had "master.sys.sysprocesses" I had to change...

You could have posted the list that you have identified, it would be better for us to add / suggest few things which you don't have in your list.

Without...

cclancy (11/23/2009)

---

A coworker said that when you perform a backup on a database (which I do on the hour) that the que is first flushed ( all data retrieval and...

One more suggestion..

Bob Hovious 24601 is the user not...

Best...

Quoting MSDN here

When set to ON, the database is shut down cleanly and its resources are freed after the last user exits. The database...