How to change SQL2005 Express server collation ?

Hi:
How to I change SQL2005 Express server collation ?
In SQL2005 Standard I use:
start /wait <SQL2005 installation folder>\setup.exe /qb
INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1
SAPWD=<NewStrongPassword> SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS
but in SQL2005 Express the C:\Program Files\Microsoft SQL
Server\90\Setup Bootstrap\setup.exe seem not work
Please help
JCVoon
Hi:
Never mind, my problem solved.
JCVoon
sql

How to change SQL2005 Express server collation ?

Hi:
How to I change SQL2005 Express server collation ?
In SQL2005 Standard I use:
start /wait <SQL2005 installation folder>\setup.exe /qb
INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1
SAPWD=<NewStrongPassword> SQLCOLLATION=SQL_Latin1_General_CP1_CI_A
S
but in SQL2005 Express the C:\Program Files\Microsoft SQL
Server\90\Setup Bootstrap\setup.exe seem not work
Please help
JCVoonHi:
Never mind, my problem solved.
JCVoon

How to change SQL2005 Express server collation ?

Hi:
How to I change SQL2005 Express server collation ?
In SQL2005 Standard I use:
start /wait <SQL2005 installation folder>\setup.exe /qb
INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1
SAPWD=<NewStrongPassword> SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS
but in SQL2005 Express the C:\Program Files\Microsoft SQL
Server\90\Setup Bootstrap\setup.exe seem not work
Please help
JCVoonHi:
Never mind, my problem solved.
JCVoon

How to change SMTP server after installation

How do you change the SMTP server in Reporting Services after installation
is complete?
Thanks
DeanIf you accepted the default folders during install, look in the C:\Program
Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer folder.
Open the RSReportServer.config (back it up before you change it). Modify
the <RSEmailDPConfiguration> element.
Here's a reference to help you:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp_configserver_v1_4bzl.asp
After your changes, open the Services mmc-snap in and restart the
ReportServer service.
--
Adrian M.
MCP
"dean" <dean.nicholson@.bcbsne.com> wrote in message
news:eEZ4bPrOFHA.4028@.tk2msftngp13.phx.gbl...
> How do you change the SMTP server in Reporting Services after installation
> is complete?
> Thanks
> Dean
>sql

how to change default data directory for SQL 2005

Hi, I've installed SQL 2005 and failed to change the default data
location during installation. Now I want to change it. Can I do this
without having to uninstall and reinstall? And furthermore, is there a
system stored procedure I can use to move existing data and log files
(master, msdb, AdventureWorks, etc.)? I seem to remember doing just
this with SQL 2000 some time back.

Thanks,
EricYou can specify the default database file locations using SQL Server
Management Studio. Right-click the server in the object explorer and select
Properties-->Database Settings.

The SQL 2005 Books Online includes detailed steps on moving database files.
There is a different procedure for system vs. user databases.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Eric Bragas" <ericbragas@.yahoo.comwrote in message
news:1159469015.718736.156300@.d34g2000cwd.googlegr oups.com...

Quote:

Originally Posted by

Hi, I've installed SQL 2005 and failed to change the default data
location during installation. Now I want to change it. Can I do this
without having to uninstall and reinstall? And furthermore, is there a
system stored procedure I can use to move existing data and log files
(master, msdb, AdventureWorks, etc.)? I seem to remember doing just
this with SQL 2000 some time back.
>
Thanks,
Eric
>

|||Thanks, Dan. This answers my question completely.

-Eric

how to change default data directory for SQL 2005

Hi, I've installed SQL 2005 and failed to change the default data
location during installation. Now I want to change it. Can I do this
without having to uninstall and reinstall? And furthermore, is there a
system stored procedure I can use to move existing data and log files
(master, msdb, AdventureWorks, etc.)? I seem to remember doing just
this with SQL 2000 some time back.

Thanks,
EricYou can specify the default database file locations using SQL Server
Management Studio. Right-click the server in the object explorer and select
Properties-->Database Settings.

The SQL 2005 Books Online includes detailed steps on moving database files.
There is a different procedure for system vs. user databases.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Eric Bragas" <ericbragas@.yahoo.comwrote in message
news:1159469015.718736.156300@.d34g2000cwd.googlegr oups.com...

Quote:

Originally Posted by

Hi, I've installed SQL 2005 and failed to change the default data
location during installation. Now I want to change it. Can I do this
without having to uninstall and reinstall? And furthermore, is there a
system stored procedure I can use to move existing data and log files
(master, msdb, AdventureWorks, etc.)? I seem to remember doing just
this with SQL 2000 some time back.
>
Thanks,
Eric
>

|||Thanks, Dan. This answers my question completely.

-Eric

How to change "sa" password after installation?

I just installed MS SQL SERVER2000, but seems the password I was setting didn't look good. So I want to change it, but how? Thanks!run stored procedure using account with sysadmin role priveleges

sp_password @.new = 'newprd' , @.loginame = 'sa'

ask if you have any questions|||run stored procedure using account with sysadmin role priveleges

sp_password @.new = 'newprd' , @.loginame = 'sa'

ask if you have any questions

I've figured it out, thanks!