BugNET

Open source issue tracking & project management
Welcome to BugNET Register | Login |

BugNET Forums

 
  Forum  Support  Installation pr...  problems in sql script (collation) + installation stops without error msg
Previous Previous
 
Next Next
New Post 6/27/2007 9:33 AM
User is offline ChrisMan
22 posts
No Ranking


Re: problems in sql script (collation) + installation stops without error msg 

Hi David

I finally found why InstallRoles was crashing: there was a little bug in the script, which appears only when the DB server's collation is different from the BugNet DB's collation (explanation given here: http://technet.microsoft.com/en-us/library/ms190920.aspx  at paragraph "Collations and tempdb").

To correct it, look for
DECLARE @tbNames  table(Name nvarchar(256) NOT NULL PRIMARY KEY)
and replace it by
DECLARE @tbNames  table(Name nvarchar(256) COLLATE database_default NOT NULL PRIMARY KEY)

There are two occurences to replace.

 

Cheers

 
Previous Previous
 
Next Next
  Forum  Support  Installation pr...  problems in sql script (collation) + installation stops without error msg

Forum Policy

These Discussion Forums are dedicated to the discussion of the BugNET issue tracker.

For the benefit of the community and to protect the integrity of the project, please observe the following posting guidelines:
1. No Advertising.
2. No Flaming or Trolling.
3. No Profanity, Racism, or Prejudice.
4. Site Moderators have the final word on approving/removing a thread or post or comment.
5. English language posting only, please.