Would a SELECT of the original tables using just the required columns help? or it wouldn't make any significant improvement?

Or maybe a view limiting the rows I need before I...

That would be a problem with Windows or domain permissions.

Try to connect to that server outside of SQL, if someone else is in charge of that, you should contact him.

emmanuel.constant (8/1/2012)

---

Luis Cazares (7/31/2012)

---

In the part where it asks

Which SQL Server do you want to connect to?

Server:

Just put the IP Address and port. Example:

192.168.0.1,1433

If it works, that might be...

I'm really proud of me because instead of running the query, I went to SQL help to find out what where the 4 and 7 in the datetime2 declaration.

I've learned...

I'm not sure, but I believe your original problem was on:

SET @ParamDefinition = '@counter_txt'

As it should be

SET @ParamDefinition = '@counter_txt as NVarchar(2)'

Just for general knowledge, as it seems that you'll...

That's because those Stored Procedures weren't created due to errors in the code.

For those you must use CREATE instead of ALTER.

The other option, would be to use CREATE on all...

In the part where it asks

Which SQL Server do you want to connect to?

Server:

Just put the IP Address and port. Example:

192.168.0.1,1433

If it works, that might be some problem with...

Why are you trying to create an ODBC connection?

Are you trying to connect to SQL Server Management Studio?

Are you using a prompt window like this?

Or are you trying to create...

Instead of using ServerName\InstanceName

Use IPAddress,port

Example: 192.168.0.1,1433

Have you tried connecting using the IP address and port instead of the server name?

That happened in a company I used to work.

Are you kidding? a DELETE with no WHERE? :blink:

Is that the version...

I never read the "choose 5" instruction until I saw your...

Lynn Pettis (7/30/2012)

---

Luis Cazares (7/30/2012)

---

What's your point Lynn? The last two values use datalength on unicode strings and is normal to give the same output.

Am I missing something? Have you...

What's your point Lynn? The last two values use datalength on unicode strings and is normal to give the same output.

Am I missing something? Have you slept well lately?