Hi everybody, due to our security policy, our DNN DB user can't create or drop tables. We've tried to upgrade using the standard procedure in our Beta environment and, of course, we got some errors due to this. So we'd like to upgrade DNN let only our DBA running the DB scripts. Can anybody describe a procedure to upgrade from a version to another manually? (we're upgrading from 5.6.1 to 6.0.0, but a "general" guide, if exists, I guess will be usefull). I.e.: - is there something to change in the *.config files? - which scripts must be ran by our DBA? And in which order? And "when" in the procedure? - are there others scripts to run to change something in the file system? or is it enough copying the files from the Zip? Thank you very much for any contribute. Max

Here's an example for you. I just tried to upgrade from 6.0 to 6.0.1 and got an error. I open that resources file and it says this

System.Data.SqlClient.SqlException: There is already an object named 'GetFileContent' in the database.
   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)






CREATE PROCEDURE dbo.[GetFileContent]
@FileId int
AS
BEGIN
SELECT Content
FROM dbo.[Files]
WHERE FileId = @FileId
END

So what I did is remove the top part about the error, then change the bottom part to this
ALTER PROCEDURE dbo.[GetFileContent]
@FileId int
AS
BEGIN
SELECT Content
FROM dbo.[Files]
WHERE FileId = @FileId
END

I then just executed that script and everything is working fine.