Forum Replies Created

Viewing 15 posts - 16 through 30 (of 37 total)

  • RE: UnKillable Locks

    It only seems to be happening on updates. I've checked out a few other forums and this problem seems to happen from time to time and the only solution...

  • RE: UnKillable Locks

    I have not run a trace against it because the rate of failure is very small, like every 500 times or more it will lock up. The user and...

  • RE: Kill That Target!

    Thanks! I've seen this problem before, but I took the easy/bad way out and just recreated the jobs.

  • RE: Variable DB specification in SP's

    Perfect, You know I just spent about 3 days writing a massive SP that builds strings for execution. I guess I fried my brain on that one. Thanks...

  • RE: Changing SQL Licensing

    After some testing I have found a way to accomplish what I needed to do. Inorder for you to go from Enterprise Processor licensing to Enterprise Per Seat you...

  • RE: SQL Maintenance Plans

    I use the maintenance plans for simple things like backing up the logs every half hour, and full backups every 12 hours. It works great. If it fails,...

  • RE: Enterprise or Standard

    Perfect, Thank-you!

  • RE: Auditing failed logins

    Sweet! Thanks! How about stopping the logging of all my jobs that run?

  • RE: Auditing failed logins

    I looked in the SQL Log Files, but nothing there but my job competions. Do I need to stop/start the SQL Services after setting Audit level to Failure?

  • RE: Trans Log Backup Failed

    BINGO. It was the Simple mode. I'm using SQL2000. Thanks all for your input.

    I am with myself and deserve a

  • RE: Policy and Proceedure Document

    Thanks, I'll be grateful for anything I can get.

  • RE: Discovering SQL Servers on the Network

    After some thought, I've deceided that the best approach is to create policy, since I have to anyways, that contain language that prohibits hiding SQL servers. All SQL servers...

  • RE: Discovering SQL Servers on the Network

    I musta been smokin something cause now I cant find the check box that I thought I saw to hide SQL Server. Maybe it was during an installation? ...

  • RE: Discovering SQL Servers on the Network

    Problem with that particular tool is (according to the network admin) is that you have to run it on the server itself, it dosent sweep the network. At which...

  • RE: SQL 2000 Service Pack 2

    I put it on a box used for light SQL production work. So far so good.

Viewing 15 posts - 16 through 30 (of 37 total)