Viewing 15 posts - 61 through 75 (of 112 total)
[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...
May 28, 2008 at 1:24 pm
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...
May 28, 2008 at 1:01 pm
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
May 28, 2008 at 12:40 pm
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...
May 22, 2008 at 9:45 am
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....
May 22, 2008 at 9:27 am
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. ...
May 8, 2008 at 12:49 pm
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...
April 22, 2008 at 7:55 am
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...
March 21, 2008 at 2:31 pm
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
March 21, 2008 at 10:35 am
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...
March 21, 2008 at 7:56 am
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...
March 5, 2008 at 9:16 am
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...
January 29, 2008 at 7:48 am
I use Password Safe. http://passwordsafe.sourceforge.net/
David
January 28, 2008 at 8:47 am
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....
November 30, 2007 at 8:33 am
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
November 28, 2007 at 8:52 am
Viewing 15 posts - 61 through 75 (of 112 total)