Forum Replies Created

Viewing 15 posts - 61 through 75 (of 112 total)

  • RE: Auditing

    [I spend about 2 hours every month running the same report on 23 different servers.

    I figure all they need to do is create partitioned view to union the data from...

  • RE: Auditing

    I'm using Idera's SQL Compliance Manager and been pretty happy with it. It can audit logins, DDL and DML statements. They have good ability to filter what you...

  • RE: Changing the database to unicode?

    Check out Microsoft's SQL Server Best Practices web site, there are some papers on changing data types to Unicode.

    http://technet.microsoft.com/en-us/sqlserver/bb671430.aspx

    David

  • RE: installing SP2

    You should not need to restore any db's or users after upgrade to SP2 and whatever cumulative level you want. You will need to restart SQL Server so plan...

  • RE: Changing the database to unicode?

    Unless I'm missing something, changing the collation will not make all the data unicode it will just determine the sort order, case sensitivity and code page for non unicode data....

  • RE: SQL Server 2005

    I missed the question because I always thought the resource database was called MSSQLSystemResource which is the same as the mdf file... so figured it was a trick question. ...

  • RE: Backups

    In SIMPLE recovery model SQL Server will automatically clear out the transaction log after transactions are committed. As a result only full and differential backups are allowed. If...

  • RE: Moving System Databases

    The question of the day has changed. When I answered it the question stated

    "If you are moving system databases (master, msdb, model, tempdb), you would change the location of...

  • RE: Moving System Databases

    The real answer should be mssqlsystemresource ...

    Adam is correct and using that answer would have made the question make sense... and even be a good question.

    David

  • RE: Moving System Databases

    Despite the complete vagueness of the questions, plus the fact it does not matter which order you move the system databases, I chose tempdb as needing addressed next mainly because...

  • RE: Application Roles

    Now to access the other database application role must have access to other database which is not mention anywhere in the question.

    Application roles are only database level principals so you...

  • RE: Passwords

    Joe Clifford (1/29/2008)


    Write it down, put it in a labeled signed dated envelope (2 sigs required) and put it in the safe.

    I agree with Joe... whatever you use to...

  • RE: Passwords

    I use Password Safe. http://passwordsafe.sourceforge.net/

    David

  • RE: Upgrade to SQL2005

    The Upgrade Adviser will tell you if there are any mandatory changes needed prior to the migration. Other then that, database from SQL2K migrate over to SQL2K5 really well....

  • RE: Upgrade to SQL2005

    Check out Microsoft's site on upgrading to SQL 2K5. Also, download and run the SQL Server 2005 Upgrade adviser.

    http://www.microsoft.com/sql/solutions/upgrade/default.mspx

    Hope all goes well with the upgrade...

    David

Viewing 15 posts - 61 through 75 (of 112 total)