Changing the collation

Dear gurus,
I am pursuing for a statement or function which allow me change the
collation at database level.
Thanks in advance and regards,
Enrichi enric,
I think you can change collation on database level using "alter database
collate command "
ALTER DATABASE database
{ ADD FILE < filespec > [ ,...n ] [ TO FILEGROUP filegroup_name ]
| ADD LOG FILE < filespec > [ ,...n ]
| REMOVE FILE logical_file_name
| ADD FILEGROUP filegroup_name
| REMOVE FILEGROUP filegroup_name
| MODIFY FILE < filespec >
| MODIFY NAME = new_dbname
| MODIFY FILEGROUP filegroup_name {filegroup_property | NAME =
new_filegroup_name }
| SET < optionspec > [ ,...n ] [ WITH < termination > ]
| COLLATE < collation_name >
}
thanks,
Jose de Jesus Jr. Mcp,Mcdba
MCP #2324787
"Enric" wrote:

> Dear gurus,
> I am pursuing for a statement or function which allow me change the
> collation at database level.
> Thanks in advance and regards,
> Enric|||Yes, but that will not change collation for the existing tables. For that, y
ou need to do ALTER
TABLE ... ALTER COLUMN for each table and each column in the database. And i
t also require you to
drop indexes (and probably a few more things). Not fun...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Jose G. de Jesus Jr MCP, MCDBA" <Email me> wrote in message
news:2CA8C84A-C24A-4F58-8860-4C3F3D454037@.microsoft.com...
> hi enric,
> I think you can change collation on database level using "alter database
> collate command "
>
> ALTER DATABASE database
> { ADD FILE < filespec > [ ,...n ] [ TO FILEGROUP filegroup_name ]
> | ADD LOG FILE < filespec > [ ,...n ]
> | REMOVE FILE logical_file_name
> | ADD FILEGROUP filegroup_name
> | REMOVE FILEGROUP filegroup_name
> | MODIFY FILE < filespec >
> | MODIFY NAME = new_dbname
> | MODIFY FILEGROUP filegroup_name {filegroup_property | NAME =
> new_filegroup_name }
> | SET < optionspec > [ ,...n ] [ WITH < termination > ]
> | COLLATE < collation_name >
> }
> --
> thanks,
> --
> Jose de Jesus Jr. Mcp,Mcdba
> MCP #2324787
>
> "Enric" wrote:
>

changing SQL Server IP address

Hi All

Will changing SQL Server IP address affecting/break anything in sql server? Thank you in advance.

Possibly not, depending on your environment.

The critical thing is that all connection strings and references to the server must use it's NetBIOS name or DNS name. If you don't know what you're using, it's probably NetBIOS and thus you're probably ok :)

Also, if you change the IP address, any open connections to the server will break. So be sure you do this at a pre-determined downtime :)

-Ryan / Kardax

Changing database owner

Hi,
Could someone of you knows how to change the database owner?
Thanks in advance.
BorisPerhaps sp_changedbowner is what you are looking for. You can read some =information on this stored procedure within Books Online (within the SQL =Server program group).
-- Keith
"Boris Condarco" <bcondarco@.hotmail.com> wrote in message =news:upgUMvHpDHA.488@.tk2msftngp13.phx.gbl...
> Hi,
> > Could someone of you knows how to change the database owner?
> > Thanks in advance.
> > Boris
> >|||You can use sp_changedbowner. You can find more information
on this system stored procedure in books online.
-Sue
On Thu, 6 Nov 2003 11:42:35 -0400, "Boris Condarco"
<bcondarco@.hotmail.com> wrote:
>Hi,
>Could someone of you knows how to change the database owner?
>Thanks in advance.
>Boris
>

Changing Data and Backup folder properties in SSAS

Hi All -

Can we change the data and backup folder location from SSAS properties? Can it have any kind of adverse impact ?

Thanks for help in advance.

Hi,

Changing the backup location is not an issue, just remember to create the new directory folder otherwise it doesn't actually back it up. Would assume the same is true for the data folder, but I haven't tried this.

Cheers

Matt