If you have to have the single quote stored in the database then you need to put it in twice.

EG: don't becomes don''t

You could also play around with SET QUOTED_IDENTIFIER,...

As the error is "Error converting data type varchar to datetime" and I can't see anywhere in your code where you're mixing varchar and datetime vars, I'd have to say...

The two main points against dynamic SQL are,

1. Performance - this procedure would be going through constant recompiles while the Query Optimizer works out which tables it's dealing with and...

What account do you use for the services? If you're using a domain account and you have networking issues, the SQL startup can be impeded while the security credentials are...

The purpose of having the MSX/TSX server setup is to avoid the "on-the-fly" changes that can introduce errors becuase they're not fully tested. It also provides a single view for...

Well he got you there susi, or should it be sushi

If you were a bit more specific on what you're looking for I could probably provide more specific links for you.

Maintain the versions in something like Sourcesafe, not in SQL Server. Although the package designer does create different versions there is not facility to rollback changes, or as you've found...

pvv praveen kumar, sorry if you see it as a funny thing, but many people say that SQLServerCentral.com is the best resource...

Ok I'm confused ... I thought I included an example ... did you see that part highlighted in blue?

Maybe if you provide an example of the strings you're trying to...

Hmmm ... I thought it was very clear given your original post ...

What part wasn't clear?

Best method is to use a case sensitive collation

SELECT * FROM ::fn_helpcollations()

Will show you the different collations that are available.

Otherwise you'd be stuck with using something like the ASCII...

Do you have your own domain setup at home, or are you just in a workgroup?

If you're using a workgroup then make sure you haven't specified "Windows Only" for the...

Take a look at RESTORE VERIFYONLY in Books Online.

Here's another

http://www.sqlservercentral.com/