You must create a user for that login on each database.

https://msdn.microsoft.com/en-us/library/ms173463.aspx

No, you don't need three inserts. You need one insert statement that...

hlsc1983 (3/25/2016)

---

I created a new user with administrator rights in Windows7. I can connect to the server instance , and see the list of dbs but I cannot expand...

In my opinion, you would be better fixing the process that creates the string. Something as simple as changing the delimiter would solve all the headaches.

kocheese (3/25/2016)

---

I realize this database is not normalized, but unfortunately I inherited it when the previous developer left and I was hired to replace him and now I must work...

I missed the duplicate row :pinch:

Maybe something like this:

DECLARE @ProjectType varchar(20) = 'Infrastructure'

, @ProjectSubType varchar(20) = 'ALL'

...

I like Orlando's idea, but here are some other options:

Use a Central Management Server. If you're going to do this manually, you could actually just register the servers in SSMS...

I just realized that you're querying the source table. Change the ASCII function for UNICODE. That should show the difference as shown by Stephanie.

mw112009 (3/24/2016)

---

Luis:

See attached.

I tried "local", "." and my Computer Name.

I think its a right issue. What am I missing here ? What should I tell the help desk folks...

Inspiration

What do you get if you run this query?

WITH

E(n) AS(

SELECT n FROM (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0))E(n)

),

E2(n) AS(

SELECT a.n FROM E a, E b

),

E4(n) AS(

...

mw112009 (3/24/2016)

---

Ed:

I agree, But I do not know how to connect. I mean I know how to open SSMS and then connect to other servers, run sql statements.

In this case...

O2

I can think of 3 possible solutions. The first one is to use a table variable.