While my spanish is EXTREMELY rusty, the good thing is that only the names have changed, not their meaning..

What kind of security are you using? SQL Loging or trusted...

igngua (10/30/2009)

---

Elliott W (10/30/2009)

---

Until you have it all working you might just use the GUI and then trace a session as you recreate it to find out all the commands...

Ian Scarlett (10/30/2009)

---

I realise I've joined this thread a bit late, so may have missed something when skimming through the other replies, but...

The OLE DB provider "SQLNCLI" for linked server...

Let me see if I can go down what we have tried.

1. It is a named instance

2. Using SSMS you can connect to the destination machine from the SQL machine...

When you defined your linked server did you include the instance name? also how did you define your linked server? did you use the SQL Server option, in...

Ok.. Can you go to the machine that you are trying to connect from and see if you can connect to the other server using SSMS. Also, is...

Enter an alias to the server, specify TCP/IP and first try just using its name, if that doesn't work specify its ip address. Either way specify its port.. ...

I'm not a fan of named pipes (anymore).. Using the config manager you want to order TCP above named pipes.. See attached screen print..

CEWII

Tom.Thomson (10/29/2009)

---

The point I was trying to make was that the article appeared to start from the point of view that what was needed was just an efficient 32-bit representation...

Yes, see page one of postings..

We have tested int to string using function and computed column and SQLCLR

We have tested binary(4) to string using function and computed column and SQLCLR

CEWII

Best to steer clear of this guy then and let the city deal with him. But that only highlights a couple of my previous posts.. ...

lmu92 (10/28/2009)

---

If that person takes pictures of parents parking "too long", so what? Afaik such "evidence" cannot be used at court against the person that parked the car.

From my point...

j.a.c (10/28/2009)

---

..snip..

The camera was a recent development and I have a feeling that it is not just for 'security purposes' but to gather more evidence for future complaints to the...

I fully agree with asking, or having the admin at the center ask, prevents you from being directly involved (ie liability, harasment, etc.). Definitely do this.

The underlying problem is...

Off the top of my head I have never seen this accomplished..

But if you have the Crystal libraries installed on the machine with SSIS, I would think you could use...