leaders_j that code snippet you have is really old; i bet it's from 5 years ago.

It's from a project i play with now and then that scripts any table via...

it's much easier to adapt a wheel than it is to re-invent one.

here is a function that takes a decimal and returns it as words in english.

you could easily adapt...

because windows groups can be granted access, and that includes people who potentially never logged into your instance yet, i think you have to query active directory for the...

I'm pasting a tried and true snippet of code that uses sp_OaCreate.

All it is doing is witing to files in the root of the harddrive: c:\header.txt + c:\body.txt c:\results.txt'

etc.

this can...

I am very sure it is not; an indexed view requires, among other things, that all the tables be schemabound...but that doesn't prevent you from creating a view that is...

leo it looks like you have two custom functions;

one is an aggregate function named LAG, and the other is a function which returns a date based on some business rules:...

the piece you seem to be missing is the second part of my example...sp_addlinkedsrvlogin , which adding a link between you/yourlogin and what will be used on the...

you are correct; a schemabound vie can only reference objects in the same database; that jump to the parallel table in the database "fac" is preventing the schemabinding...

also this will really get you what you are after:

select * from all_views where LEFT(view_name,5) = 'USER_'

there's a few suites of views of the objects: ALL_TABLES, DBA_TABLES and USER_TABLES;

i try to stick with USER_tables, which are filtered to the schema you belong to (well the oracle...

I'm under the impression that for a linked server on another domain, you must use a SQL username and password, and not a your domain credentials;

to use your domain credentials,...

html query string does not pass comma delimited lists; if the object (like a select list) has more than one value, it repeats like this:

?bob=one&bob=two

so you need to build your...

for servers on a different domain(assuming you can connect), i've always used this format, which makes the alis for the server different from the connection:

EXEC master.dbo.sp_addlinkedserver @server = N'MyLinkedServer',@srvproduct =...

it's scope; the table exists INSIDE the exec statement, but is destroyed when it comes back to the "outer" scope of code that called the EXEC..

you have to create the...

John USER is a keyword in SQL, can you try wrapping the tablename in brackets or double quotes?

select * from LINKEDNAME...

select * from LINKEDNAME..."USER"

does it work that way?