Viewing 15 posts - 781 through 795 (of 822 total)
Did it run as your user (the user you're logged in as)? Seems whenever I created T-SQL jobs, it uses my credentials.
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
February 26, 2010 at 5:37 pm
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...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
February 26, 2010 at 9:34 am
What port is the destination SQL Server machine listening on? Make sure it's not being blocked by a host based firewall.
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
February 25, 2010 at 9:28 am
1) You can download and install SSMS express without any licensing problems:
2) Not sure about this one
3) When you fire up SQL Profiler, it asks for a server to connect...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
February 24, 2010 at 2:25 pm
Do you get the same behavior using the OPENQUERY command?
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
February 24, 2010 at 10:37 am
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...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
February 18, 2010 at 9:46 am
oh yeah and
"Mark it zero, Dude."
Craig Outcalt
SQLBot, you're my new favorite person
🙂
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
February 16, 2010 at 10:06 am
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...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
February 8, 2010 at 4:37 pm
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...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
January 29, 2010 at 9:47 am
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...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
January 29, 2010 at 8:50 am
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...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
January 19, 2010 at 9:57 am
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...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
December 7, 2009 at 2:53 pm
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...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
December 7, 2009 at 2:49 pm
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...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
December 4, 2009 at 12:46 pm
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...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
December 1, 2009 at 10:41 am
Viewing 15 posts - 781 through 795 (of 822 total)