here's a do it yourself way.

it just a cursor that goes thru the results of a temp table populated by the procedure sp_msdependencies

maybe this will help:

SET NOCOUNT...

it's getting truncated because there is ANOTHER setting to limit the results to 256 chars by fdefault:

go here and change the value to 8000:

when in gridview in SSMS (Control D) the CrLf appear to be supressed. but if you switch to text vie (Control T) and rerun your statement, the CrLf's will be...

for a scripted login, this will probably help.

the remote user and the remote password IS the Oracle username and password you want..SCOTT/Tiger in our previous examples:

--#################################################################################################

--Linked server Syntax for Oracle...

in (@statuslist))

i think that is your problem; that is the same as saying in 'A single string that happens to have a comma in it')

which is not what you were...

ouch that sysindexes is handy and i haven't found any view that still tracks that [rows] and [rowmodctr] yet.

GilaMonster (10/5/2009)

---

Just bear in mind that sysindexes is deprecated, will be...

could it be schema related, i mean that there are two schemas, say dbo. and bob. with both containing a view named "vw_bobtest

", and because the objects are not two...

the problem is SQL uses a hard 20% rule to determine if statistics are auto-updated or not;on a million row+ table, that's not often enough

here's a work in progress i...

a better example: in Oracle in whatever database, you might add a new user "SQLPassThru", and give that user access to 3 specific tables, and nothing else.

that Oracle user would...

newbieuser (10/3/2009)

---

Thank you so much Lowell.

Is linked server, the only option to access Oracle database from SQL server stored Procedure? Is linked server, basically like a database object...

pretty sure a db link is an Oracle-to-SQL server ODBC connection.(well to many other db systems, but say SQL for now)

a linked server is the equivalent: a SQL-to-Oracle ODBC Connection.(SQL...

there's a great article here on SSC on creating a google like full text search[/url], which does everything you are asking and more; I'd suggest going that way first, as...

i have this "SCRIPT ALL INDEXES with Include" saved in my snippets, and supposedly it will also do the INCLUDE syntax, if it was used. I haven't fully tested it...

interesting, what does this return:

SELECT substring(name,1,8)as name,id,xtype,uid,user_name(uid),suser_name(uid) FROM sysobjects WHERE [name] LIKE 'table%'

there might be an easier way, but this is what i've been using:

i've got one database with three schemas "dev", "qa" and "dbo"

using this gets me all the tables,procs, etc....