i have these saved in my snippets, and the list is really incomplete:

--Oracle sp_help equivilent:

DESCRIBE tablename;

DESC tablename;

--Oracle sp_who equivilent

select osuser, machine, program, status from v$session;

--Oracle kill connection equivilent

select 'ALTER SYSTEM...

I'd start with select * from sys.server_principals

that will give you all the database users, roles, credentials and more;

you could filter it after that on the type_desc column for WHERE...

you want to use a query to generate the commands for you, based ont he metadata.

i just tested this: create user/login [Noobie];

ran the results of the script below.

logged in as...

Rob-350472 (10/26/2010)

---

When attempting to parse a job step in SQL Server Agent: Add Job Step I get an error finding a user defined data type. (Cannot Find Data Type <Type...

awesome idea,...

what a pain; too bad you can't go smack the developers for not adding relationships in the first place....that's so wrong. In some countries, that an offence punishable by cane-ing.

I...

you can also use the metadata to generate the statements you need to run...potentially 300 commands you said.

you did not provide any specific details, so here's a scenario to use...

my suggestions are still the same; show us your execution plan, and tell us how many records you are returning.

for example, if you are returning less than 10 rows, 42...

how...

Adiga's code example should be tweaked just a little bit; if that was run in master(where way to many user tables get accidentally created), you could delete some spt^ tables...

adding the line feed as Wayne described will work...but the results will not be visible in SSMS in gridmode.

because SSMS...

dashboards and scorecards are really close to what you'd intuitively think: reports that provide more of an "at a glance" indicator as to how something is doing(your SQL server, your...

apat (10/25/2010)

---

How do I check that oracle client tools are installed on server or not? I am not using sqlplus. After creating a linked server, I'll just use openquery to...

the oracle Client tools ARE installed on the server, right? you did successfully connect from the server's desktop via SQLPlus, right?

after that, AFAIK, there's three typical reasons for error 7303;...

reliably? you cannot. to join data from two tables, there must be a join criteria of some kind.

if you have 5 employees in one table, how do you know which...