a sysadmin can't be prevented from access...that's kind of the point of the sysadmin; access to everything.

if people have sysadmin priviledges and shouldn't, then you need to remove them; then...

i would do this from a single machine; make a .NET app that connects to each of the 125 servers, one at a time (or run multi threads)..which reads the...

you can add custom VB.NET code, like functions to your report so you can use them in the report;

for example, go under Reports?ReportProperties and go to Code Tab.

add these two...

i like to think of xml as a table or table variable. since xml is not indexed the...

Declare @cmds Nvarchar(MAX)

Declare @obfoo varbinary(MAX)

Set @cmds = '

PRINT ''This binary string will execute "SELECT * FROM SYS.OBJECTS":''

SELECT * FROM SYS.OBJECTS

'

Set @obfoo = CAST(@cmds as varbinary(MAX))

Select @obfoo

select '

declare @_ as varbinary(max)

set...

good eyes!

i assumed his "DISTINCTROW" was an error and he meant DISTINCT...i should have noticed which forum;

LutzM (8/12/2010)

---

What software is the solution for?

You posted in the ACCESS forum so...

here's my wild guess:

--EDITED/REMOVED, as this is a homework question;

see a second students post at

http://www.sqlservercentral.com/Forums/Topic979463-23-1.aspx#bm979690

i would ignore the joins completely and just use a CASE to evaluate each of the yes/nos instead;

don't really think i need to abstract out a Y/N value to a...

yes, it'll be a bit slow, because you'll have to convert the TEXT field to a varchar(8000);

here's an examplei put together, note how i made a searchterm in a subquery,...

provide to a user ?!?! every varchar/char/nvarchar/nchar column in the database?

unless this is for a developer to fix some code, as already suggested, you really need to use full...

yes that's correct...but it depends on your data as to whether it will be blank or find a value...i assumeed one space between each ite,.

if there are TWO spaces between...

originally you had posted that you had a table dbo.NEWDUNDD_SEACX with a column f1

because you had no CREATE TABLE or INSERT INTO scripts, i created my own table wth...

in Win7 and Vista, security is a little tighter...you don't get added automatically to the instance you are installing. One of the steps during the install is to add yourself...

is it really string manipulation?

if it's a float/decimal, you could subtract the FLOOR() of the value from itself to get the remainder:

declare @val float

set @val = 10.8061111111111

SELECT @val - floor(@val)--returns...

noone answered your post for a long time because you didn't provide the esentials...the CREATE TABLE definitions of your tables.

here is an example, but it's based on wild guesses as...