Here's my setup:

My PC is in domain 'A'

Primary SQL Server is in domain 'B'

Linked SQL Server is in domain 'C'

Domain C does not have any local logins, it has a...

Hmm, had the DBA over, we added my username as a SQL Server login, and also as a Windows Authentication/trusted username...nothing works.

Funny thing is, I DID specify my username and password, but apparently I don't have the SQL username and password created. Hopefully it's just that easy. I know ALL of...

Thanks Lowell, I'm getting closer.

Tried running it without the login and it told me the login failed, or something like that. So I then ran the login part and now...

Another question related to my problem...

I'm trying to join 2 tables, 1 table the field I want is defined as a varchar and I want to join it to the...

Thanks Lutz.

I'm guessing the 1e0 is scientific notation, but what's the 1d0?

Ok, I forgot about the ISNUMERIC function, but let's say that didn't exist...

Great! Thanks again for another set-based solution for me, Lutz!

Had a 40 minute window to run it in this morning before "business hours" and it didn't finish so I had to kill it. Will try again at my next...

lmu92 (6/7/2010)

---

gregory.anderson (6/7/2010)

---

Funny you just asked, Lutz. Had the conversion on Saturday. Ran in 1:48. Then entire process KILLED my previous times since I was running on some really beefy...

Funny you just asked, Lutz. Had the conversion on Saturday. Ran in 1:48. Then entire process KILLED my previous times since I was running on some really beefy servers. What...

Hi Vladen, thanks for the reply.

The tables are in different databases, but the same SQL Server Instance. There is an "Archive" database, and also an "IADS" database. I am moving...

It is still required because not ALL of the records are getting converted. There were some where...

Woops, sorry about that...

Ran in 1:55 on first try.

Here are the timings:

SQL Server Execution Times:

CPU time = 0 ms, elapsed time = 1 ms.

SQL Server Execution Times:

...