Once again, check the port that the destination server instance is listening on and make sure it's not blocked by a firewall. Ping'ing the server is not a valid...

What port is the destination SQL Server machine listening on? Make sure it's not being blocked by a host based firewall.

1) You can download and install SSMS express without any licensing problems:

http://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

2) Not sure about this one

3) When you fire up SQL Profiler, it asks for a server...

Do you get the same behavior using the OPENQUERY command?

I'm glad you posted, because I've been researching this very issue and would like more information. Here's what I know, based on lots of research:

1) Yes, you don't have...

SQLBot, you're my new favorite person

🙂

Look for a Maintenance Plan that created a job that removes the .trc files:

Management -> Maintenance Plans

SQL Server Agent -> Jobs

If it is a stored procedure that is doing the...

Tough request, as there's lots of variables here.

Do you know if your SQL Servers are listening on the default port (1433)? Can you get a list of IPs to...

Thanks Jack. Interestingly, the data type for the 'body' field in my 'msdb' database is 'ntext' (based on sp_columns). And, I was able to partially see the data...

As a new SQL Server DBA, make sure to download and install SQL Server Books Online. I opened my version and searched for:

'create job'

'create maintenance plan'

You can use...

Just re-read and saw that it's an Oracle 9 install. Your ORACLE_HOME might be in

c:\orant

Search for the 'sqlplus' binary and tnsnames.ora file there. Obviously, replace the drive...

You can test connectivity by opening a Windows command line and typing 'sqlplus /nolog'. That will start Oracle's version of 'osql', giving you the ability to connect to your...

Thanks for the replies.

G, I'd like to know a little more about both of those sections.

I've seen excerpts of Kalen's book (it does look excellent), but does it relate to...

Clear, but a little open ended, so I'll throw a bunch of info at you. A couple of real basic tools I use are:

Perfmon (installs with Windows)

ProcessExplorer (in the...

Take SQL Server out of the picture and try and run the same query at the command line, using 'sqlplus'. Does it return data? Can you query other...