That tripped me up once too,

Sys.server_triggers is the view for database or server triggers. Sys.triggers is only those 8n views or tables

Well, I need to unsubscribe from "the thread" aka are the posted questions getting worse because I landed a new job and have to check personal email via...

Doesnt the bolfor cdc specifically mention something about columns of type text and maybe image are nnot updated but are deleted and inserted? Does the thanle in question have...

Ed i agree. Ive used ultraedit and my current favorite is EditPlus. I knew notepad++ was free, so i suggested that over something the OP might have to trialware.

no, you should say "Because @@rowcount is affected by any commands in the session, it's my practice to re-select from the table in case there was a trigger that might...

also, sp_oa methods can only return 4000 nchars at a time, so your method needs to loop until the responses are complete, and return a nvarchar(max); you probably alreayd have...

i've seen that a few times, that nul character is CHAR(0), and a great example of why you need a little better text editor; plain old windows notepad won't show...

WinMerge, which is free, can compare folders vs folders or files vs files, and identifiy differences:

http://winmerge.org/

will that do what you want?

i've done this two different ways via a CLR; one that uses System.Forms, and another that calls a web service that does the same thing, basically;

there are some regular expresisons...

well in general, "particular column does not a character" would mean a NOT LIKE '%X%' pr PATINDEX =0, right?, so that would requre a table scan of all rows, so...

very very useful for me, indeed. great job.

I might remember a post i saw two weeks ago,and want to find it;

now with the Relevant First, it's muche easier to page...

open the file up in an enhanced text editor like NotePad++;

you'll be able to see what the row terminator actually is.

i think \r maps to CHAR(10), and \n is...

just like the repair for any other item that was installed with windows insaller:

reviews any dll's , exe's or ocx's, as well as files for differences in the saved .msi...

my best guess; not sure what you expect on the last record, it doesn't seem to follow the right pattern, but at elast with a framework like this, oyu could...

Ashwin M N (8/2/2013)

---

I have to replace XX database from backup in production. The third party tool and reporting services have been configure to database id so I want to...