okbangas (10/21/2011)

---

Quick and dirty "right direction":

You'll have to have some kind of table controlling user info and access. Then you would typically use suser_name() in your query to retrieve the...

In addition to what my friend here psoted, I usually start with this inside an auditing trigger, and add additional columns,...

steveb. (10/21/2011)

---

you can filter on loginname to exclude those ones you dont want.

Though i have to say writing this kind of function into your server could cause issues, ...

i believe the issue is this;

FOR XML PATH('tr'), TYPE)

in that case, TYPE escapes out all the brackets (less than,greaterthan, quotes, etc) that would have been HTML.

FOR XML PATH('tr'))

will leave...

you can use the .NET Frameworks SQLBulkCopy object , and use that to load via bulk copy, but not BULK INSERT command; that requires you to have already organized the...

in C#.Ner or VB.Net, it's built into the Striigs Class

Dim MyArray() As String = AnyStringObject.Split(",")

the coalesce statement is what you are after; it accepts a param array of values(meaning no limit on the number of values to test), and returns the first non-null value

SELECT...

I'd say its a permissions issue, since the bat file works from a command window.

this is a common security misconception/"gotcha". The problem is that when you access any resource OUTSIDE...

you'll have to change the path in two palces;

mine was

C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\TraceFileName'

on my machine, running SQLR2, i think you had a different one; change it and...

--declare variables for parameterizing the command

declare @traceidout int

declare @options ...

Roust_m (10/18/2011)

---

No, I can't do it manually all the time, I need this to be run via an sql job on a regular basis. It looks like Powershell is...

here's anotehr version i just got working as a function;

it's using a Tally table to swap char by char, based on the ascii() code of the character in question: i...

what if more than one bit is true?

SELECT id,'NAME' As Results from YourTable where name=1

UNION

SELECT id,'ADDRESS' As Results from YourTable where address=1

UNION

SELECT id, 'EMAIL' As Results...

i ran mine on SQL 2005/2008; the views may report different results between versions, i guess.

how about ....WHERE name like '_WA_Sys_%'

OK updated yet again...same old links but new code.

sp_GetDDLa_Latest.txt (Returns Table)

sp_GetDDL_Latest.txt (Returns varchar(max) )