sidenote to get a count much faster than select count(*) :

DBCC UPDATEUSAGE (0) WITH COUNT_ROWS, NO_INFOMSGS

SELECT OBJECT_NAME(ID) AS TableName, [Rows]

FROM dbo.SysIndexes

WHERE...

from what i read here:http://www.oracle-base.com/articles/8i/TemporaryTables.php

an oracle global temporary table seems to be the same as a regualr sql temp table...it is created for the user who connected, is not accessible...

well first, why a global temp table if you want to select justthe stuff your user inserted? why would a private temp table not do the trick?

but to answer your...

I've done something similar in my own stored proc; give it a test drive, I use it for some different processes for auditing and stuff; just a handy way to...

two links in my signature for CREATE TABLE and INSERT INTO will do exactly what you want, but in TSQL vs an external process:

sp_GetDDL takes a tablename, or optionally schema.tablename,...

since you need to know the values to pivot in order to pivot, you can't do it dynamically, but you can alias the values.

but you can certainly alias them like...

well, the quick and easy fix would be to alias from the final select instead of using select *

SELECT

CODE_GESTIONNAIRE

[20100009] As S_20100009,

[210100010]...

i thought the dependancy issue was only (potentially) inaccurate only...

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