Changing the SQL SErver DOmain

Hello,
Anybody knows what's the effects caused by a Server Domains Change?
I'm planning to change a Domain of my SQL Server that actually has a trust
with the current Domain of this server.
I think that I don't need to do nothing after this change. I'm correct?
Thanks
Juliano Horta
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums.aspx/sql-server/200703/1
Hello,
Take a look into the google archive for the similar topic.
[url]http://groups.google.com/group/microsoft.public.sqlserver.connect/browse_frm/thread/3533c9535e06f49e/b6ea4289a0ead18c?lnk=st&q=changing+sql+server+doma in&rnum=19&hl=en#b6ea4289a0ead18c[/url]
Thanks
Hari
"julianohorta via droptable.com" <u13014@.uwe> wrote in message
news:6e89b9509fcf6@.uwe...
> Hello,
> Anybody knows what's the effects caused by a Server Domains Change?
> I'm planning to change a Domain of my SQL Server that actually has a trust
> with the current Domain of this server.
> I think that I don't need to do nothing after this change. I'm correct?
> Thanks
> Juliano Horta
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums.aspx/sql-server/200703/1
>
sql

Changing the SQL SErver DOmain

Hello,
Anybody knows what's the effects caused by a Server Domains Change?
I'm planning to change a Domain of my SQL Server that actually has a trust
with the current Domain of this server.
I think that I don't need to do nothing after this change. I'm correct?
Thanks
Juliano Horta
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200703/1Hello,
Take a look into the google archive for the similar topic.
http://groups.google.com/group/microsoft.public.sqlserver.connect/browse_frm/thread/3533c9535e06f49e/b6ea4289a0ead18c?lnk=st&q=changing+sql+server+domain&rnum=19&hl=en#b6ea4289a0ead18c
Thanks
Hari
"julianohorta via SQLMonster.com" <u13014@.uwe> wrote in message
news:6e89b9509fcf6@.uwe...
> Hello,
> Anybody knows what's the effects caused by a Server Domains Change?
> I'm planning to change a Domain of my SQL Server that actually has a trust
> with the current Domain of this server.
> I think that I don't need to do nothing after this change. I'm correct?
> Thanks
> Juliano Horta
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200703/1
>

Changing the SQL SErver DOmain

Hello,
Anybody knows what's the effects caused by a Server Domains Change?
I'm planning to change a Domain of my SQL Server that actually has a trust
with the current Domain of this server.
I think that I don't need to do nothing after this change. I'm correct?
Thanks
Juliano Horta
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200703/1Hello,
Take a look into the google archive for the similar topic.
http://groups.google.com/group/micr...6ea4289a0ead18c
Thanks
Hari
"julianohorta via droptable.com" <u13014@.uwe> wrote in message
news:6e89b9509fcf6@.uwe...
> Hello,
> Anybody knows what's the effects caused by a Server Domains Change?
> I'm planning to change a Domain of my SQL Server that actually has a trust
> with the current Domain of this server.
> I think that I don't need to do nothing after this change. I'm correct?
> Thanks
> Juliano Horta
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200703/1
>

Changing The Physical Server

Hi,
I have Production Database on one server which shares the space with
many other databases. Now I am planning to shift the database to
another (separate) physical server.
As long as data and logins are concerned I can transfer it to the
new database server. But I also have many of the critical scheduled
Jobs and DTS packages on the existing server. Is there any way through
which I can get these DTS packages and Jobs on the new server?
regards
Rohit
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/Server-Chang...ict250272.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=866311
DTS packages -- Open the package, Menu Package --> Save as... 1. to a new
server, or 2. structured storage file, import the file in the new server
Jobs -- Right click on the job, Generate SQL Script...
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Rohit" wrote:

> Hi,
> I have Production Database on one server which shares the space with
> many other databases. Now I am planning to shift the database to
> another (separate) physical server.
> As long as data and logins are concerned I can transfer it to the
> new database server. But I also have many of the critical scheduled
> Jobs and DTS packages on the existing server. Is there any way through
> which I can get these DTS packages and Jobs on the new server?
> regards
> Rohit
> --
> Posted using the http://www.dbforumz.com interface, at author's request
> Articles individually checked for conformance to usenet standards
> Topic URL: http://www.dbforumz.com/Server-Chang...ict250272.html
> Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=866311
>
|||Hi
You may want to look at using:
http://www.sqldts.com/default.aspx?242
Also check out:
http://support.microsoft.com/default...;en-us;Q314546
John
"Rohit" wrote:

> Hi,
> I have Production Database on one server which shares the space with
> many other databases. Now I am planning to shift the database to
> another (separate) physical server.
> As long as data and logins are concerned I can transfer it to the
> new database server. But I also have many of the critical scheduled
> Jobs and DTS packages on the existing server. Is there any way through
> which I can get these DTS packages and Jobs on the new server?
> regards
> Rohit
> --
> Posted using the http://www.dbforumz.com interface, at author's request
> Articles individually checked for conformance to usenet standards
> Topic URL: http://www.dbforumz.com/Server-Chang...ict250272.html
> Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=866311
>
sql

Changing The Physical Server

Hi,
I have Production Database on one server which shares the space with
many other databases. Now I am planning to shift the database to
another (separate) physical server.
As long as data and logins are concerned I can transfer it to the
new database server. But I also have many of the critical scheduled
Jobs and DTS packages on the existing server. Is there any way through
which I can get these DTS packages and Jobs on the new server?
regards
Rohit
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/Server-Chan...rm.php?p=866311DTS packages -- Open the package, Menu Package --> Save as... 1. to a new
server, or 2. structured storage file, import the file in the new server
Jobs -- Right click on the job, Generate SQL Script...
--
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Rohit" wrote:

> Hi,
> I have Production Database on one server which shares the space with
> many other databases. Now I am planning to shift the database to
> another (separate) physical server.
> As long as data and logins are concerned I can transfer it to the
> new database server. But I also have many of the critical scheduled
> Jobs and DTS packages on the existing server. Is there any way through
> which I can get these DTS packages and Jobs on the new server?
> regards
> Rohit
> --
> Posted using the http://www.dbforumz.com interface, at author's request
> Articles individually checked for conformance to usenet standards
> Topic URL: http://www.dbforumz.com/Server-Chan...rm.php?p=866311
>|||Hi
You may want to look at using:
http://www.sqldts.com/default.aspx?242
Also check out:
http://support.microsoft.com/defaul...b;en-us;Q314546
John
"Rohit" wrote:

> Hi,
> I have Production Database on one server which shares the space with
> many other databases. Now I am planning to shift the database to
> another (separate) physical server.
> As long as data and logins are concerned I can transfer it to the
> new database server. But I also have many of the critical scheduled
> Jobs and DTS packages on the existing server. Is there any way through
> which I can get these DTS packages and Jobs on the new server?
> regards
> Rohit
> --
> Posted using the http://www.dbforumz.com interface, at author's request
> Articles individually checked for conformance to usenet standards
> Topic URL: http://www.dbforumz.com/Server-Chan...rm.php?p=866311
>

Changing The Physical Server

Hi,
I have Production Database on one server which shares the space with
many other databases. Now I am planning to shift the database to
another (separate) physical server.
As long as data and logins are concerned I can transfer it to the
new database server. But I also have many of the critical scheduled
Jobs and DTS packages on the existing server. Is there any way through
which I can get these DTS packages and Jobs on the new server?
regards
Rohit
--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/Server-Changing-Physical-ftopict250272.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=866311DTS packages -- Open the package, Menu Package --> Save as... 1. to a new
server, or 2. structured storage file, import the file in the new server
Jobs -- Right click on the job, Generate SQL Script...
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Rohit" wrote:
> Hi,
> I have Production Database on one server which shares the space with
> many other databases. Now I am planning to shift the database to
> another (separate) physical server.
> As long as data and logins are concerned I can transfer it to the
> new database server. But I also have many of the critical scheduled
> Jobs and DTS packages on the existing server. Is there any way through
> which I can get these DTS packages and Jobs on the new server?
> regards
> Rohit
> --
> Posted using the http://www.dbforumz.com interface, at author's request
> Articles individually checked for conformance to usenet standards
> Topic URL: http://www.dbforumz.com/Server-Changing-Physical-ftopict250272.html
> Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=866311
>|||Hi
You may want to look at using:
http://www.sqldts.com/default.aspx?242
Also check out:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546
John
"Rohit" wrote:
> Hi,
> I have Production Database on one server which shares the space with
> many other databases. Now I am planning to shift the database to
> another (separate) physical server.
> As long as data and logins are concerned I can transfer it to the
> new database server. But I also have many of the critical scheduled
> Jobs and DTS packages on the existing server. Is there any way through
> which I can get these DTS packages and Jobs on the new server?
> regards
> Rohit
> --
> Posted using the http://www.dbforumz.com interface, at author's request
> Articles individually checked for conformance to usenet standards
> Topic URL: http://www.dbforumz.com/Server-Changing-Physical-ftopict250272.html
> Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=866311
>

changing SQL server service account

Guys,
I have got WINDOWS 2000 Advanced Server and MS SQL SERVER 7.0 running on my live server. Now when we are planning for replication, we have found that SQL server will require to run under a domain account. At the moment there are so many ASP pages running on our server accesses different databases created using SQL server 7.0. Most of them are DSN connections to the database. Now if i create a domain account and restart the server and MS SQL services with the domain account, how is it going to effect the current web pages running on it?
Any help will be greatly appreciated.
ThanksA connection to a database has no bearing on what account starts the sql server service. However the account used does affect how the server interacts with other sql servers, or other machine resources, you found that out when you tried to implement replication using LocalSystem account. You can search msdn for "sql server service account" to get a better understanding of the purpose of accounts for sql server.|||Thanks very much Greg,
your reply helped me to have better understanding.
I would find out more from MSDN as you have suggested.
Cheers.

changing sa password

hi everyone
i am planning to change sa password in my Development server as too many
people know the password. I am trying this first time.
Can someone please let me know any impacts of changing sa password?
or I can change the password as normal way to changing password.
Thank you
syed
*** Sent via Developersdex http://www.codecomments.com ***Hi
If you have an application that connected to the SQL Server wit a Mixed Mode
, so you will have to change the password there. As well as Linked Servers
that was defined by providing username and password. And finally , if you
was connected to the EM by an old password the error will be thrown.
"Syed Hussain" <syedkhalidhussain@.gmail.com> wrote in message
news:Ofr8Ux%23mFHA.420@.TK2MSFTNGP09.phx.gbl...
> hi everyone
> i am planning to change sa password in my Development server as too many
> people know the password. I am trying this first time.
> Can someone please let me know any impacts of changing sa password?
> or I can change the password as normal way to changing password.
> Thank you
> syed
> *** Sent via Developersdex http://www.codecomments.com ***|||Hi,
To Add on to Uri;
Execute sp_who in frequent intervals and identify the users / application
who are using SA user to access sql server. Then send out an
email to all of them intimating that you are going to change the password
for SA.
Give them some time to change and after that do below:-
1. Change the Applcation connection strings to use new user
2. Change the Linked server security credentials if SA is used
3. EM registrations if you store password ( Avoid storing passwords)
Thanks
Hari
SQL Server MVP
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:eZGrB0%23mFHA.3288@.TK2MSFTNGP09.phx.gbl...
> Hi
> If you have an application that connected to the SQL Server wit a Mixed
> Mode , so you will have to change the password there. As well as Linked
> Servers that was defined by providing username and password. And finally ,
> if you was connected to the EM by an old password the error will be
> thrown.
>
>
> "Syed Hussain" <syedkhalidhussain@.gmail.com> wrote in message
> news:Ofr8Ux%23mFHA.420@.TK2MSFTNGP09.phx.gbl...
>|||And once you've changed the password, stop using sa to log in to SQL Server.
You
should create logins for people who really need sysadmin privileges so that
you
don't get this problem again.
Don
On Mon, 8 Aug 2005 16:46:40 +0530, "Hari Prasad" <hari_prasad_k@.hotmail.com>
wrote:

>Hi,
>To Add on to Uri;
>Execute sp_who in frequent intervals and identify the users / application
>who are using SA user to access sql server. Then send out an
>email to all of them intimating that you are going to change the password
>for SA.
>Give them some time to change and after that do below:-
>1. Change the Applcation connection strings to use new user
>2. Change the Linked server security credentials if SA is used
>3. EM registrations if you store password ( Avoid storing passwords)
>Thanks
>Hari
>SQL Server MVP
>
>"Uri Dimant" <urid@.iscar.co.il> wrote in message
>news:eZGrB0%23mFHA.3288@.TK2MSFTNGP09.phx.gbl...
>|||If you have scripts which hardcoded sa password, then it will be a problem.
Eric King
AgileInfoSoftware
http://www.agileinfollc.com
"Syed Hussain" <syedkhalidhussain@.gmail.com> wrote in message
news:Ofr8Ux%23mFHA.420@.TK2MSFTNGP09.phx.gbl...
> hi everyone
> i am planning to change sa password in my Development server as too many
> people know the password. I am trying this first time.
> Can someone please let me know any impacts of changing sa password?
> or I can change the password as normal way to changing password.
> Thank you
> syed
> *** Sent via Developersdex http://www.codecomments.com ***

Changing IP addresses

We are planning on changing IP addresses on two database
servers that have SQL transactional replication between
them. Before I get into any trouble, do you see any
problem that could occur regarding the replication
communication between the servers. My plan is to change
the IP addresses and reboot the servers. I won't know
until I do this if the replication will start back up
successfully.
replication is insensitive to IP address changes.
there are some caveats
1) if you are using the client network utility to associate the IP address with the machine name you will have to update the ip addresses
2) if you are using a hosts file for name lookup s to associate the IP address with the machine name you will have to update the ip addresses in this file
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Jeff Steinweber" wrote:

> We are planning on changing IP addresses on two database
> servers that have SQL transactional replication between
> them. Before I get into any trouble, do you see any
> problem that could occur regarding the replication
> communication between the servers. My plan is to change
> the IP addresses and reboot the servers. I won't know
> until I do this if the replication will start back up
> successfully.
>

Changing Default Names

I am planning to change the default names from
'DF__tablename__columnname_28F7FFC9'to
'tablename_columnname_df'.
Depending on the number of default columns 'df1, df2,
df3 ....e.t.c' will be added.
I am going to rename them in the 'sysobjects' table where
I see the only location for them.
Is there any side effects to this ?.
Thanks for any help.Hard to say if there are side effects; it's not the supported way of
renaming objects. Instead, use sp_rename. Look up syntax in BOL.
"Dave" <anonymous@.discussions.microsoft.com> wrote in message
news:1444801c4182b$45f41160$a601280a@.phx
.gbl...
> I am planning to change the default names from
> 'DF__tablename__columnname_28F7FFC9'to
> 'tablename_columnname_df'.
> Depending on the number of default columns 'df1, df2,
> df3 ....e.t.c' will be added.
> I am going to rename them in the 'sysobjects' table where
> I see the only location for them.
> Is there any side effects to this ?.
> Thanks for any help.|||I can not use sp_rename because the defaults are not
recognized as objects.

>--Original Message--
>Hard to say if there are side effects; it's not the
supported way of
>renaming objects. Instead, use sp_rename. Look up
syntax in BOL.
>
>"Dave" <anonymous@.discussions.microsoft.com> wrote in
message
> news:1444801c4182b$45f41160$a601280a@.phx
.gbl...
where
>
>.
>|||It works for me... Does the following work for you:
create table a(id int)
GO
create table b (id int)
GO
alter table b add constraint r_b check (id = 1)
GO
sp_rename 'r_b', 'r_c', 'object'
GO
"Dave" <anonymous@.discussions.microsoft.com> wrote in message
news:1722a01c4182f$5d987aa0$a401280a@.phx
.gbl...
> I can not use sp_rename because the defaults are not
> recognized as objects.
>
> supported way of
> syntax in BOL.
> message
> where|||sorry, that was a CHECK constraint... here's a default:
create table a(id int)
GO
create table b (id int)
GO
alter table b add constraint r_b default (1) for id
GO
sp_rename 'r_b', 'r_c', 'object'
GO
"Adam Machanic" <amachanic@.air-worldwide.nospamallowed.com> wrote in message
news:#oIt9BDGEHA.4044@.TK2MSFTNGP10.phx.gbl...
> It works for me... Does the following work for you:
>
> create table a(id int)
> GO
> create table b (id int)
> GO
> alter table b add constraint r_b check (id = 1)
> GO
> sp_rename 'r_b', 'r_c', 'object'
> GO
> "Dave" <anonymous@.discussions.microsoft.com> wrote in message
> news:1722a01c4182f$5d987aa0$a401280a@.phx
.gbl...
>|||NO. Here is what I am running:
sp_rename 'DF__admuserpr__origi__2B0043CC', 'admuserpr_orig
i_df', 'object'
Here is what I get:
Server: Msg 15248, Level 11, State 1, Procedure sp_rename,
Line 223
Either the parameter @.objname is ambiguous or the claimed
@.objtype (object) is wrong.

>--Original Message--
>sorry, that was a CHECK constraint... here's a default:
>
>create table a(id int)
>GO
>create table b (id int)
>GO
>alter table b add constraint r_b default (1) for id
>GO
>sp_rename 'r_b', 'r_c', 'object'
>GO
>"Adam Machanic" <amachanic@.air-
worldwide.nospamallowed.com> wrote in message
>news:#oIt9BDGEHA.4044@.TK2MSFTNGP10.phx.gbl...
message
df2,
>
>.
>|||I just tried the same thing on my server, with no problem. Created the
default using the DEFAULT(n) syntax...
What version are you running?
"Dave" <anonymous@.discussions.microsoft.com> wrote in message
news:1725d01c41833$5dffcb20$a401280a@.phx
.gbl...
> NO. Here is what I am running:
> sp_rename 'DF__admuserpr__origi__2B0043CC', 'admuserpr_orig
> i_df', 'object'
>
> Here is what I get:
> Server: Msg 15248, Level 11, State 1, Procedure sp_rename,
> Line 223
> Either the parameter @.objname is ambiguous or the claimed
> @.objtype (object) is wrong.
>
>
> worldwide.nospamallowed.com> wrote in message
> message
> df2,|||Hi Dave
Is it possible the constraint has a different owner than the user you are
currently connected as?
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Dave" <anonymous@.discussions.microsoft.com> wrote in message
news:1725d01c41833$5dffcb20$a401280a@.phx
.gbl...
> NO. Here is what I am running:
> sp_rename 'DF__admuserpr__origi__2B0043CC', 'admuserpr_orig
> i_df', 'object'
>
> Here is what I get:
> Server: Msg 15248, Level 11, State 1, Procedure sp_rename,
> Line 223
> Either the parameter @.objname is ambiguous or the claimed
> @.objtype (object) is wrong.
>
>
> worldwide.nospamallowed.com> wrote in message
> message
> df2,|||I am connecting as sysadmin.

>--Original Message--
>Hi Dave
>Is it possible the constraint has a different owner than
the user you are
>currently connected as?
>--
>HTH
>--
>Kalen Delaney
>SQL Server MVP
>www.SolidQualityLearning.com
>
>"Dave" <anonymous@.discussions.microsoft.com> wrote in
message
> news:1725d01c41833$5dffcb20$a401280a@.phx
.gbl...
sp_rename 'DF__admuserpr__origi__2B0043CC', 'admuserpr_orig
sp_rename,
claimed
not
the
up
wrote in
table
>
>.
>|||SQL Server 2000 SP3.

>--Original Message--
>I just tried the same thing on my server, with no
problem. Created the
>default using the DEFAULT(n) syntax...
>What version are you running?
>
>"Dave" <anonymous@.discussions.microsoft.com> wrote in
message
> news:1725d01c41833$5dffcb20$a401280a@.phx
.gbl...
sp_rename 'DF__admuserpr__origi__2B0043CC', 'admuserpr_orig
sp_rename,
claimed
not
the
up
wrote in
table
>
>.
>

Changing Default Names

I am planning to change the default names from
'DF__tablename__columnname_28F7FFC9'to
'tablename_columnname_df'.
Depending on the number of default columns 'df1, df2,
df3 ....e.t.c' will be added.
I am going to rename them in the 'sysobjects' table where
I see the only location for them.
Is there any side effects to this ?.
Thanks for any help.
Hard to say if there are side effects; it's not the supported way of
renaming objects. Instead, use sp_rename. Look up syntax in BOL.
"Dave" <anonymous@.discussions.microsoft.com> wrote in message
news:1444801c4182b$45f41160$a601280a@.phx.gbl...
> I am planning to change the default names from
> 'DF__tablename__columnname_28F7FFC9'to
> 'tablename_columnname_df'.
> Depending on the number of default columns 'df1, df2,
> df3 ....e.t.c' will be added.
> I am going to rename them in the 'sysobjects' table where
> I see the only location for them.
> Is there any side effects to this ?.
> Thanks for any help.
|||I can not use sp_rename because the defaults are not
recognized as objects.

>--Original Message--
>Hard to say if there are side effects; it's not the
supported way of
>renaming objects. Instead, use sp_rename. Look up
syntax in BOL.
>
>"Dave" <anonymous@.discussions.microsoft.com> wrote in
message
>news:1444801c4182b$45f41160$a601280a@.phx.gbl...
where
>
>.
>
|||It works for me... Does the following work for you:
create table a(id int)
GO
create table b (id int)
GO
alter table b add constraint r_b check (id = 1)
GO
sp_rename 'r_b', 'r_c', 'object'
GO
"Dave" <anonymous@.discussions.microsoft.com> wrote in message
news:1722a01c4182f$5d987aa0$a401280a@.phx.gbl...
> I can not use sp_rename because the defaults are not
> recognized as objects.
>
> supported way of
> syntax in BOL.
> message
> where
|||sorry, that was a CHECK constraint... here's a default:
create table a(id int)
GO
create table b (id int)
GO
alter table b add constraint r_b default (1) for id
GO
sp_rename 'r_b', 'r_c', 'object'
GO
"Adam Machanic" <amachanic@.air-worldwide.nospamallowed.com> wrote in message
news:#oIt9BDGEHA.4044@.TK2MSFTNGP10.phx.gbl...
> It works for me... Does the following work for you:
>
> create table a(id int)
> GO
> create table b (id int)
> GO
> alter table b add constraint r_b check (id = 1)
> GO
> sp_rename 'r_b', 'r_c', 'object'
> GO
> "Dave" <anonymous@.discussions.microsoft.com> wrote in message
> news:1722a01c4182f$5d987aa0$a401280a@.phx.gbl...
>
|||NO. Here is what I am running:
sp_rename 'DF__admuserpr__origi__2B0043CC', 'admuserpr_orig
i_df', 'object'
Here is what I get:
Server: Msg 15248, Level 11, State 1, Procedure sp_rename,
Line 223
Either the parameter @.objname is ambiguous or the claimed
@.objtype (object) is wrong.

>--Original Message--
>sorry, that was a CHECK constraint... here's a default:
>
>create table a(id int)
>GO
>create table b (id int)
>GO
>alter table b add constraint r_b default (1) for id
>GO
>sp_rename 'r_b', 'r_c', 'object'
>GO
>"Adam Machanic" <amachanic@.air-
worldwide.nospamallowed.com> wrote in message
>news:#oIt9BDGEHA.4044@.TK2MSFTNGP10.phx.gbl...
message
df2,
>
>.
>
|||I just tried the same thing on my server, with no problem. Created the
default using the DEFAULT(n) syntax...
What version are you running?
"Dave" <anonymous@.discussions.microsoft.com> wrote in message
news:1725d01c41833$5dffcb20$a401280a@.phx.gbl...
> NO. Here is what I am running:
> sp_rename 'DF__admuserpr__origi__2B0043CC', 'admuserpr_orig
> i_df', 'object'
>
> Here is what I get:
> Server: Msg 15248, Level 11, State 1, Procedure sp_rename,
> Line 223
> Either the parameter @.objname is ambiguous or the claimed
> @.objtype (object) is wrong.
>
> worldwide.nospamallowed.com> wrote in message
> message
> df2,
|||Hi Dave
Is it possible the constraint has a different owner than the user you are
currently connected as?
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Dave" <anonymous@.discussions.microsoft.com> wrote in message
news:1725d01c41833$5dffcb20$a401280a@.phx.gbl...
> NO. Here is what I am running:
> sp_rename 'DF__admuserpr__origi__2B0043CC', 'admuserpr_orig
> i_df', 'object'
>
> Here is what I get:
> Server: Msg 15248, Level 11, State 1, Procedure sp_rename,
> Line 223
> Either the parameter @.objname is ambiguous or the claimed
> @.objtype (object) is wrong.
>
> worldwide.nospamallowed.com> wrote in message
> message
> df2,
|||I am connecting as sysadmin.

>--Original Message--
>Hi Dave
>Is it possible the constraint has a different owner than
the user you are
>currently connected as?
>--
>HTH
>--
>Kalen Delaney
>SQL Server MVP
>www.SolidQualityLearning.com
>
>"Dave" <anonymous@.discussions.microsoft.com> wrote in
message
>news:1725d01c41833$5dffcb20$a401280a@.phx.gbl...
sp_rename 'DF__admuserpr__origi__2B0043CC', 'admuserpr_orig
sp_rename,
claimed
not
the
up
wrote in
table
>
>.
>
|||SQL Server 2000 SP3.

>--Original Message--
>I just tried the same thing on my server, with no
problem. Created the
>default using the DEFAULT(n) syntax...
>What version are you running?
>
>"Dave" <anonymous@.discussions.microsoft.com> wrote in
message
>news:1725d01c41833$5dffcb20$a401280a@.phx.gbl...
sp_rename 'DF__admuserpr__origi__2B0043CC', 'admuserpr_orig
sp_rename,
claimed
not
the
up
wrote in
table
>
>.
>

Changing Database Structure After Application Deployment

Hi,
We're planning to rewrite a program of ours from ms-dos with a dbase
database to windows using ado and msaccess or sqlserver 2000. now we have
the problem of database maintenance. because the program is going to be
deployed to multiple customers, we don't want to manually change the
database structure. In dos we had a mechanism with a table which stored the
table definitions, and a table which stored the index definitions. now we
want something similiar to that for windows, and it would be even nicer if
the solution is crossdatabase. it's fine if the "new" database structure(the
structure which the customer doesn't have) is stored in an xml file or
similar.
thanks in advance,
Matthijs ter Woord
if you want to version your databases check out DB Ghost - www.dbghost.com
"M. ter Woord" wrote:

> Hi,
> We're planning to rewrite a program of ours from ms-dos with a dbase
> database to windows using ado and msaccess or sqlserver 2000. now we have
> the problem of database maintenance. because the program is going to be
> deployed to multiple customers, we don't want to manually change the
> database structure. In dos we had a mechanism with a table which stored the
> table definitions, and a table which stored the index definitions. now we
> want something similiar to that for windows, and it would be even nicer if
> the solution is crossdatabase. it's fine if the "new" database structure(the
> structure which the customer doesn't have) is stored in an xml file or
> similar.
>
> thanks in advance,
> Matthijs ter Woord
>
>
|||Can somebody think of a solution which i can build myself?
Matthijs
"mark baekdal" <markbaekdal@.discussions.microsoft.com> schreef in bericht
news:821F7892-552F-4784-9D0A-A3E36D615735@.microsoft.com...
> if you want to version your databases check out DB Ghost -
www.dbghost.com[vbcol=seagreen]
> "M. ter Woord" wrote:
have[vbcol=seagreen]
the[vbcol=seagreen]
we[vbcol=seagreen]
if[vbcol=seagreen]
structure(the[vbcol=seagreen]