Viewing 15 posts - 31 through 45 (of 161 total)
'Scuse me for asking, but what rock have y'all been hiding under? 😀
MS, Oracle, IBM, <pick a company> have been doing this for a very long time. This should...
February 17, 2010 at 11:51 am
I'm assuming from your earlier comments that you can't determine the job name or id from the log file? Which version of SQL Server are you using?
February 11, 2010 at 5:59 pm
One thing to consider: Since you're not finding this where you expect (SQL Agent jobs) then perhaps it's somewhere else. Is this a production database or a development system?
As for...
February 10, 2010 at 9:08 am
Two places to look
1) Check your triggers. This error may be a 'side effect' rather than directly in a SQL Agent job
2) Run profiler to see if you can...
February 9, 2010 at 1:39 pm
GilaMonster (11/27/2009)
aureolin (11/27/2009)
You need to balance the storage space necessary for keeping all those backups with how far back you might need to go to find something.
Not just how...
November 27, 2009 at 1:32 pm
One last detail: Make sure you have adequate storage space for all those backups!
You need to balance the storage space necessary for keeping all those backups with how far...
November 27, 2009 at 12:54 pm
FYI, here's a .cmd file by rob kerr[/url] that will set the appropriate ports for the SQL Server services.
------ begin file ------
[font="Courier New"]@rem firewallconfig.cmd by Rob Kerr
@echo ========= SQL...
October 22, 2009 at 9:21 am
While there are several potential causes, the resulting error is most likely incorrect SQL being sent to your server. Profiler should be able to confirm this, and may give you...
May 27, 2009 at 10:04 am
Where did you create the user DomainAdministrator? In Active Directory, on the server, in Sql Server? It makes a difference...
May 13, 2009 at 9:26 am
In an emergency you must remember to panic!!
Well, not really, but people who *are* panicking often get really angry at your failure to panic along with them. They see...
April 2, 2009 at 10:00 am
We use Tivoli backup at my workplace and we started out doing SQL Server backups using the Tivoli utilities to back up the databases directly (much like you're asking about...
January 1, 2009 at 10:09 am
Check out this article on msdn for a discussion of connection options for a web server connecting to a database server.
Steve G.
January 1, 2009 at 9:46 am
One last(?) question: Do any of the UDFs use the CLR? I dimly recall there being memory leak problems with the CLR in SQL 2005.
November 26, 2008 at 12:07 pm
One more interesting detail... I tried this on SQL 2008, and it works as you described, but with a twist. Each time the procedure runs, it produces a single row...
November 25, 2008 at 12:35 pm
Now, there's a conversation killer....
... or maybe I'm just a @#$^*(.
Ya think? :blink:
September 30, 2008 at 9:40 am
Viewing 15 posts - 31 through 45 (of 161 total)