hdillow (10/18/2013)

---

Hello, if you were to remove the dlls from an installation directory, what happens if the SQL Server Instance is restarted or the cluster fails over to another node?...

more details from you before we can help, i think.

you really need to analyze the trigger itself, and fix the issue;

for example, if there is a trigger on a...

Select from sys.triggers and sys.server_triggers. based on the brief description you gave plus the fact the.name contains "nested " you might have a trigger that blocks itself as well as...

here's the first actual code example i found:

http://www.codeproject.com/Articles/13391/Using-IFilter-in-C

along the lines of what Erland was suggesting, i think i'd simply add a column that will hold the extracted text from the...

I suspect the core issue is that everyone logged in has sysadmin or dbo priviledges and instead of fixing that as gail implied with proper security, you are looking...

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...