For some reason I had to change server name. I also created new
registration in Enterprise Manager.
When I try to retreive data, it still looking for my old server name.
Where else should I change the server name . ?
Thanks
Here is a quote from KB article 257716:
<< start quote >>
Q. Can I rename a server after installing SQL Server 2000?
A: Yes, you can rename a server after the installation of SQL Server
2000. When the SQL Server service starts for the first time after the
name change, it automatically recognizes the change and resets the
computer name. You do not need to run setup again to reset this value.
However, you must perform several additional configuration steps. To
correct the sysservers system table, you should manually run the
following procedures.
For a default instance: sp_dropserver <old_servername>
go
sp_addserver <new_servername> , local
go
<< end quote >>
You can also see the following KB article:
http://support.microsoft.com/kb/303774
Razvan
Showing posts with label enterprise. Show all posts
Showing posts with label enterprise. Show all posts
Wednesday, March 28, 2012
Monday, March 26, 2012
How to change server name in SQL2K ?
For some reason I had to change server name. I also created new
registration in Enterprise Manager.
When I try to retreive data, it still looking for my old server name.
Where else should I change the server name . ?
Thanks
Here is a quote from KB article 257716:
<< start quote >>
Q. Can I rename a server after installing SQL Server 2000?
A: Yes, you can rename a server after the installation of SQL Server
2000. When the SQL Server service starts for the first time after the
name change, it automatically recognizes the change and resets the
computer name. You do not need to run setup again to reset this value.
However, you must perform several additional configuration steps. To
correct the sysservers system table, you should manually run the
following procedures.
For a default instance: sp_dropserver <old_servername>
go
sp_addserver <new_servername> , local
go
<< end quote >>
You can also see the following KB article:
http://support.microsoft.com/kb/303774
Razvan
registration in Enterprise Manager.
When I try to retreive data, it still looking for my old server name.
Where else should I change the server name . ?
Thanks
Here is a quote from KB article 257716:
<< start quote >>
Q. Can I rename a server after installing SQL Server 2000?
A: Yes, you can rename a server after the installation of SQL Server
2000. When the SQL Server service starts for the first time after the
name change, it automatically recognizes the change and resets the
computer name. You do not need to run setup again to reset this value.
However, you must perform several additional configuration steps. To
correct the sysservers system table, you should manually run the
following procedures.
For a default instance: sp_dropserver <old_servername>
go
sp_addserver <new_servername> , local
go
<< end quote >>
You can also see the following KB article:
http://support.microsoft.com/kb/303774
Razvan
How to change server name in SQL2K ?
For some reason I had to change server name. I also created new
registration in Enterprise Manager.
When I try to retreive data, it still looking for my old server name.
Where else should I change the server name . ?
ThanksHere is a quote from KB article 257716:
<< start quote >>
Q. Can I rename a server after installing SQL Server 2000?
A: Yes, you can rename a server after the installation of SQL Server
2000. When the SQL Server service starts for the first time after the
name change, it automatically recognizes the change and resets the
computer name. You do not need to run setup again to reset this value.
However, you must perform several additional configuration steps. To
correct the sysservers system table, you should manually run the
following procedures.
For a default instance: sp_dropserver <old_servername>
go
sp_addserver <new_servername> , local
go
<< end quote >>
You can also see the following KB article:
http://support.microsoft.com/kb/303774
Razvansql
registration in Enterprise Manager.
When I try to retreive data, it still looking for my old server name.
Where else should I change the server name . ?
ThanksHere is a quote from KB article 257716:
<< start quote >>
Q. Can I rename a server after installing SQL Server 2000?
A: Yes, you can rename a server after the installation of SQL Server
2000. When the SQL Server service starts for the first time after the
name change, it automatically recognizes the change and resets the
computer name. You do not need to run setup again to reset this value.
However, you must perform several additional configuration steps. To
correct the sysservers system table, you should manually run the
following procedures.
For a default instance: sp_dropserver <old_servername>
go
sp_addserver <new_servername> , local
go
<< end quote >>
You can also see the following KB article:
http://support.microsoft.com/kb/303774
Razvansql
How to change server name in SQL2K ?
For some reason I had to change server name. I also created new
registration in Enterprise Manager.
When I try to retreive data, it still looking for my old server name.
Where else should I change the server name . ?
ThanksHere is a quote from KB article 257716:
<< start quote >>
Q. Can I rename a server after installing SQL Server 2000?
A: Yes, you can rename a server after the installation of SQL Server
2000. When the SQL Server service starts for the first time after the
name change, it automatically recognizes the change and resets the
computer name. You do not need to run setup again to reset this value.
However, you must perform several additional configuration steps. To
correct the sysservers system table, you should manually run the
following procedures.
For a default instance: sp_dropserver <old_servername>
go
sp_addserver <new_servername> , local
go
<< end quote >>
You can also see the following KB article:
http://support.microsoft.com/kb/303774
Razvan
registration in Enterprise Manager.
When I try to retreive data, it still looking for my old server name.
Where else should I change the server name . ?
ThanksHere is a quote from KB article 257716:
<< start quote >>
Q. Can I rename a server after installing SQL Server 2000?
A: Yes, you can rename a server after the installation of SQL Server
2000. When the SQL Server service starts for the first time after the
name change, it automatically recognizes the change and resets the
computer name. You do not need to run setup again to reset this value.
However, you must perform several additional configuration steps. To
correct the sysservers system table, you should manually run the
following procedures.
For a default instance: sp_dropserver <old_servername>
go
sp_addserver <new_servername> , local
go
<< end quote >>
You can also see the following KB article:
http://support.microsoft.com/kb/303774
Razvan
How to change server name in SQL2K ?
For some reason I had to change server name. I also created new
registration in Enterprise Manager.
When I try to retreive data, it still looking for my old server name.
Where else should I change the server name . ?
ThanksHere is a quote from KB article 257716:
<< start quote >>
Q. Can I rename a server after installing SQL Server 2000?
A: Yes, you can rename a server after the installation of SQL Server
2000. When the SQL Server service starts for the first time after the
name change, it automatically recognizes the change and resets the
computer name. You do not need to run setup again to reset this value.
However, you must perform several additional configuration steps. To
correct the sysservers system table, you should manually run the
following procedures.
For a default instance: sp_dropserver <old_servername>
go
sp_addserver <new_servername> , local
go
<< end quote >>
You can also see the following KB article:
http://support.microsoft.com/kb/303774
Razvan
registration in Enterprise Manager.
When I try to retreive data, it still looking for my old server name.
Where else should I change the server name . ?
ThanksHere is a quote from KB article 257716:
<< start quote >>
Q. Can I rename a server after installing SQL Server 2000?
A: Yes, you can rename a server after the installation of SQL Server
2000. When the SQL Server service starts for the first time after the
name change, it automatically recognizes the change and resets the
computer name. You do not need to run setup again to reset this value.
However, you must perform several additional configuration steps. To
correct the sysservers system table, you should manually run the
following procedures.
For a default instance: sp_dropserver <old_servername>
go
sp_addserver <new_servername> , local
go
<< end quote >>
You can also see the following KB article:
http://support.microsoft.com/kb/303774
Razvan
How to change security audit on SQL server programatically
Right now, the default security auditing is set to none when i go through
Enterprise Manager.
I would like to change it to all. How can I do so programatically ?Hi,
You need to edit the registry key.
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer]
Change the value for registry key AuditLevel to 3.
Note: Editing the registry key is not a good practice and it is risky as
well.
Thanks
Hari
SQL Server MVP
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:esZOB$5aFHA.720@.TK2MSFTNGP15.phx.gbl...
> Right now, the default security auditing is set to none when i go through
> Enterprise Manager.
> I would like to change it to all. How can I do so programatically ?
>sql
Enterprise Manager.
I would like to change it to all. How can I do so programatically ?Hi,
You need to edit the registry key.
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer]
Change the value for registry key AuditLevel to 3.
Note: Editing the registry key is not a good practice and it is risky as
well.
Thanks
Hari
SQL Server MVP
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:esZOB$5aFHA.720@.TK2MSFTNGP15.phx.gbl...
> Right now, the default security auditing is set to none when i go through
> Enterprise Manager.
> I would like to change it to all. How can I do so programatically ?
>sql
Monday, March 19, 2012
How to change characterset in SQL Enterprise Manager?
Hi,
I want to change characterset to Unicode in server 2000.
How I can do it?
Thanks,
ms_sql_characterset
If you want to change all you character data to unicode, you will need to
alter all your char, varchar, and text fields to nchar, nvarchar, and ntext
fields.
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"ms_sql_characterset" <anonymous@.discussions.microsoft.com> wrote in message
news:1c37301c4523a$8f26ec10$a101280a@.phx.gbl...
> Hi,
> I want to change characterset to Unicode in server 2000.
> How I can do it?
> Thanks,
> ms_sql_characterset
>
>
|||Yes, I will alter them to nchar, nvarchar, and ntext. But
where I can set sql server characterset to unicode?
Thanks,
>--Original Message--
>If you want to change all you character data to unicode,
you will need to
>alter all your char, varchar, and text fields to nchar,
nvarchar, and ntext
>fields.
>--
>----
--
>----
--
>--
>Need SQL Server Examples check out my website at
>http://www.geocities.com/sqlserverexamples
>"ms_sql_characterset"
<anonymous@.discussions.microsoft.com> wrote in message[vbcol=seagreen]
>news:1c37301c4523a$8f26ec10$a101280a@.phx.gbl...
2000.
>
>.
>
|||By character set I guess you mean code page, or another name might be
collation setting. Unicode and collation are really two different things.
The collation setting of a server/database/column is how SQL Server stores
char, varchar, and text fields, which of course are not UNICODE data types.
This article should provide you with information about how to change the
collation settings of a server, a database and/or a column.
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
<anonymous@.discussions.microsoft.com> wrote in message
news:1c13001c45243$9c920c00$a301280a@.phx.gbl...[vbcol=seagreen]
> Yes, I will alter them to nchar, nvarchar, and ntext. But
> where I can set sql server characterset to unicode?
> Thanks,
>
> you will need to
> nvarchar, and ntext
> --
> --
> <anonymous@.discussions.microsoft.com> wrote in message
> 2000.
I want to change characterset to Unicode in server 2000.
How I can do it?
Thanks,
ms_sql_characterset
If you want to change all you character data to unicode, you will need to
alter all your char, varchar, and text fields to nchar, nvarchar, and ntext
fields.
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"ms_sql_characterset" <anonymous@.discussions.microsoft.com> wrote in message
news:1c37301c4523a$8f26ec10$a101280a@.phx.gbl...
> Hi,
> I want to change characterset to Unicode in server 2000.
> How I can do it?
> Thanks,
> ms_sql_characterset
>
>
|||Yes, I will alter them to nchar, nvarchar, and ntext. But
where I can set sql server characterset to unicode?
Thanks,
>--Original Message--
>If you want to change all you character data to unicode,
you will need to
>alter all your char, varchar, and text fields to nchar,
nvarchar, and ntext
>fields.
>--
>----
--
>----
--
>--
>Need SQL Server Examples check out my website at
>http://www.geocities.com/sqlserverexamples
>"ms_sql_characterset"
<anonymous@.discussions.microsoft.com> wrote in message[vbcol=seagreen]
>news:1c37301c4523a$8f26ec10$a101280a@.phx.gbl...
2000.
>
>.
>
|||By character set I guess you mean code page, or another name might be
collation setting. Unicode and collation are really two different things.
The collation setting of a server/database/column is how SQL Server stores
char, varchar, and text fields, which of course are not UNICODE data types.
This article should provide you with information about how to change the
collation settings of a server, a database and/or a column.
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
<anonymous@.discussions.microsoft.com> wrote in message
news:1c13001c45243$9c920c00$a301280a@.phx.gbl...[vbcol=seagreen]
> Yes, I will alter them to nchar, nvarchar, and ntext. But
> where I can set sql server characterset to unicode?
> Thanks,
>
> you will need to
> nvarchar, and ntext
> --
> --
> <anonymous@.discussions.microsoft.com> wrote in message
> 2000.
How to change characterset in SQL Enterprise Manager?
Hi,
I want to change characterset to Unicode in server 2000.
How I can do it?
Thanks,
ms_sql_charactersetIf you want to change all you character data to unicode, you will need to
alter all your char, varchar, and text fields to nchar, nvarchar, and ntext
fields.
--
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"ms_sql_characterset" <anonymous@.discussions.microsoft.com> wrote in message
news:1c37301c4523a$8f26ec10$a101280a@.phx
.gbl...
> Hi,
> I want to change characterset to Unicode in server 2000.
> How I can do it?
> Thanks,
> ms_sql_characterset
>
>|||Yes, I will alter them to nchar, nvarchar, and ntext. But
where I can set sql server characterset to unicode?
Thanks,
>--Original Message--
>If you want to change all you character data to unicode,
you will need to
>alter all your char, varchar, and text fields to nchar,
nvarchar, and ntext
>fields.
>--
>----
--
>----
--
>--
>Need SQL Server Examples check out my website at
>http://www.geocities.com/sqlserverexamples
>"ms_sql_characterset"
<anonymous@.discussions.microsoft.com> wrote in message
> news:1c37301c4523a$8f26ec10$a101280a@.phx
.gbl...
2000.[vbcol=seagreen]
>
>.
>|||By character set I guess you mean code page, or another name might be
collation setting. Unicode and collation are really two different things.
The collation setting of a server/database/column is how SQL Server stores
char, varchar, and text fields, which of course are not UNICODE data types.
This article should provide you with information about how to change the
collation settings of a server, a database and/or a column.
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
<anonymous@.discussions.microsoft.com> wrote in message
news:1c13001c45243$9c920c00$a301280a@.phx
.gbl...[vbcol=seagreen]
> Yes, I will alter them to nchar, nvarchar, and ntext. But
> where I can set sql server characterset to unicode?
> Thanks,
>
> you will need to
> nvarchar, and ntext
> --
> --
> <anonymous@.discussions.microsoft.com> wrote in message
> 2000.
I want to change characterset to Unicode in server 2000.
How I can do it?
Thanks,
ms_sql_charactersetIf you want to change all you character data to unicode, you will need to
alter all your char, varchar, and text fields to nchar, nvarchar, and ntext
fields.
--
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"ms_sql_characterset" <anonymous@.discussions.microsoft.com> wrote in message
news:1c37301c4523a$8f26ec10$a101280a@.phx
.gbl...
> Hi,
> I want to change characterset to Unicode in server 2000.
> How I can do it?
> Thanks,
> ms_sql_characterset
>
>|||Yes, I will alter them to nchar, nvarchar, and ntext. But
where I can set sql server characterset to unicode?
Thanks,
>--Original Message--
>If you want to change all you character data to unicode,
you will need to
>alter all your char, varchar, and text fields to nchar,
nvarchar, and ntext
>fields.
>--
>----
--
>----
--
>--
>Need SQL Server Examples check out my website at
>http://www.geocities.com/sqlserverexamples
>"ms_sql_characterset"
<anonymous@.discussions.microsoft.com> wrote in message
> news:1c37301c4523a$8f26ec10$a101280a@.phx
.gbl...
2000.[vbcol=seagreen]
>
>.
>|||By character set I guess you mean code page, or another name might be
collation setting. Unicode and collation are really two different things.
The collation setting of a server/database/column is how SQL Server stores
char, varchar, and text fields, which of course are not UNICODE data types.
This article should provide you with information about how to change the
collation settings of a server, a database and/or a column.
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
<anonymous@.discussions.microsoft.com> wrote in message
news:1c13001c45243$9c920c00$a301280a@.phx
.gbl...[vbcol=seagreen]
> Yes, I will alter them to nchar, nvarchar, and ntext. But
> where I can set sql server characterset to unicode?
> Thanks,
>
> you will need to
> nvarchar, and ntext
> --
> --
> <anonymous@.discussions.microsoft.com> wrote in message
> 2000.
How to change characterset in SQL Enterprise Manager?
Hi,
I want to change characterset to Unicode in server 2000.
How I can do it?
Thanks,
ms_sql_charactersetIf you want to change all you character data to unicode, you will need to
alter all your char, varchar, and text fields to nchar, nvarchar, and ntext
fields.
--
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"ms_sql_characterset" <anonymous@.discussions.microsoft.com> wrote in message
news:1c37301c4523a$8f26ec10$a101280a@.phx.gbl...
> Hi,
> I want to change characterset to Unicode in server 2000.
> How I can do it?
> Thanks,
> ms_sql_characterset
>
>|||Yes, I will alter them to nchar, nvarchar, and ntext. But
where I can set sql server characterset to unicode?
Thanks,
>--Original Message--
>If you want to change all you character data to unicode,
you will need to
>alter all your char, varchar, and text fields to nchar,
nvarchar, and ntext
>fields.
>--
>----
--
>----
--
>--
>Need SQL Server Examples check out my website at
>http://www.geocities.com/sqlserverexamples
>"ms_sql_characterset"
<anonymous@.discussions.microsoft.com> wrote in message
>news:1c37301c4523a$8f26ec10$a101280a@.phx.gbl...
>> Hi,
>> I want to change characterset to Unicode in server
2000.
>> How I can do it?
>> Thanks,
>> ms_sql_characterset
>>
>>
>
>.
>|||By character set I guess you mean code page, or another name might be
collation setting. Unicode and collation are really two different things.
The collation setting of a server/database/column is how SQL Server stores
char, varchar, and text fields, which of course are not UNICODE data types.
This article should provide you with information about how to change the
collation settings of a server, a database and/or a column.
--
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
<anonymous@.discussions.microsoft.com> wrote in message
news:1c13001c45243$9c920c00$a301280a@.phx.gbl...
> Yes, I will alter them to nchar, nvarchar, and ntext. But
> where I can set sql server characterset to unicode?
> Thanks,
>
> >--Original Message--
> >If you want to change all you character data to unicode,
> you will need to
> >alter all your char, varchar, and text fields to nchar,
> nvarchar, and ntext
> >fields.
> >--
> >
> >----
> --
> >----
> --
> >--
> >
> >Need SQL Server Examples check out my website at
> >http://www.geocities.com/sqlserverexamples
> >"ms_sql_characterset"
> <anonymous@.discussions.microsoft.com> wrote in message
> >news:1c37301c4523a$8f26ec10$a101280a@.phx.gbl...
> >> Hi,
> >>
> >> I want to change characterset to Unicode in server
> 2000.
> >> How I can do it?
> >>
> >> Thanks,
> >>
> >> ms_sql_characterset
> >>
> >>
> >>
> >>
> >
> >
> >.
> >
I want to change characterset to Unicode in server 2000.
How I can do it?
Thanks,
ms_sql_charactersetIf you want to change all you character data to unicode, you will need to
alter all your char, varchar, and text fields to nchar, nvarchar, and ntext
fields.
--
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"ms_sql_characterset" <anonymous@.discussions.microsoft.com> wrote in message
news:1c37301c4523a$8f26ec10$a101280a@.phx.gbl...
> Hi,
> I want to change characterset to Unicode in server 2000.
> How I can do it?
> Thanks,
> ms_sql_characterset
>
>|||Yes, I will alter them to nchar, nvarchar, and ntext. But
where I can set sql server characterset to unicode?
Thanks,
>--Original Message--
>If you want to change all you character data to unicode,
you will need to
>alter all your char, varchar, and text fields to nchar,
nvarchar, and ntext
>fields.
>--
>----
--
>----
--
>--
>Need SQL Server Examples check out my website at
>http://www.geocities.com/sqlserverexamples
>"ms_sql_characterset"
<anonymous@.discussions.microsoft.com> wrote in message
>news:1c37301c4523a$8f26ec10$a101280a@.phx.gbl...
>> Hi,
>> I want to change characterset to Unicode in server
2000.
>> How I can do it?
>> Thanks,
>> ms_sql_characterset
>>
>>
>
>.
>|||By character set I guess you mean code page, or another name might be
collation setting. Unicode and collation are really two different things.
The collation setting of a server/database/column is how SQL Server stores
char, varchar, and text fields, which of course are not UNICODE data types.
This article should provide you with information about how to change the
collation settings of a server, a database and/or a column.
--
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
<anonymous@.discussions.microsoft.com> wrote in message
news:1c13001c45243$9c920c00$a301280a@.phx.gbl...
> Yes, I will alter them to nchar, nvarchar, and ntext. But
> where I can set sql server characterset to unicode?
> Thanks,
>
> >--Original Message--
> >If you want to change all you character data to unicode,
> you will need to
> >alter all your char, varchar, and text fields to nchar,
> nvarchar, and ntext
> >fields.
> >--
> >
> >----
> --
> >----
> --
> >--
> >
> >Need SQL Server Examples check out my website at
> >http://www.geocities.com/sqlserverexamples
> >"ms_sql_characterset"
> <anonymous@.discussions.microsoft.com> wrote in message
> >news:1c37301c4523a$8f26ec10$a101280a@.phx.gbl...
> >> Hi,
> >>
> >> I want to change characterset to Unicode in server
> 2000.
> >> How I can do it?
> >>
> >> Thanks,
> >>
> >> ms_sql_characterset
> >>
> >>
> >>
> >>
> >
> >
> >.
> >
How to change a database name in enterprise manager?
Hello,
I have a database in enterprise manager which has some tables.
I want to change the database name but I can't find a way.
I also tried to create a new database with the desired name and copy all
the tables to it. However I can't find a way to copy tables in
Enterprise Manager.
These things are really simple when using an Access database but I can't
find how to do it in MSSQL.
Can someone help me out?
Thank You,
Miguel
Use Query Analyzer instead of Enterprise Manager. The command you are looking for is ALTER DATABASE
(you find exact syntax in Books Online).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Shapper" <mdmoura*NOSPAM*@.gmail.*DELETE2SEND*com> wrote in message
news:ORYsQtARFHA.2972@.TK2MSFTNGP14.phx.gbl...
> Hello,
> I have a database in enterprise manager which has some tables.
> I want to change the database name but I can't find a way.
> I also tried to create a new database with the desired name and copy all the tables to it. However
> I can't find a way to copy tables in Enterprise Manager.
> These things are really simple when using an Access database but I can't find how to do it in
> MSSQL.
> Can someone help me out?
> Thank You,
> Miguel
>
|||sp_renamedb
Changes the name of a database.
Syntax
sp_renamedb [ @.dbname = ] 'old_name' ,
[ @.newname = ] 'new_name'
"Shapper" wrote:
> Hello,
> I have a database in enterprise manager which has some tables.
> I want to change the database name but I can't find a way.
> I also tried to create a new database with the desired name and copy all
> the tables to it. However I can't find a way to copy tables in
> Enterprise Manager.
> These things are really simple when using an Access database but I can't
> find how to do it in MSSQL.
> Can someone help me out?
> Thank You,
> Miguel
>
|||One reason I prefer ALTER DATABASE to sp_renamedb is that sp_renamedb will be removed in a future
version of SQL server. This is what Books Online for SQL Server 2005 has to say about sp_renamedb:
"This feature will be removed in a future version of SQL Server. Avoid using this feature in new
development work, and plan to modify applications that currently use the feature. Use ALTER DATABASE
MODIFY NAME instead. For more information, see ALTER DATABASE (Transact-SQL)."
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"andsm" <andsm@.discussions.microsoft.com> wrote in message
news:63041744-7DF9-4537-9C9B-B87F4B7CDBE9@.microsoft.com...[vbcol=seagreen]
> sp_renamedb
> Changes the name of a database.
> Syntax
> sp_renamedb [ @.dbname = ] 'old_name' ,
> [ @.newname = ] 'new_name'
>
> "Shapper" wrote:
I have a database in enterprise manager which has some tables.
I want to change the database name but I can't find a way.
I also tried to create a new database with the desired name and copy all
the tables to it. However I can't find a way to copy tables in
Enterprise Manager.
These things are really simple when using an Access database but I can't
find how to do it in MSSQL.
Can someone help me out?
Thank You,
Miguel
Use Query Analyzer instead of Enterprise Manager. The command you are looking for is ALTER DATABASE
(you find exact syntax in Books Online).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Shapper" <mdmoura*NOSPAM*@.gmail.*DELETE2SEND*com> wrote in message
news:ORYsQtARFHA.2972@.TK2MSFTNGP14.phx.gbl...
> Hello,
> I have a database in enterprise manager which has some tables.
> I want to change the database name but I can't find a way.
> I also tried to create a new database with the desired name and copy all the tables to it. However
> I can't find a way to copy tables in Enterprise Manager.
> These things are really simple when using an Access database but I can't find how to do it in
> MSSQL.
> Can someone help me out?
> Thank You,
> Miguel
>
|||sp_renamedb
Changes the name of a database.
Syntax
sp_renamedb [ @.dbname = ] 'old_name' ,
[ @.newname = ] 'new_name'
"Shapper" wrote:
> Hello,
> I have a database in enterprise manager which has some tables.
> I want to change the database name but I can't find a way.
> I also tried to create a new database with the desired name and copy all
> the tables to it. However I can't find a way to copy tables in
> Enterprise Manager.
> These things are really simple when using an Access database but I can't
> find how to do it in MSSQL.
> Can someone help me out?
> Thank You,
> Miguel
>
|||One reason I prefer ALTER DATABASE to sp_renamedb is that sp_renamedb will be removed in a future
version of SQL server. This is what Books Online for SQL Server 2005 has to say about sp_renamedb:
"This feature will be removed in a future version of SQL Server. Avoid using this feature in new
development work, and plan to modify applications that currently use the feature. Use ALTER DATABASE
MODIFY NAME instead. For more information, see ALTER DATABASE (Transact-SQL)."
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"andsm" <andsm@.discussions.microsoft.com> wrote in message
news:63041744-7DF9-4537-9C9B-B87F4B7CDBE9@.microsoft.com...[vbcol=seagreen]
> sp_renamedb
> Changes the name of a database.
> Syntax
> sp_renamedb [ @.dbname = ] 'old_name' ,
> [ @.newname = ] 'new_name'
>
> "Shapper" wrote:
How to change a database name in enterprise manager?
Hello,
I have a database in enterprise manager which has some tables.
I want to change the database name but I can't find a way.
I also tried to create a new database with the desired name and copy all
the tables to it. However I can't find a way to copy tables in
Enterprise Manager.
These things are really simple when using an Access database but I can't
find how to do it in MSSQL.
Can someone help me out?
Thank You,
MiguelUse Query Analyzer instead of Enterprise Manager. The command you are lookin
g for is ALTER DATABASE
(you find exact syntax in Books Online).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Shapper" <mdmoura*NOSPAM*@.gmail.*DELETE2SEND*com> wrote in message
news:ORYsQtARFHA.2972@.TK2MSFTNGP14.phx.gbl...
> Hello,
> I have a database in enterprise manager which has some tables.
> I want to change the database name but I can't find a way.
> I also tried to create a new database with the desired name and copy all t
he tables to it. However
> I can't find a way to copy tables in Enterprise Manager.
> These things are really simple when using an Access database but I can't f
ind how to do it in
> MSSQL.
> Can someone help me out?
> Thank You,
> Miguel
>|||sp_renamedb
Changes the name of a database.
Syntax
sp_renamedb [ @.dbname = ] 'old_name' ,
[ @.newname = ] 'new_name'
"Shapper" wrote:
> Hello,
> I have a database in enterprise manager which has some tables.
> I want to change the database name but I can't find a way.
> I also tried to create a new database with the desired name and copy all
> the tables to it. However I can't find a way to copy tables in
> Enterprise Manager.
> These things are really simple when using an Access database but I can't
> find how to do it in MSSQL.
> Can someone help me out?
> Thank You,
> Miguel
>|||One reason I prefer ALTER DATABASE to sp_renamedb is that sp_renamedb will b
e removed in a future
version of SQL server. This is what Books Online for SQL Server 2005 has to
say about sp_renamedb:
"This feature will be removed in a future version of SQL Server. Avoid using
this feature in new
development work, and plan to modify applications that currently use the fea
ture. Use ALTER DATABASE
MODIFY NAME instead. For more information, see ALTER DATABASE (Transact-SQL)
."
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"andsm" <andsm@.discussions.microsoft.com> wrote in message
news:63041744-7DF9-4537-9C9B-B87F4B7CDBE9@.microsoft.com...[vbcol=seagreen]
> sp_renamedb
> Changes the name of a database.
> Syntax
> sp_renamedb [ @.dbname = ] 'old_name' ,
> [ @.newname = ] 'new_name'
>
> "Shapper" wrote:
>
I have a database in enterprise manager which has some tables.
I want to change the database name but I can't find a way.
I also tried to create a new database with the desired name and copy all
the tables to it. However I can't find a way to copy tables in
Enterprise Manager.
These things are really simple when using an Access database but I can't
find how to do it in MSSQL.
Can someone help me out?
Thank You,
MiguelUse Query Analyzer instead of Enterprise Manager. The command you are lookin
g for is ALTER DATABASE
(you find exact syntax in Books Online).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Shapper" <mdmoura*NOSPAM*@.gmail.*DELETE2SEND*com> wrote in message
news:ORYsQtARFHA.2972@.TK2MSFTNGP14.phx.gbl...
> Hello,
> I have a database in enterprise manager which has some tables.
> I want to change the database name but I can't find a way.
> I also tried to create a new database with the desired name and copy all t
he tables to it. However
> I can't find a way to copy tables in Enterprise Manager.
> These things are really simple when using an Access database but I can't f
ind how to do it in
> MSSQL.
> Can someone help me out?
> Thank You,
> Miguel
>|||sp_renamedb
Changes the name of a database.
Syntax
sp_renamedb [ @.dbname = ] 'old_name' ,
[ @.newname = ] 'new_name'
"Shapper" wrote:
> Hello,
> I have a database in enterprise manager which has some tables.
> I want to change the database name but I can't find a way.
> I also tried to create a new database with the desired name and copy all
> the tables to it. However I can't find a way to copy tables in
> Enterprise Manager.
> These things are really simple when using an Access database but I can't
> find how to do it in MSSQL.
> Can someone help me out?
> Thank You,
> Miguel
>|||One reason I prefer ALTER DATABASE to sp_renamedb is that sp_renamedb will b
e removed in a future
version of SQL server. This is what Books Online for SQL Server 2005 has to
say about sp_renamedb:
"This feature will be removed in a future version of SQL Server. Avoid using
this feature in new
development work, and plan to modify applications that currently use the fea
ture. Use ALTER DATABASE
MODIFY NAME instead. For more information, see ALTER DATABASE (Transact-SQL)
."
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"andsm" <andsm@.discussions.microsoft.com> wrote in message
news:63041744-7DF9-4537-9C9B-B87F4B7CDBE9@.microsoft.com...[vbcol=seagreen]
> sp_renamedb
> Changes the name of a database.
> Syntax
> sp_renamedb [ @.dbname = ] 'old_name' ,
> [ @.newname = ] 'new_name'
>
> "Shapper" wrote:
>
How to change a database name in enterprise manager?
Hello,
I have a database in enterprise manager which has some tables.
I want to change the database name but I can't find a way.
I also tried to create a new database with the desired name and copy all
the tables to it. However I can't find a way to copy tables in
Enterprise Manager.
These things are really simple when using an Access database but I can't
find how to do it in MSSQL.
Can someone help me out?
Thank You,
MiguelUse Query Analyzer instead of Enterprise Manager. The command you are looking for is ALTER DATABASE
(you find exact syntax in Books Online).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Shapper" <mdmoura*NOSPAM*@.gmail.*DELETE2SEND*com> wrote in message
news:ORYsQtARFHA.2972@.TK2MSFTNGP14.phx.gbl...
> Hello,
> I have a database in enterprise manager which has some tables.
> I want to change the database name but I can't find a way.
> I also tried to create a new database with the desired name and copy all the tables to it. However
> I can't find a way to copy tables in Enterprise Manager.
> These things are really simple when using an Access database but I can't find how to do it in
> MSSQL.
> Can someone help me out?
> Thank You,
> Miguel
>|||sp_renamedb
Changes the name of a database.
Syntax
sp_renamedb [ @.dbname = ] 'old_name' ,
[ @.newname = ] 'new_name'
"Shapper" wrote:
> Hello,
> I have a database in enterprise manager which has some tables.
> I want to change the database name but I can't find a way.
> I also tried to create a new database with the desired name and copy all
> the tables to it. However I can't find a way to copy tables in
> Enterprise Manager.
> These things are really simple when using an Access database but I can't
> find how to do it in MSSQL.
> Can someone help me out?
> Thank You,
> Miguel
>|||One reason I prefer ALTER DATABASE to sp_renamedb is that sp_renamedb will be removed in a future
version of SQL server. This is what Books Online for SQL Server 2005 has to say about sp_renamedb:
"This feature will be removed in a future version of SQL Server. Avoid using this feature in new
development work, and plan to modify applications that currently use the feature. Use ALTER DATABASE
MODIFY NAME instead. For more information, see ALTER DATABASE (Transact-SQL)."
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"andsm" <andsm@.discussions.microsoft.com> wrote in message
news:63041744-7DF9-4537-9C9B-B87F4B7CDBE9@.microsoft.com...
> sp_renamedb
> Changes the name of a database.
> Syntax
> sp_renamedb [ @.dbname = ] 'old_name' ,
> [ @.newname = ] 'new_name'
>
> "Shapper" wrote:
>> Hello,
>> I have a database in enterprise manager which has some tables.
>> I want to change the database name but I can't find a way.
>> I also tried to create a new database with the desired name and copy all
>> the tables to it. However I can't find a way to copy tables in
>> Enterprise Manager.
>> These things are really simple when using an Access database but I can't
>> find how to do it in MSSQL.
>> Can someone help me out?
>> Thank You,
>> Miguel
>>
I have a database in enterprise manager which has some tables.
I want to change the database name but I can't find a way.
I also tried to create a new database with the desired name and copy all
the tables to it. However I can't find a way to copy tables in
Enterprise Manager.
These things are really simple when using an Access database but I can't
find how to do it in MSSQL.
Can someone help me out?
Thank You,
MiguelUse Query Analyzer instead of Enterprise Manager. The command you are looking for is ALTER DATABASE
(you find exact syntax in Books Online).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Shapper" <mdmoura*NOSPAM*@.gmail.*DELETE2SEND*com> wrote in message
news:ORYsQtARFHA.2972@.TK2MSFTNGP14.phx.gbl...
> Hello,
> I have a database in enterprise manager which has some tables.
> I want to change the database name but I can't find a way.
> I also tried to create a new database with the desired name and copy all the tables to it. However
> I can't find a way to copy tables in Enterprise Manager.
> These things are really simple when using an Access database but I can't find how to do it in
> MSSQL.
> Can someone help me out?
> Thank You,
> Miguel
>|||sp_renamedb
Changes the name of a database.
Syntax
sp_renamedb [ @.dbname = ] 'old_name' ,
[ @.newname = ] 'new_name'
"Shapper" wrote:
> Hello,
> I have a database in enterprise manager which has some tables.
> I want to change the database name but I can't find a way.
> I also tried to create a new database with the desired name and copy all
> the tables to it. However I can't find a way to copy tables in
> Enterprise Manager.
> These things are really simple when using an Access database but I can't
> find how to do it in MSSQL.
> Can someone help me out?
> Thank You,
> Miguel
>|||One reason I prefer ALTER DATABASE to sp_renamedb is that sp_renamedb will be removed in a future
version of SQL server. This is what Books Online for SQL Server 2005 has to say about sp_renamedb:
"This feature will be removed in a future version of SQL Server. Avoid using this feature in new
development work, and plan to modify applications that currently use the feature. Use ALTER DATABASE
MODIFY NAME instead. For more information, see ALTER DATABASE (Transact-SQL)."
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"andsm" <andsm@.discussions.microsoft.com> wrote in message
news:63041744-7DF9-4537-9C9B-B87F4B7CDBE9@.microsoft.com...
> sp_renamedb
> Changes the name of a database.
> Syntax
> sp_renamedb [ @.dbname = ] 'old_name' ,
> [ @.newname = ] 'new_name'
>
> "Shapper" wrote:
>> Hello,
>> I have a database in enterprise manager which has some tables.
>> I want to change the database name but I can't find a way.
>> I also tried to create a new database with the desired name and copy all
>> the tables to it. However I can't find a way to copy tables in
>> Enterprise Manager.
>> These things are really simple when using an Access database but I can't
>> find how to do it in MSSQL.
>> Can someone help me out?
>> Thank You,
>> Miguel
>>
Friday, March 9, 2012
How to call a stored procedure in a scheduled job
Hi All,
I have a stored procedure.
I need to create a scheduled job using that stored procedure.
I went to Enterprise Manager -->Management--> Jobs-->New Job
Properties
In the step tab, I can select db and put the codes.
Instead of writing the code there, I want to call the stored procedure
in the command box.
How can I do that?
System: MS SQL Server 2000
I would highly appreciate your help.
Thanks a million in advance.
Best regards,
mamunIn the Type Dropdown, select T-SQL & call your stored procedure like:
EXEC usp...
--
- Anith
( Please reply to newsgroups only )
Sunday, February 19, 2012
How to browse INFORMATION_SCHEMA in Enterprise Manager
Dear all,
I try to (select * from information_schema.columns). It
works ok in query analyzer. But how can I access the information_schema
tables in Enterprise Manager? I try to browse all database, but I
cannot located where is information_schema located in? i.e. Which
database the information_schema is located in that I can browse in
Enterprise Manager?
ThanksI assume you are on 2000? These views only physically exists in the master d
atabase, so unless it is
master you want to look at, EM won't work. Use Query Analyzer and type your
queries instead.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"hon123456" <peterhon321@.yahoo.com.hk> wrote in message
news:1145342246.110319.286500@.u72g2000cwu.googlegroups.com...
> Dear all,
> I try to (select * from information_schema.columns). It
> works ok in query analyzer. But how can I access the information_schema
> tables in Enterprise Manager? I try to browse all database, but I
> cannot located where is information_schema located in? i.e. Which
> database the information_schema is located in that I can browse in
> Enterprise Manager?
> Thanks
>
I try to (select * from information_schema.columns). It
works ok in query analyzer. But how can I access the information_schema
tables in Enterprise Manager? I try to browse all database, but I
cannot located where is information_schema located in? i.e. Which
database the information_schema is located in that I can browse in
Enterprise Manager?
ThanksI assume you are on 2000? These views only physically exists in the master d
atabase, so unless it is
master you want to look at, EM won't work. Use Query Analyzer and type your
queries instead.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"hon123456" <peterhon321@.yahoo.com.hk> wrote in message
news:1145342246.110319.286500@.u72g2000cwu.googlegroups.com...
> Dear all,
> I try to (select * from information_schema.columns). It
> works ok in query analyzer. But how can I access the information_schema
> tables in Enterprise Manager? I try to browse all database, but I
> cannot located where is information_schema located in? i.e. Which
> database the information_schema is located in that I can browse in
> Enterprise Manager?
> Thanks
>
Subscribe to:
Posts (Atom)