It's also important to note that quite a bit of damage can be caused if this check is not done.

Imagine the following situation where we have dynamic sql:

'select count(*) from...

Instead of using replace, you could use the function QUOTENAME() which does the same thing and is built into SQL Server.

select QUOTENAME('Frank''s Garage')

returns:

[Frank's Garage]

quote:

---

I have several production lines, and I want to use only 1 script. This generates temp tables, which are unique for each...

quote:

---

Merge replication requires that the tables must have a ROW GUID, see "How Merge Replication Works" in SQL Books Online for more...

quote:

---

I use the method of finding the job and then running it. Works pretty good. Drawback to using the exe's is that...