Forum Replies Created

Viewing 15 posts - 34,726 through 34,740 (of 39,725 total)

  • RE: If the transaction log is damaged

    It should be all changes that were not committed. Does this not seem to be the case?

  • RE: Query Help

    I don't usually recommend this, but I'd use a cursor for this. Assuming that recno is an actual field in your table, use that and run a loop. Actually you don't...

  • RE: tempdb log full - (Not really!)

    There are some things in SQL Server that are extremely intolerant of delays. Backups is one and tempdb may be another. Since it is used at a low level by...

  • RE: SQL Server Ent Mgr - Using favourites in MMC

    Never tried it and I don't see the option in XP. I'll see if I can dig something up.

     

  • RE: Turn off emoticons?

    Good question. I'm not sure. I need to dig into the forum code a bit and see. It's from the InstantForum.com guys, so they'd need to support it.

     

  • RE: tempdb log full - (Not really!)

    You can use the GUI or ALTER DATABASE command to set the initial size higher.

  • RE: How to monitor DB growth over time

    Can't do it retroactively. You have to setup a process to check the space once a day or so and store it somewhere. I used to do this for backups...

  • RE: QOD Enhancements !!

    It's been suggested and it's on our list. I agree with you, just a few things that are broken first. We'll get to it.

  • RE: Remote access through a VPN connectin

    You should use IP or setup a local DNS to connect. Using the servername won't work across most VPNs. Only FQDNs.

  • RE: Trigger timing issue

    I'd recode the triggers to do the same thing as the sp_start_job. In general, you never want to trigger some process with a trigger because the transaction will never complete.

  • RE: Check database is alive?

    Through a linked server, any query will do.

     

    if exists( select top 1 * from sysusers) insert logtable

    will do it from the source server.

  • RE: getting all users accross all servers

    If it's something regular, I agree with DMO. I had a DMO script to check all logins on all servers for blank passwords at my last job. I can try...

  • RE: Parsing dates from diferent timezones

    dateadd( h, x, cast( datefield as datetime))

     where x is the hour difference. datefield is your column.

  • RE: Permissions conundrum

    Is it one account, like a sysadmin account?

    Have you checked for roles or perhaps some other changes that might have been made on one box you are not aware of? sounds...

  • RE: Stupid question about sa

    Definiteiyl not a stupid question.

    Using a second server or second instance is the best awy to go. It won't see your databases and so they will be suspect on the...

Viewing 15 posts - 34,726 through 34,740 (of 39,725 total)