Can't see anything wrong with the SQL itself, other than I can't run it since I don't have your tables. I would change your CAST's to use NVARCHAR instead...

Can't help you as long as we can't see what you see. Would help to see the DDL for the procedure in question.

The named instance you connected to is SQL Server 2000. You are Using SQL Server 2008 R2 SSMS to connect. Are there other SQL Servers? Were you...

FutureQueryArtist (6/26/2012)

---

I need to filter all the records that have a ' mark. I tried Where Fieldname like '%[']%' but it returns "Unclosed quotation mark after the character string...

gciszewski (6/26/2012)

---

Thanks for the reply.

Here is what mine say's it is. Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c)...

We will need to see the proc as well. Where exactly are you getting the error?

Couple of questions.

Where are the servers located, are they geographically separated or in the same server room?

Do you have this problem with all of your mirrored databases or just specific...

Kasnut (6/26/2012)

---

I know this topic has been covered, But i have a 284 GB tempdev file and it will not shrink. What is the easiest way to shrink it?...

I'm sorry, what part of "the picture doesn't show everything" don't you undestand? What is there doesn't really tell me...

We really can't answer your question based on what you have posted and we can't see from here what you see there either. When you say the string value...

First, it doesn't show all the fields (columns). Second, doesn't really provide much information other than the witness is involved in several...

Revenant (6/26/2012)

---

Lynn Pettis (6/26/2012)

---

As...

Same password, different username?

Have checked the properites of the login that failed to see if it...

sturner (6/26/2012)

---

"Too bad our government can't collect royalties off patents used to develop commercial products when government monies (taxpayer dollars) paid for it to begin with."

If the royalties they collected...

The beauty of the community!