You might use this to find the words to replace.

CREATE PROCEDURE [dbo].[FindWordsInaSP_5K]

@Watchword varchar(50)

AS

SELECT distinct

'type' = case type

when 'FN' then 'Scalar function'

...

Hugo Kornelis (5/16/2012)

---

Thomas Abraham (5/16/2012)

---

Hugo Kornelis (5/16/2012)The only way I can reproduce what you are seeing, both on SQL Server 2008 R2 (I don't have 2008 vanilla) and on SQL...

Hugo Kornelis (5/16/2012)

---

Nice question. I knew about implicit transaction, but I had to do some digging because I couldn't remember if primary key violation errors are batch-aborting or not.

(One possible...

jasona.work

Not as intensive as the annual PASS meeting, but I have found (local pass chapters) which typically meet once per month, to be a good source of information,...

All ye All ye, Now hear this

How about commenting on opc.three's post to encourage / discourage him in writing a spackle article:

http://www.sqlservercentral.com/Forums/Topic1298803-1292-2.aspx#bm1299757

opc.three (5/14/2012)

---

bitbucket-25253 (5/12/2012)

---

opc.three (5/11/2012)

---

I do not, but I would be happy to mock up some test data and run some...

To help you, and to assist those who wish to help you with a tested answer, please, please post table definitions, some sample data for each table, and the required...

Comment removed did not fully read the title to this posting .....

which is Msg 1828, Level 16, State 5, Line 1 The logical file name "address" is already in use....

I think you should read the following:

http://msdn.microsoft.com/en-us/library/ms143506.aspx

Pay partcular attention to the operating system requierments for SQL 2012

opc.three (5/11/2012)

---

I do not, but I would be happy to mock up some test data and run some tests. I...

Nice way to start the week.

Revenant (5/11/2012)

---

michael vessey (5/11/2012)

---

was i too harsh on this chap??

as for stored procedures - well frankly if your manager doesn't know how to give you permissions to add stored procedures...

Nice question to end the week ....

Nice question ..... and it teaches something additional ... it teaches one to read definitions as well as the T-SQL very, very closely

May you are your family enjoy .....