Change collation for an existing database

Hi !
I would like to know how to change the collation of an imported database. I
tried something with DTS, but I'm quiet a beginner with this tool. So if
anyone could help me on this one, this would be great ! ;-)
Thanks in advance !
I just forgot to say that I use SQL 2000 SP4.
"Vincent D." wrote:

> Hi !
> I would like to know how to change the collation of an imported database. I
> tried something with DTS, but I'm quiet a beginner with this tool. So if
> anyone could help me on this one, this would be great ! ;-)
> Thanks in advance !
|||Seems that similar issue has been handled recently. Pls have a look at the 2
posts of 28/11/05.
http://www.microsoft.com/technet/com...8-B1DE-B6EB49F
31B7E&dglist=&ptlist=&exp=&sloc=en-us
"Vincent D." wrote:
[vbcol=seagreen]
> I just forgot to say that I use SQL 2000 SP4.
> "Vincent D." wrote:

Change authentication

I am not good endlish. I am thai.

I try to change authentication from win --> sql authen. I am use sql express and management tool.I am select at .\sqlexpress --> property -->security and change authentication from win authentication to sql authentication and click OK

after that re-connect and change to sql authentication but It not work.

Pls tell me How to change authentication.

Thank you for you help

Hi there,

From your description it seems that you've changed the authentication mode successfully.

I would assume, then, that the problem has something to do with the SQL Server account you are using. So:

* What account are you using?
* Does it have a password that you might have forgotten to enter? (sorry about asking that)

What you could do, to test that everything is absolutely OK is switch back to Windows Authentication, log into your SQL Server instance and create a new SQL Server user (e.g. test_user) with no password (or you could set a password, up to you).

After doing that, disconnect from your sever and reconnect using SQL Server Authentication. Set the account as the one you just created and enter whatever password you set (or nothing if you set not password).

Hopefully you'll log in successfully.

Hope that helps a bit, but sorry if it doesn't
|||You have to restart the service.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

CE upgrade tool?

Have anyone written a tool to upgrade from CE to Everywhere that is easier to use that the upgrade.exe program?

Thanks

Hi,
I have written a free GUI Interface to it - available at
http://www.gui-innovations.com/download/SqlUpgrade.zip

Pete

|||

Hello Pete,

Thanks for the link to your program.

I ran the program and got this error message:

SQLMobile appears not to be installed - can't continue. Cab files should be in the C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0 folders on your PC

What product/SDK is it expecting?

Thanks

Tom

|||

Hi,

you will need the .Net CF 2 runtimes, and the SqlMobile runtimes on the PPC to run it

Pete