Here are some good related fixes... are you getting that error for your Principal server (I assume so, since I believe 5022 is the default port...).

http://blog.sqlauthority.com/2010/01/11/the-server-network-address-tcpsqlserver5023-can-not-be-reached-or-does-not-exist-check-the-network-address-name-and-that-the-ports-for-the-local-and-remote-endpoints-are-operational-microso/[/url]

http://blog.sqlauthority.com/2007/04/22/sql-server-fix-error-1418-microsoft-sql-server-the-server-network-address-can-not-be-reached-or-does-not-exist-check-the-network-address-name-and-reissue-the-command/[/url]

Is the Windows Firewall turned on for the client?

Have you ruled out any network issues? Can you ping the server's IP address from the 64-bit client?

You could use 2 queries with a UNION. First write the query for the 'USA' results, then UNION it with a second query that has criteria excluding the 'USA'...

I like yours better 🙂

tshad (6/6/2011)

---

I did find a problem when the schema was blank.

If @tablename = 'Roles', this will return nothing. I thought about using a Case statement but not sure how...

opc.three (6/6/2011)

---

Red flags everywhere :exclamation:

It sounds like you're headed into dynamic-sql-hell :sick:

Are you confident in your design? If not, if you want to share a bit more about what you're...

tshad (6/6/2011)

---

The reason I am asking is that I am using the following query:

SELECT @IsIdentity = sys.columns.is_identity

FROM sys.columns

JOIN sys.objects

...

Not really sure what you are asking. If you do not specify the server, database, or schema parts of an object's 4-part identifier, SQL Server will use the defaults....

I answered him; what have you done? 😉

Hi, if you haven't found the answer yet, it was addressed here: http://www.sqlservercentral.com/Forums/Topic493874-146-1.aspx

The default 'Unrestricted' log size IS 2TB in SQL Server 2005.

Pink123 (2/24/2011)

---

I dont think there is any problem in the logic because there is a similar job which exceutes fine .The one i mentioned in my previous post is the...

Then it sounds like...

Pink123 (2/24/2011)

---

There are no records for select as my query uses

if exist() for job B

If I seperately execute the query I do get results?

I am very confused as...

That scenario won't cause deadlocking or any other issue, AFAIK. READ COMMITTED is the default isolation level in SQL Server, which will only allow reads on committed records -...