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

you'll have to provide the linking criteri that shows that an address in one table belongs to the employee in the other;

and you'll simply use a left outer join to...

I edited my saved snippet to have your values;

change the password and see if this works.

note that for this to work, the client tools have to have been isntalled...

I have no...

yes, if not too much time has passed, you can look at the default trace to see who did any DDL chances(ALTER/CREATE/DROP of objects.

easiest way is via the SSMS GUI,...

Marvin that is so weird; i pasted your command to my SQL2005 instance, and it ran without an error;

maybe it's due to a patch level?

here's my @@version:

Microsoft SQL Server...

touching base on this, as Marvin mentioned trouble with this in another thread. I thought the scripting of the hashed password got him where he wanted to be.

I tested this...

For a default instance, there can be only one. all other additional instances would have to be named instances.

if your current default is 2008, and you HAVE to have a...

hossein what indexes are on the table? the key to performance is having good indexes in place, along with SARG-able WHERE statements(which you seem to have)

The EntityID column name...

On a similar thread, Gail Shaw (Gilamonster) reminded us that linked servers and which procedures are scheduled to start when SQL starts are in master, so they need to be...