ok, now it sounds like they added a custom data type; no big deal, but a bit harder to figure out.

In SQL, you can declare your own datatype, and decide...

every carrier has support for...

it's not possible. SQL Server will only run on a Windows operating system. so you can access and use a sql server from unix, but it cannot be hosted on...

Jeff run this command:

EXEC sp_help gl_text

a lot of results weill come up, but towards the bottom you should find all the foreign kesy in the table...scroll right...

servername\instancename is resolved by the WINS service and the SQL browser. that's not exposed to the WAN, just TCP/IP addresses.

since you are using a firewall to the outside world, you...

whenever you upgrade a system, or restore a database to a higher version, as i understand it the statistics used to get the database may be mis-interpreted by the newer,higher...

well lets try an example;

I invite everyone to build off this example and offer better suggestions.

lets say YourDomain\bob and YourDomain\tom are users who currently are in the builtin\Administrators group, have...

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