Jason,

Thanks for the article, good job!

😉

sree-879715 (6/22/2010)

---

Thank you for your reply !!

I was able to start the named instance but now I am not able to alter the login name

I mean I getting error while...

You can start a name instance from command prompt like this:

net start <InstanceName>

Seems very nice book for DBAs. Thanks for the notice!

Jeff Moden (6/3/2010)

---

Steve Jones - Editor (6/1/2010)

---

There are quite a few people here with Oracle skills, including Jeff. I'm not sure Jeff wants to help with Oracle, but worth a...

Or you can use the Grant Select command:

USE sqlbox

GO

GRANT SELECT ON sqlbox TO sam

GO

Yep, very cool ...! :hehe::hehe:

Read many books or e-books as many as you can read & learn things that is related to the relevant technology, so for the certs about SQL Server 2005 read...

Try to put the remote login and password on Security tab, in the section below like in the attached jpf file...seems problem with your login settings!

Ok did you check to the services area ...Control Panel > Administrative Tools > Services then search for the SQL Server Browser service!?

If you find there you should start it,...

What are you trying to do with this replacement!? It hasn't logic to do like that, how many records do you have in both tables what is the right purpose...

Ok! It is impossible if you have SQL Server Express edition and no SQL Server Browser ... !!!

Ok! In your machine where you are connected remotely try to find the...

homebrew01 (4/30/2010)

---

I'm remotely logged onto the server itself. There is no browser service. The only services related to SQL are:

SQL Server VSS Writer.

I don't know how this was setup ......

Ok! Are you trying to connect in local machine or remote machine !?

While you have same problem seems that you are trying to connect in remote machine so take a...

If your installation is default way & if you work in your local machine(PC) you can try also like :

.\sqlexpress OR

(local)\sqlexpress

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