Forum Replies Created

Viewing 15 posts - 27,361 through 27,375 (of 39,961 total)

  • RE: PASS summit 2008

    It's not that I don't want to go uphill, but there doesn't seem to be much uphill and close to the convention center. Much more if you head down towards...

  • RE: SA account best practices

    I'll second the advice above.

  • RE: Restrict table access for a user

    Users have no rights to tables unless they are granted. If they are granted as part of a role or rights, then you can use DENY as listed above.

  • RE: Hardware Information

    That will create a bunch of stuff in text files, but it won't get it into SQL Server.

    It would help if we knew what the OP wanted to accomplish.

  • RE: tempdb reporting Error: 9002 log full

    Look for something open in tempdb as well. The database should be in simple mode, so it should clear the log at each checkpoint.

  • RE: Fresh install no database server

    If SQL Server is running, meaning the service is running, can you connect to "(local)"?

    Also, it installs under Program Files, look for the SQL Server log files, and you will...

  • RE: SQL Server Authentication mode

    There is no SQL Server mode. There is mixed mode, both Windows and SQL authentication, and Windows only mode, for only Windows authentication.

    There is no default user and password. The...

  • RE: Log Shipping Copy failure

    That's what I'd think. You have another process already setup for log backups, and that will interfere with log shipping. If you log ship, you basically need to disable other...

  • RE: Hardware Information

    Most of this stuff you would get from a command line or WMI if you wanted it. SQL Server would then access that the same way, with an XP_CMDSHELL or...

  • RE: PASS summit 2008

    Downtown isn't very big. Within 3 or 4 blocks, there are lots of restaurants. Just don't start walking uphill 🙂

  • RE: Automate copy of 3 tables to sql server in another domain?

    I'd prefer the SSIS stuff myself, though it would be more work. Replication will do it, just remember that there will be a time the table is not available as...

  • RE: Newsletter format problem on pda

    The Blackberry server might not like something. I'll check with a few people.

  • RE: Issue with topic I opened

    Shouldn't be temporary files. Wouldn't delete them. Maybe you had a space or typo in it.

  • RE: Thinking of starting a dating site for DBAs

    Yikes, this thread is skirting the edge.

  • RE: CHECKDB

    It may or may not. Depends on what checkdb needs to do, the activity and resources available at the time it's run, etc.

Viewing 15 posts - 27,361 through 27,375 (of 39,961 total)