Forum Replies Created

Viewing 15 posts - 136 through 150 (of 183 total)

  • RE: critical issue from SQL Best Practices Analyser

    I also had this error reported. I updated all drivers that I could (exception was the SAN/HBAs) and it did not resolve the error message. I decided to...

  • RE: BPA reports collation conflicts

    I had the same reported issue by the bpa with the server I inherited at my new job. They also upgraded from 2000 to 2005. I have not...

  • RE: Minimum Rights To Connect?

    Thanks. HAs not solved my issue yet, but that was the information I was looking for. I will let you know if I find a resolution.

  • RE: Minimum Rights To Connect?

    Thanks for the reply. I found that article too... but I know I did not change any of that and it used to work for a user now reporting...

  • RE: Minimum Rights To Connect?

    Still have not figured this out. Are there any groups/roles that exist for SSIS? I can get access (but I am sysadmin) and I don't want to give...

  • RE: How to determine last time log growth happened

    Good to know that it is limited and the source for the data. For my issue it suffices.

  • RE: How to determine last time log growth happened

    Found the answer (from another forum) and thought I would post. With SP2 you can right click and select reports on a database, and select the disk usage report....

  • RE: How to determine last time log growth happened

    Yeah.. I am looking for a method without a baseline, profiler, etc. I can set it up going forward, but I am trying to identify a possible correllation between...

  • RE: IO request taking longer than 15 seconds

    Yes they are on the same volume group. But I've been told that this is not the same as when you have a normal scsi style drive system because...

  • RE: IO request taking longer than 15 seconds

    Its part of the SAN (could be the issue). All the tempdb files are on that set of drives. They were there when it was one file as...

  • RE: Best Encryption method

    The with Encryption is the only way I know. If you are concerned about providing it, maybe creating a CLR stored procedure is a better option. Compile a...

  • RE: Best Encryption method

    It depends on your needs. There are various encryption methods that can be used both internal and external to SQL. Usually its a trade-off between performance and the...

  • RE: Database mirroring failover with witness

    What operating mode do you have mirroring setup in? It must be in high availability mode to have automatic failover.

  • RE: AWE issue

    You should set lock pages in memory when enabling AWE for systems over the usable ram to os rating. The service account you were using I believe has that...

  • RE: WMI Help

    Thanks.. that should help a lot for the disk space one.

    Now on to figuring out the %cpu usage!

Viewing 15 posts - 136 through 150 (of 183 total)