Forum Replies Created

Viewing 15 posts - 421 through 435 (of 471 total)

  • RE: CAN SOMEONE EXPLAIN TLOG MECHANICS (GROWTH, SHRINKAGE) ???

    There is a very good basic explanation of Transaction Logs and their importance here:

     http://techrepublic.com.com/5100-6313-5173108.html?tag=e101

    As SQLBill explained quite well, how and when you decide to back up your transaction logs is...

    My hovercraft is full of eels.

  • RE: Losing Registered Servers

    We're also on a mixed Netware/Microsoft network and using local profiles will fix the problem but it can come back when they push out Netware client updates.  Depending on how these...

    My hovercraft is full of eels.

  • RE: SQL SERVER AGENT ERROR

    Carl,

    I saw this once on a newly installed server where I'd forgotten to set the event logs to overwrite as needed.  After a couple of weeks,...

    My hovercraft is full of eels.

  • RE: Enterprise Manager not functioning properly !

    It's hard to say, but if you can run jobs from a remote server and not locally, it sounds like an authentication problem.  Stupid question maybe, but were you able...

    My hovercraft is full of eels.

  • RE: MS SQL Sever 7.00 Err

    Take a look at:  http://support.microsoft.com/default.aspx?scid=kb;EN-US;295114.  Hope this helps.

    My hovercraft is full of eels.

  • RE: mmc register server wizard fails ...

    You didn't say what service pack you're running.  You may want to try installing or re-applying SQL Server SP3 and see if this helps.  Can you ping the servers from...

    My hovercraft is full of eels.

  • RE: DBPROCESS is dead or not enabled

    This is a pretty generic message and hard to troubleshoot without more information.  When I've seen it in our place it was with a Sybase app and it's always been...

    My hovercraft is full of eels.

  • RE: Question of the Day for 16 Feb 2004

    I have to concur with most of the posts I've seen here and admit that I got this wrong even though this is something we do all the time.  That...

    My hovercraft is full of eels.

  • RE: Backing up database with password

    I don't think it was availble in 7.0, but if you're using SQL 2000 check Books on line, type in "Password Protect" and it should take you to the "Administering...

    My hovercraft is full of eels.

  • RE: Restoring the MDF file on to a back server

    I know this is an older post so I hope it's not to late to help.  SQL 7 does support sp_attach_single_file_db but the caveat is that the database must have...

    My hovercraft is full of eels.

  • RE: Shrinking Transaction Log Size??

    Jeff,

    You didn't say what version you're using, but check the FAQ's here:  http://www.sqlservercentral.com/faq/viewfaqanswer.asp?categoryid=2&faqid=154 

    There are two links from there to Microsoft's site depending on whether you're using SQL Server...

    My hovercraft is full of eels.

  • RE: DBPROCESS id dead

    I had a similar problem last week. If your SQL Server is up and running with no errors, the client issue is most likely due to some kind of...

    My hovercraft is full of eels.

  • RE: Acronyms

    One thrown around here quite a bit a while back was:

    NAPWAD - Not A Problem, Works As Designed

    Then there was one I saw as a signature in a post a...

    My hovercraft is full of eels.

  • RE: XP_sendmail started failing

    Have you tried issuing a xp_stopmail then xp_startmail? Failing that, is it possible someone changed the properties of the Domain Admin account? Hope this helps.

    My hovercraft is full of eels.

  • RE: SQL Profiler

    In profiler, go to Properties, filters, expand 'TextData', then 'Like' and put in %sp_procname% where 'procname' is the name of the procedure you want to trace. I do think...

    My hovercraft is full of eels.

Viewing 15 posts - 421 through 435 (of 471 total)