Changed user p/w, can't start Sql Server

Hi;
I am running Sql Server dev edition on my home system - not on a domain.
When I installed I selecgted mixed security so can have user/pw ad well as
SSPI. I told it to run the server using my login.
I changed the password for my Windows login and Sql Server will now not
start. If I change back to the old pw it will. How do I get it to update the
pw for my username for when it starts?
thanks - dave"David Thielen" <thielen@.nospam.nospam> wrote in message
news:30A6CEF8-15F4-4C42-9796-F769CCFADEF8@.microsoft.com...
> Hi;
> I am running Sql Server dev edition on my home system - not on a domain.
> When I installed I selecgted mixed security so can have user/pw ad well as
> SSPI. I told it to run the server using my login.
> I changed the password for my Windows login and Sql Server will now not
> start. If I change back to the old pw it will. How do I get it to update
the
> pw for my username for when it starts?
> --
> thanks - dave
Open up AdminTools -> Services
Find the MSSQLServer and SQLServerAgent service and update the passwords
there. Restart the services.
Rick Sawtell
MCT, MCSD, MCDBA|||Administrative Tools, Services, there you select the SQL Server service and
change the password for
the login. this applies for all services in windows, not only SQL Server.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"David Thielen" <thielen@.nospam.nospam> wrote in message
news:30A6CEF8-15F4-4C42-9796-F769CCFADEF8@.microsoft.com...
> Hi;
> I am running Sql Server dev edition on my home system - not on a domain.
> When I installed I selecgted mixed security so can have user/pw ad well as
> SSPI. I told it to run the server using my login.
> I changed the password for my Windows login and Sql Server will now not
> start. If I change back to the old pw it will. How do I get it to update t
he
> pw for my username for when it starts?
> --
> thanks - dave|||Change the password for the MSSQLSERVER service and the SQLSERVERAGENT
service using the control panel service control applet. Next time, use
Enterprise Mangler to change the password for the service before you change
it at the Windows level.
Geoff N. Hiten
Microsoft SQL Server MVP
"David Thielen" <thielen@.nospam.nospam> wrote in message
news:30A6CEF8-15F4-4C42-9796-F769CCFADEF8@.microsoft.com...
> Hi;
> I am running Sql Server dev edition on my home system - not on a domain.
> When I installed I selecgted mixed security so can have user/pw ad well as
> SSPI. I told it to run the server using my login.
> I changed the password for my Windows login and Sql Server will now not
> start. If I change back to the old pw it will. How do I get it to update
> the
> pw for my username for when it starts?
> --
> thanks - dave|||Hi,
After changing the Service startup account password, you need to change that
in Control panel -- admin tools -- services.
How to do:-
1. Control Panel - Admin tools -- Services
2. Double click above the MSSQL Server service
3. In the Log on tab, change the password, Click ok and restart the
service.
Note:
Do the same for SQL Agent service.
Thanks
Hari
SQL Server MVP
"David Thielen" <thielen@.nospam.nospam> wrote in message
news:30A6CEF8-15F4-4C42-9796-F769CCFADEF8@.microsoft.com...
> Hi;
> I am running Sql Server dev edition on my home system - not on a domain.
> When I installed I selecgted mixed security so can have user/pw ad well as
> SSPI. I told it to run the server using my login.
> I changed the password for my Windows login and Sql Server will now not
> start. If I change back to the old pw it will. How do I get it to update
> the
> pw for my username for when it starts?
> --
> thanks - dave|||Thank you everyone. As soon as I saw that answer it was "of course - stupid
me."
thanks - dave
"David Thielen" wrote:

> Hi;
> I am running Sql Server dev edition on my home system - not on a domain.
> When I installed I selecgted mixed security so can have user/pw ad well as
> SSPI. I told it to run the server using my login.
> I changed the password for my Windows login and Sql Server will now not
> start. If I change back to the old pw it will. How do I get it to update t
he
> pw for my username for when it starts?
> --
> thanks - dave

Changed user p/w, can't start Sql Server

Hi;
I am running Sql Server dev edition on my home system - not on a domain.
When I installed I selecgted mixed security so can have user/pw ad well as
SSPI. I told it to run the server using my login.
I changed the password for my Windows login and Sql Server will now not
start. If I change back to the old pw it will. How do I get it to update the
pw for my username for when it starts?
--
thanks - dave"David Thielen" <thielen@.nospam.nospam> wrote in message
news:30A6CEF8-15F4-4C42-9796-F769CCFADEF8@.microsoft.com...
> Hi;
> I am running Sql Server dev edition on my home system - not on a domain.
> When I installed I selecgted mixed security so can have user/pw ad well as
> SSPI. I told it to run the server using my login.
> I changed the password for my Windows login and Sql Server will now not
> start. If I change back to the old pw it will. How do I get it to update
the
> pw for my username for when it starts?
> --
> thanks - dave
Open up AdminTools -> Services
Find the MSSQLServer and SQLServerAgent service and update the passwords
there. Restart the services.
Rick Sawtell
MCT, MCSD, MCDBA|||Administrative Tools, Services, there you select the SQL Server service and change the password for
the login. this applies for all services in windows, not only SQL Server.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"David Thielen" <thielen@.nospam.nospam> wrote in message
news:30A6CEF8-15F4-4C42-9796-F769CCFADEF8@.microsoft.com...
> Hi;
> I am running Sql Server dev edition on my home system - not on a domain.
> When I installed I selecgted mixed security so can have user/pw ad well as
> SSPI. I told it to run the server using my login.
> I changed the password for my Windows login and Sql Server will now not
> start. If I change back to the old pw it will. How do I get it to update the
> pw for my username for when it starts?
> --
> thanks - dave|||Change the password for the MSSQLSERVER service and the SQLSERVERAGENT
service using the control panel service control applet. Next time, use
Enterprise Mangler to change the password for the service before you change
it at the Windows level.
Geoff N. Hiten
Microsoft SQL Server MVP
"David Thielen" <thielen@.nospam.nospam> wrote in message
news:30A6CEF8-15F4-4C42-9796-F769CCFADEF8@.microsoft.com...
> Hi;
> I am running Sql Server dev edition on my home system - not on a domain.
> When I installed I selecgted mixed security so can have user/pw ad well as
> SSPI. I told it to run the server using my login.
> I changed the password for my Windows login and Sql Server will now not
> start. If I change back to the old pw it will. How do I get it to update
> the
> pw for my username for when it starts?
> --
> thanks - dave|||Hi,
After changing the Service startup account password, you need to change that
in Control panel -- admin tools -- services.
How to do:-
1. Control Panel - Admin tools -- Services
2. Double click above the MSSQL Server service
3. In the Log on tab, change the password, Click ok and restart the
service.
Note:
Do the same for SQL Agent service.
Thanks
Hari
SQL Server MVP
"David Thielen" <thielen@.nospam.nospam> wrote in message
news:30A6CEF8-15F4-4C42-9796-F769CCFADEF8@.microsoft.com...
> Hi;
> I am running Sql Server dev edition on my home system - not on a domain.
> When I installed I selecgted mixed security so can have user/pw ad well as
> SSPI. I told it to run the server using my login.
> I changed the password for my Windows login and Sql Server will now not
> start. If I change back to the old pw it will. How do I get it to update
> the
> pw for my username for when it starts?
> --
> thanks - dave|||Thank you everyone. As soon as I saw that answer it was "of course - stupid
me."
--
thanks - dave
"David Thielen" wrote:
> Hi;
> I am running Sql Server dev edition on my home system - not on a domain.
> When I installed I selecgted mixed security so can have user/pw ad well as
> SSPI. I told it to run the server using my login.
> I changed the password for my Windows login and Sql Server will now not
> start. If I change back to the old pw it will. How do I get it to update the
> pw for my username for when it starts?
> --
> thanks - dave

Changed user p/w, can't start Sql Server

Hi;
I am running Sql Server dev edition on my home system - not on a domain.
When I installed I selecgted mixed security so can have user/pw ad well as
SSPI. I told it to run the server using my login.
I changed the password for my Windows login and Sql Server will now not
start. If I change back to the old pw it will. How do I get it to update the
pw for my username for when it starts?
thanks - dave
"David Thielen" <thielen@.nospam.nospam> wrote in message
news:30A6CEF8-15F4-4C42-9796-F769CCFADEF8@.microsoft.com...
> Hi;
> I am running Sql Server dev edition on my home system - not on a domain.
> When I installed I selecgted mixed security so can have user/pw ad well as
> SSPI. I told it to run the server using my login.
> I changed the password for my Windows login and Sql Server will now not
> start. If I change back to the old pw it will. How do I get it to update
the
> pw for my username for when it starts?
> --
> thanks - dave
Open up AdminTools -> Services
Find the MSSQLServer and SQLServerAgent service and update the passwords
there. Restart the services.
Rick Sawtell
MCT, MCSD, MCDBA
|||Administrative Tools, Services, there you select the SQL Server service and change the password for
the login. this applies for all services in windows, not only SQL Server.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"David Thielen" <thielen@.nospam.nospam> wrote in message
news:30A6CEF8-15F4-4C42-9796-F769CCFADEF8@.microsoft.com...
> Hi;
> I am running Sql Server dev edition on my home system - not on a domain.
> When I installed I selecgted mixed security so can have user/pw ad well as
> SSPI. I told it to run the server using my login.
> I changed the password for my Windows login and Sql Server will now not
> start. If I change back to the old pw it will. How do I get it to update the
> pw for my username for when it starts?
> --
> thanks - dave
|||Change the password for the MSSQLSERVER service and the SQLSERVERAGENT
service using the control panel service control applet. Next time, use
Enterprise Mangler to change the password for the service before you change
it at the Windows level.
Geoff N. Hiten
Microsoft SQL Server MVP
"David Thielen" <thielen@.nospam.nospam> wrote in message
news:30A6CEF8-15F4-4C42-9796-F769CCFADEF8@.microsoft.com...
> Hi;
> I am running Sql Server dev edition on my home system - not on a domain.
> When I installed I selecgted mixed security so can have user/pw ad well as
> SSPI. I told it to run the server using my login.
> I changed the password for my Windows login and Sql Server will now not
> start. If I change back to the old pw it will. How do I get it to update
> the
> pw for my username for when it starts?
> --
> thanks - dave
|||Hi,
After changing the Service startup account password, you need to change that
in Control panel -- admin tools -- services.
How to do:-
1. Control Panel - Admin tools -- Services
2. Double click above the MSSQL Server service
3. In the Log on tab, change the password, Click ok and restart the
service.
Note:
Do the same for SQL Agent service.
Thanks
Hari
SQL Server MVP
"David Thielen" <thielen@.nospam.nospam> wrote in message
news:30A6CEF8-15F4-4C42-9796-F769CCFADEF8@.microsoft.com...
> Hi;
> I am running Sql Server dev edition on my home system - not on a domain.
> When I installed I selecgted mixed security so can have user/pw ad well as
> SSPI. I told it to run the server using my login.
> I changed the password for my Windows login and Sql Server will now not
> start. If I change back to the old pw it will. How do I get it to update
> the
> pw for my username for when it starts?
> --
> thanks - dave
|||Thank you everyone. As soon as I saw that answer it was "of course - stupid
me."
thanks - dave
"David Thielen" wrote:

> Hi;
> I am running Sql Server dev edition on my home system - not on a domain.
> When I installed I selecgted mixed security so can have user/pw ad well as
> SSPI. I told it to run the server using my login.
> I changed the password for my Windows login and Sql Server will now not
> start. If I change back to the old pw it will. How do I get it to update the
> pw for my username for when it starts?
> --
> thanks - dave

Change version of SQL 2000 on running system

Hi,

is it possible to change the installed version on a server from SQL 2000 Standard Edition to SQL 2000 Developer Edition?

The server has been a production server and is now only used for testing by development, not from end users.

Best regards, Stefoon

I think the only supported way to do this is to uninstall and reinstall SQL 2000.

Thanks,
Sam Lester (MSFT)

|||Yes as you're downgrading the edition, but you can use the database without any issues with a backup.|||

Satya, what's the trick to change a current edition on a machine other than uninstall/reinstall?

Thanks,
Sam

Change the domain setting for the MS SQL 2000 Server

Hallo,
During the installation I have to choose the proper service accounts. On a
form that appears, I can set the service setting to use local system account
or to use a domain user account.
I would like to use the domain user account to allow other apllication to
query the SQL server. But latter on I would like to change the domain.
Where to change the domain setting before put the the SQL srver machine in
another domain?
Thanks in advance
James
To add to Peter's response, you can also change the service account using
Enterprise Manager. This will assign the account the advanced user rights
needed.
Hope this helps.
Dan Guzman
SQL Server MVP
"James" <James@.discussions.microsoft.com> wrote in message
news:610285C2-4ABB-47B2-B554-9B5D6799B7A9@.microsoft.com...
> Hallo,
> During the installation I have to choose the proper service accounts. On a
> form that appears, I can set the service setting to use local system
account
> or to use a domain user account.
> I would like to use the domain user account to allow other apllication to
> query the SQL server. But latter on I would like to change the domain.
> Where to change the domain setting before put the the SQL srver machine in
> another domain?
> Thanks in advance
> James
>
|||Thanks Dan,
The reason why I did not post that solution is that SQL
then needs to be stopped and started in order for SQL to
use the new userid.
Peter
Status quo, you know, that is Latin for "the mess we're
in."
Ronald Reagan

>--Original Message--
>To add to Peter's response, you can also change the
service account using
>Enterprise Manager. This will assign the account the
advanced user rights[vbcol=seagreen]
>needed.
>--
>Hope this helps.
>Dan Guzman
>SQL Server MVP
>"James" <James@.discussions.microsoft.com> wrote in message
>news:610285C2-4ABB-47B2-B554-9B5D6799B7A9@.microsoft.com...
service accounts. On a[vbcol=seagreen]
local system[vbcol=seagreen]
>account
other apllication to[vbcol=seagreen]
change the domain.[vbcol=seagreen]
SQL srver machine in
>
>.
>
|||I believe the service also needs to be restarted when the account is changed
with SCM. The applet will let you change the account without restarting but
will not actually take affect until you do so.
Hope this helps.
Dan Guzman
SQL Server MVP
"Peter The Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:15e801c48c3c$352db1d0$a301280a@.phx.gbl...[vbcol=seagreen]
> Thanks Dan,
> The reason why I did not post that solution is that SQL
> then needs to be stopped and started in order for SQL to
> use the new userid.
> Peter
> Status quo, you know, that is Latin for "the mess we're
> in."
> Ronald Reagan
>
> service account using
> advanced user rights
> service accounts. On a
> local system
> other apllication to
> change the domain.
> SQL srver machine in

Change the domain setting for the MS SQL 2000 Server

Hallo,
During the installation I have to choose the proper service accounts. On a
form that appears, I can set the service setting to use local system account
or to use a domain user account.
I would like to use the domain user account to allow other apllication to
query the SQL server. But latter on I would like to change the domain.
Where to change the domain setting before put the the SQL srver machine in
another domain?
Thanks in advance
JamesTo add to Peter's response, you can also change the service account using
Enterprise Manager. This will assign the account the advanced user rights
needed.
Hope this helps.
Dan Guzman
SQL Server MVP
"James" <James@.discussions.microsoft.com> wrote in message
news:610285C2-4ABB-47B2-B554-9B5D6799B7A9@.microsoft.com...
> Hallo,
> During the installation I have to choose the proper service accounts. On a
> form that appears, I can set the service setting to use local system
account
> or to use a domain user account.
> I would like to use the domain user account to allow other apllication to
> query the SQL server. But latter on I would like to change the domain.
> Where to change the domain setting before put the the SQL srver machine in
> another domain?
> Thanks in advance
> James
>|||Thanks Dan,
The reason why I did not post that solution is that SQL
then needs to be stopped and started in order for SQL to
use the new userid.
Peter
Status quo, you know, that is Latin for "the mess we're
in."
Ronald Reagan

>--Original Message--
>To add to Peter's response, you can also change the
service account using
>Enterprise Manager. This will assign the account the
advanced user rights
>needed.
>--
>Hope this helps.
>Dan Guzman
>SQL Server MVP
>"James" <James@.discussions.microsoft.com> wrote in message
>news:610285C2-4ABB-47B2-B554-9B5D6799B7A9@.microsoft.com...
service accounts. On a[vbcol=seagreen]
local system[vbcol=seagreen]
>account
other apllication to[vbcol=seagreen]
change the domain.[vbcol=seagreen]
SQL srver machine in[vbcol=seagreen]
>
>.
>|||I believe the service also needs to be restarted when the account is changed
with SCM. The applet will let you change the account without restarting but
will not actually take affect until you do so.
Hope this helps.
Dan Guzman
SQL Server MVP
"Peter The Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:15e801c48c3c$352db1d0$a301280a@.phx.gbl...[vbcol=seagreen]
> Thanks Dan,
> The reason why I did not post that solution is that SQL
> then needs to be stopped and started in order for SQL to
> use the new userid.
> Peter
> Status quo, you know, that is Latin for "the mess we're
> in."
> Ronald Reagan
>
> service account using
> advanced user rights
> service accounts. On a
> local system
> other apllication to
> change the domain.
> SQL srver machine in

Change System Date in SQL Server

Hi
How do I change the date forward, say from April 2004 to August 2004,
so the SQL server will pick up the August 2004 date instead.
I try to do it changing the System Date in CMOS & Windows but when SQL
server services starts, SQL change the date back to April 2004 instead
of August 2004. Seems like the SQL server is pretty smart that it
controls the date of the Server.
Anybody have some idea? Thanks a bunch for any input.
SLSL,
To the best of my knowledge, SQL Server gets the date strictly from Windows,
and does not have any automatic mechanism to reset the Windows date.
I'm going to guess that you have Windows configured to automatically
synchronize with an Internet time server, and that is resetting the Windows
(and therefore the SQL Server) clock.
Chief Tenaya
"sl" <slai@.sceptre.com> wrote in message
news:9f6f5fe0.0404081722.5406fb01@.posting.google.com...
> Hi
> How do I change the date forward, say from April 2004 to August 2004,
> so the SQL server will pick up the August 2004 date instead.
> I try to do it changing the System Date in CMOS & Windows but when SQL
> server services starts, SQL change the date back to April 2004 instead
> of August 2004. Seems like the SQL server is pretty smart that it
> controls the date of the Server.
> Anybody have some idea? Thanks a bunch for any input.
> SL|||Hi Chief
Thanks a lot! The time-server ring a bell in me now. I think it is the
PDC server that is resetting the date when the SQL services starts. I
don't have a Time Server.
I'll check it. Thanks so much! Really appreciates your input.
SL
"Tenaya" <ct@.ct.ct> wrote in message news:<OiZfvadHEHA.2836@.TK2MSFTNGP11.phx.gbl>...
> SL,
> To the best of my knowledge, SQL Server gets the date strictly from Windows,
> and does not have any automatic mechanism to reset the Windows date.
> I'm going to guess that you have Windows configured to automatically
> synchronize with an Internet time server, and that is resetting the Windows
> (and therefore the SQL Server) clock.
> Chief Tenaya
>
> "sl" <slai@.sceptre.com> wrote in message
> news:9f6f5fe0.0404081722.5406fb01@.posting.google.com...
> > Hi
> >
> > How do I change the date forward, say from April 2004 to August 2004,
> > so the SQL server will pick up the August 2004 date instead.
> >
> > I try to do it changing the System Date in CMOS & Windows but when SQL
> > server services starts, SQL change the date back to April 2004 instead
> > of August 2004. Seems like the SQL server is pretty smart that it
> > controls the date of the Server.
> >
> > Anybody have some idea? Thanks a bunch for any input.
> >
> > SL

Change System Date in SQL Server

Hi
How do I change the date forward, say from April 2004 to August 2004,
so the SQL server will pick up the August 2004 date instead.
I try to do it changing the System Date in CMOS & Windows but when SQL
server services starts, SQL change the date back to April 2004 instead
of August 2004. Seems like the SQL server is pretty smart that it
controls the date of the Server.
Anybody have some idea? Thanks a bunch for any input.
SL
SL,
To the best of my knowledge, SQL Server gets the date strictly from Windows,
and does not have any automatic mechanism to reset the Windows date.
I'm going to guess that you have Windows configured to automatically
synchronize with an Internet time server, and that is resetting the Windows
(and therefore the SQL Server) clock.
Chief Tenaya
"sl" <slai@.sceptre.com> wrote in message
news:9f6f5fe0.0404081722.5406fb01@.posting.google.c om...
> Hi
> How do I change the date forward, say from April 2004 to August 2004,
> so the SQL server will pick up the August 2004 date instead.
> I try to do it changing the System Date in CMOS & Windows but when SQL
> server services starts, SQL change the date back to April 2004 instead
> of August 2004. Seems like the SQL server is pretty smart that it
> controls the date of the Server.
> Anybody have some idea? Thanks a bunch for any input.
> SL
|||Hi Chief
Thanks a lot! The time-server ring a bell in me now. I think it is the
PDC server that is resetting the date when the SQL services starts. I
don't have a Time Server.
I'll check it. Thanks so much! Really appreciates your input.
SL
"Tenaya" <ct@.ct.ct> wrote in message news:<OiZfvadHEHA.2836@.TK2MSFTNGP11.phx.gbl>...
> SL,
> To the best of my knowledge, SQL Server gets the date strictly from Windows,
> and does not have any automatic mechanism to reset the Windows date.
> I'm going to guess that you have Windows configured to automatically
> synchronize with an Internet time server, and that is resetting the Windows
> (and therefore the SQL Server) clock.
> Chief Tenaya
>
> "sl" <slai@.sceptre.com> wrote in message
> news:9f6f5fe0.0404081722.5406fb01@.posting.google.c om...

Change System Date in SQL Server

Hi
How do I change the date forward, say from April 2004 to August 2004,
so the SQL server will pick up the August 2004 date instead.
I try to do it changing the System Date in CMOS & Windows but when SQL
server services starts, SQL change the date back to April 2004 instead
of August 2004. Seems like the SQL server is pretty smart that it
controls the date of the Server.
Anybody have some idea? Thanks a bunch for any input.
SLSL,
To the best of my knowledge, SQL Server gets the date strictly from Windows,
and does not have any automatic mechanism to reset the Windows date.
I'm going to guess that you have Windows configured to automatically
synchronize with an Internet time server, and that is resetting the Windows
(and therefore the SQL Server) clock.
Chief Tenaya
"sl" <slai@.sceptre.com> wrote in message
news:9f6f5fe0.0404081722.5406fb01@.posting.google.com...
> Hi
> How do I change the date forward, say from April 2004 to August 2004,
> so the SQL server will pick up the August 2004 date instead.
> I try to do it changing the System Date in CMOS & Windows but when SQL
> server services starts, SQL change the date back to April 2004 instead
> of August 2004. Seems like the SQL server is pretty smart that it
> controls the date of the Server.
> Anybody have some idea? Thanks a bunch for any input.
> SL|||Hi Chief
Thanks a lot! The time-server ring a bell in me now. I think it is the
PDC server that is resetting the date when the SQL services starts. I
don't have a Time Server.
I'll check it. Thanks so much! Really appreciates your input.
SL
"Tenaya" <ct@.ct.ct> wrote in message news:<OiZfvadHEHA.2836@.TK2MSFTNGP11.phx.gbl>...[color=
darkred]
> SL,
> To the best of my knowledge, SQL Server gets the date strictly from Window
s,
> and does not have any automatic mechanism to reset the Windows date.
> I'm going to guess that you have Windows configured to automatically
> synchronize with an Internet time server, and that is resetting the Window
s
> (and therefore the SQL Server) clock.
> Chief Tenaya
>
> "sl" <slai@.sceptre.com> wrote in message
> news:9f6f5fe0.0404081722.5406fb01@.posting.google.com...

change status for standby database

I know i can recover a standby database by restoring the same with recovery
option
I want to try out something and want to know which system table all this
gets recorded so that instead of restoring the database with recovery
option, can I just update a column in a system table to have it recovered. I
tried to change the status column in sysdatabases but that didnt seem to do
it. It just took the status away from within EM that states its a read only
to have nothing displayed and make it look like its available but upon
modifying tables it still gave me an error message that the database is in
load state or something of that sort.
Does anyone know what else I need to update ?
You don't need to execute the enture restore again to change the status.
You can issue a RESTORE from Query Analyzer with only the RECOVERY option
(omitting the FROM clause).
RESTORE DATABASE MyDatabase
WITH RECOVERY
Hope this helps.
Dan Guzman
SQL Server MVP
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:u3Zamya%23EHA.2192@.TK2MSFTNGP14.phx.gbl...
>I know i can recover a standby database by restoring the same with recovery
> option
> I want to try out something and want to know which system table all this
> gets recorded so that instead of restoring the database with recovery
> option, can I just update a column in a system table to have it recovered.
> I
> tried to change the status column in sysdatabases but that didnt seem to
> do
> it. It just took the status away from within EM that states its a read
> only
> to have nothing displayed and make it look like its available but upon
> modifying tables it still gave me an error message that the database is in
> load state or something of that sort.
> Does anyone know what else I need to update ?
>
|||Yes I am aware of this.. Just wanted to know if theres any other way by
internally hacking a system table that would make the database available..
i.e. assuming I do not wish to change anything on this standby database. I
would like to make this database available by updating some system table
values and then putting it back in standby state by resetting that system
table value.
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:%23EwGLRe%23EHA.2032@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> You don't need to execute the enture restore again to change the status.
> You can issue a RESTORE from Query Analyzer with only the RECOVERY option
> (omitting the FROM clause).
> RESTORE DATABASE MyDatabase
> WITH RECOVERY
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:u3Zamya%23EHA.2192@.TK2MSFTNGP14.phx.gbl...
recovery[vbcol=seagreen]
recovered.[vbcol=seagreen]
in
>
|||Not possible. The recovery process will apply the UNDO logic based on the transaction log, and once
that is done, you cannot restore any further backups.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Hassan" <fatima_ja@.hotmail.com> wrote in message news:OFfF1of%23EHA.3368@.TK2MSFTNGP15.phx.gbl...
> Yes I am aware of this.. Just wanted to know if theres any other way by
> internally hacking a system table that would make the database available..
> i.e. assuming I do not wish to change anything on this standby database. I
> would like to make this database available by updating some system table
> values and then putting it back in standby state by resetting that system
> table value.
>
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> news:%23EwGLRe%23EHA.2032@.tk2msftngp13.phx.gbl...
> recovery
> recovered.
> in
>
|||To add to Tibor's response, the log restore process requires that the
database to be in exactly the state it was in at the time of the log backup.
Permitting database updates before a log restore will introduce the
potential for conflicting database modifications that the restore process
cannot handle. If you were able to circumvent the database status check,
you could very well end up with a corrupt database.
Hope this helps.
Dan Guzman
SQL Server MVP
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:OFfF1of%23EHA.3368@.TK2MSFTNGP15.phx.gbl...
> Yes I am aware of this.. Just wanted to know if theres any other way by
> internally hacking a system table that would make the database available..
> i.e. assuming I do not wish to change anything on this standby database. I
> would like to make this database available by updating some system table
> values and then putting it back in standby state by resetting that system
> table value.
>
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> news:%23EwGLRe%23EHA.2032@.tk2msftngp13.phx.gbl...
> recovery
> recovered.
> in
>
|||Oops, should have been:
" The RESTORE process will apply the UNDO... "
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
news:%234UaCli%23EHA.1400@.TK2MSFTNGP11.phx.gbl...
> Not possible. The recovery process will apply the UNDO logic based on the transaction log, and
> once that is done, you cannot restore any further backups.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Hassan" <fatima_ja@.hotmail.com> wrote in message news:OFfF1of%23EHA.3368@.TK2MSFTNGP15.phx.gbl...
>
|||"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:OFfF1of%23EHA.3368@.TK2MSFTNGP15.phx.gbl...
> Yes I am aware of this.. Just wanted to know if theres any other way by
> internally hacking a system table that would make the database available..
> i.e. assuming I do not wish to change anything on this standby database. I
> would like to make this database available by updating some system table
> values and then putting it back in standby state by resetting that system
> table value.
Why not use WITH STANDBY?
This will make it a READ-ONLY database that you can later RECOVER further if
need be.
[vbcol=seagreen]
>
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> news:%23EwGLRe%23EHA.2032@.tk2msftngp13.phx.gbl...
option[vbcol=seagreen]
> recovery
this[vbcol=seagreen]
> recovered.
to[vbcol=seagreen]
is
> in
>

change status for standby database

I know i can recover a standby database by restoring the same with recovery
option
I want to try out something and want to know which system table all this
gets recorded so that instead of restoring the database with recovery
option, can I just update a column in a system table to have it recovered. I
tried to change the status column in sysdatabases but that didnt seem to do
it. It just took the status away from within EM that states its a read only
to have nothing displayed and make it look like its available but upon
modifying tables it still gave me an error message that the database is in
load state or something of that sort.
Does anyone know what else I need to update ?You don't need to execute the enture restore again to change the status.
You can issue a RESTORE from Query Analyzer with only the RECOVERY option
(omitting the FROM clause).
RESTORE DATABASE MyDatabase
WITH RECOVERY
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:u3Zamya%23EHA.2192@.TK2MSFTNGP14.phx.gbl...
>I know i can recover a standby database by restoring the same with recovery
> option
> I want to try out something and want to know which system table all this
> gets recorded so that instead of restoring the database with recovery
> option, can I just update a column in a system table to have it recovered.
> I
> tried to change the status column in sysdatabases but that didnt seem to
> do
> it. It just took the status away from within EM that states its a read
> only
> to have nothing displayed and make it look like its available but upon
> modifying tables it still gave me an error message that the database is in
> load state or something of that sort.
> Does anyone know what else I need to update ?
>|||Yes I am aware of this.. Just wanted to know if theres any other way by
internally hacking a system table that would make the database available..
i.e. assuming I do not wish to change anything on this standby database. I
would like to make this database available by updating some system table
values and then putting it back in standby state by resetting that system
table value.
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:%23EwGLRe%23EHA.2032@.tk2msftngp13.phx.gbl...
> You don't need to execute the enture restore again to change the status.
> You can issue a RESTORE from Query Analyzer with only the RECOVERY option
> (omitting the FROM clause).
> RESTORE DATABASE MyDatabase
> WITH RECOVERY
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:u3Zamya%23EHA.2192@.TK2MSFTNGP14.phx.gbl...
> >I know i can recover a standby database by restoring the same with
recovery
> > option
> >
> > I want to try out something and want to know which system table all this
> > gets recorded so that instead of restoring the database with recovery
> > option, can I just update a column in a system table to have it
recovered.
> > I
> > tried to change the status column in sysdatabases but that didnt seem to
> > do
> > it. It just took the status away from within EM that states its a read
> > only
> > to have nothing displayed and make it look like its available but upon
> > modifying tables it still gave me an error message that the database is
in
> > load state or something of that sort.
> >
> > Does anyone know what else I need to update ?
> >
> >
>|||Not possible. The recovery process will apply the UNDO logic based on the transaction log, and once
that is done, you cannot restore any further backups.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Hassan" <fatima_ja@.hotmail.com> wrote in message news:OFfF1of%23EHA.3368@.TK2MSFTNGP15.phx.gbl...
> Yes I am aware of this.. Just wanted to know if theres any other way by
> internally hacking a system table that would make the database available..
> i.e. assuming I do not wish to change anything on this standby database. I
> would like to make this database available by updating some system table
> values and then putting it back in standby state by resetting that system
> table value.
>
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> news:%23EwGLRe%23EHA.2032@.tk2msftngp13.phx.gbl...
>> You don't need to execute the enture restore again to change the status.
>> You can issue a RESTORE from Query Analyzer with only the RECOVERY option
>> (omitting the FROM clause).
>> RESTORE DATABASE MyDatabase
>> WITH RECOVERY
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> "Hassan" <fatima_ja@.hotmail.com> wrote in message
>> news:u3Zamya%23EHA.2192@.TK2MSFTNGP14.phx.gbl...
>> >I know i can recover a standby database by restoring the same with
> recovery
>> > option
>> >
>> > I want to try out something and want to know which system table all this
>> > gets recorded so that instead of restoring the database with recovery
>> > option, can I just update a column in a system table to have it
> recovered.
>> > I
>> > tried to change the status column in sysdatabases but that didnt seem to
>> > do
>> > it. It just took the status away from within EM that states its a read
>> > only
>> > to have nothing displayed and make it look like its available but upon
>> > modifying tables it still gave me an error message that the database is
> in
>> > load state or something of that sort.
>> >
>> > Does anyone know what else I need to update ?
>> >
>> >
>>
>|||To add to Tibor's response, the log restore process requires that the
database to be in exactly the state it was in at the time of the log backup.
Permitting database updates before a log restore will introduce the
potential for conflicting database modifications that the restore process
cannot handle. If you were able to circumvent the database status check,
you could very well end up with a corrupt database.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:OFfF1of%23EHA.3368@.TK2MSFTNGP15.phx.gbl...
> Yes I am aware of this.. Just wanted to know if theres any other way by
> internally hacking a system table that would make the database available..
> i.e. assuming I do not wish to change anything on this standby database. I
> would like to make this database available by updating some system table
> values and then putting it back in standby state by resetting that system
> table value.
>
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> news:%23EwGLRe%23EHA.2032@.tk2msftngp13.phx.gbl...
>> You don't need to execute the enture restore again to change the status.
>> You can issue a RESTORE from Query Analyzer with only the RECOVERY option
>> (omitting the FROM clause).
>> RESTORE DATABASE MyDatabase
>> WITH RECOVERY
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> "Hassan" <fatima_ja@.hotmail.com> wrote in message
>> news:u3Zamya%23EHA.2192@.TK2MSFTNGP14.phx.gbl...
>> >I know i can recover a standby database by restoring the same with
> recovery
>> > option
>> >
>> > I want to try out something and want to know which system table all
>> > this
>> > gets recorded so that instead of restoring the database with recovery
>> > option, can I just update a column in a system table to have it
> recovered.
>> > I
>> > tried to change the status column in sysdatabases but that didnt seem
>> > to
>> > do
>> > it. It just took the status away from within EM that states its a read
>> > only
>> > to have nothing displayed and make it look like its available but upon
>> > modifying tables it still gave me an error message that the database is
> in
>> > load state or something of that sort.
>> >
>> > Does anyone know what else I need to update ?
>> >
>> >
>>
>|||Oops, should have been:
" The RESTORE process will apply the UNDO... "
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
news:%234UaCli%23EHA.1400@.TK2MSFTNGP11.phx.gbl...
> Not possible. The recovery process will apply the UNDO logic based on the transaction log, and
> once that is done, you cannot restore any further backups.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Hassan" <fatima_ja@.hotmail.com> wrote in message news:OFfF1of%23EHA.3368@.TK2MSFTNGP15.phx.gbl...
>> Yes I am aware of this.. Just wanted to know if theres any other way by
>> internally hacking a system table that would make the database available..
>> i.e. assuming I do not wish to change anything on this standby database. I
>> would like to make this database available by updating some system table
>> values and then putting it back in standby state by resetting that system
>> table value.
>>
>> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
>> news:%23EwGLRe%23EHA.2032@.tk2msftngp13.phx.gbl...
>> You don't need to execute the enture restore again to change the status.
>> You can issue a RESTORE from Query Analyzer with only the RECOVERY option
>> (omitting the FROM clause).
>> RESTORE DATABASE MyDatabase
>> WITH RECOVERY
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> "Hassan" <fatima_ja@.hotmail.com> wrote in message
>> news:u3Zamya%23EHA.2192@.TK2MSFTNGP14.phx.gbl...
>> >I know i can recover a standby database by restoring the same with
>> recovery
>> > option
>> >
>> > I want to try out something and want to know which system table all this
>> > gets recorded so that instead of restoring the database with recovery
>> > option, can I just update a column in a system table to have it
>> recovered.
>> > I
>> > tried to change the status column in sysdatabases but that didnt seem to
>> > do
>> > it. It just took the status away from within EM that states its a read
>> > only
>> > to have nothing displayed and make it look like its available but upon
>> > modifying tables it still gave me an error message that the database is
>> in
>> > load state or something of that sort.
>> >
>> > Does anyone know what else I need to update ?
>> >
>> >
>>
>>
>|||"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:OFfF1of%23EHA.3368@.TK2MSFTNGP15.phx.gbl...
> Yes I am aware of this.. Just wanted to know if theres any other way by
> internally hacking a system table that would make the database available..
> i.e. assuming I do not wish to change anything on this standby database. I
> would like to make this database available by updating some system table
> values and then putting it back in standby state by resetting that system
> table value.
Why not use WITH STANDBY?
This will make it a READ-ONLY database that you can later RECOVER further if
need be.
>
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> news:%23EwGLRe%23EHA.2032@.tk2msftngp13.phx.gbl...
> > You don't need to execute the enture restore again to change the status.
> > You can issue a RESTORE from Query Analyzer with only the RECOVERY
option
> > (omitting the FROM clause).
> >
> > RESTORE DATABASE MyDatabase
> > WITH RECOVERY
> >
> > --
> > Hope this helps.
> >
> > Dan Guzman
> > SQL Server MVP
> >
> > "Hassan" <fatima_ja@.hotmail.com> wrote in message
> > news:u3Zamya%23EHA.2192@.TK2MSFTNGP14.phx.gbl...
> > >I know i can recover a standby database by restoring the same with
> recovery
> > > option
> > >
> > > I want to try out something and want to know which system table all
this
> > > gets recorded so that instead of restoring the database with recovery
> > > option, can I just update a column in a system table to have it
> recovered.
> > > I
> > > tried to change the status column in sysdatabases but that didnt seem
to
> > > do
> > > it. It just took the status away from within EM that states its a read
> > > only
> > > to have nothing displayed and make it look like its available but upon
> > > modifying tables it still gave me an error message that the database
is
> in
> > > load state or something of that sort.
> > >
> > > Does anyone know what else I need to update ?
> > >
> > >
> >
> >
>

change status for standby database

I know i can recover a standby database by restoring the same with recovery
option
I want to try out something and want to know which system table all this
gets recorded so that instead of restoring the database with recovery
option, can I just update a column in a system table to have it recovered. I
tried to change the status column in sysdatabases but that didnt seem to do
it. It just took the status away from within EM that states its a read only
to have nothing displayed and make it look like its available but upon
modifying tables it still gave me an error message that the database is in
load state or something of that sort.
Does anyone know what else I need to update ?You don't need to execute the enture restore again to change the status.
You can issue a RESTORE from Query Analyzer with only the RECOVERY option
(omitting the FROM clause).
RESTORE DATABASE MyDatabase
WITH RECOVERY
Hope this helps.
Dan Guzman
SQL Server MVP
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:u3Zamya%23EHA.2192@.TK2MSFTNGP14.phx.gbl...
>I know i can recover a standby database by restoring the same with recovery
> option
> I want to try out something and want to know which system table all this
> gets recorded so that instead of restoring the database with recovery
> option, can I just update a column in a system table to have it recovered.
> I
> tried to change the status column in sysdatabases but that didnt seem to
> do
> it. It just took the status away from within EM that states its a read
> only
> to have nothing displayed and make it look like its available but upon
> modifying tables it still gave me an error message that the database is in
> load state or something of that sort.
> Does anyone know what else I need to update ?
>|||Yes I am aware of this.. Just wanted to know if theres any other way by
internally hacking a system table that would make the database available..
i.e. assuming I do not wish to change anything on this standby database. I
would like to make this database available by updating some system table
values and then putting it back in standby state by resetting that system
table value.
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:%23EwGLRe%23EHA.2032@.tk2msftngp13.phx.gbl...
> You don't need to execute the enture restore again to change the status.
> You can issue a RESTORE from Query Analyzer with only the RECOVERY option
> (omitting the FROM clause).
> RESTORE DATABASE MyDatabase
> WITH RECOVERY
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:u3Zamya%23EHA.2192@.TK2MSFTNGP14.phx.gbl...
recovery[vbcol=seagreen]
recovered.[vbcol=seagreen]
in[vbcol=seagreen]
>|||Not possible. The recovery process will apply the UNDO logic based on the tr
ansaction log, and once
that is done, you cannot restore any further backups.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Hassan" <fatima_ja@.hotmail.com> wrote in message news:OFfF1of%23EHA.3368@.TK2MSFTNGP15.phx.g
bl...
> Yes I am aware of this.. Just wanted to know if theres any other way by
> internally hacking a system table that would make the database available..
> i.e. assuming I do not wish to change anything on this standby database. I
> would like to make this database available by updating some system table
> values and then putting it back in standby state by resetting that system
> table value.
>
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> news:%23EwGLRe%23EHA.2032@.tk2msftngp13.phx.gbl...
> recovery
> recovered.
> in
>|||To add to Tibor's response, the log restore process requires that the
database to be in exactly the state it was in at the time of the log backup.
Permitting database updates before a log restore will introduce the
potential for conflicting database modifications that the restore process
cannot handle. If you were able to circumvent the database status check,
you could very well end up with a corrupt database.
Hope this helps.
Dan Guzman
SQL Server MVP
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:OFfF1of%23EHA.3368@.TK2MSFTNGP15.phx.gbl...
> Yes I am aware of this.. Just wanted to know if theres any other way by
> internally hacking a system table that would make the database available..
> i.e. assuming I do not wish to change anything on this standby database. I
> would like to make this database available by updating some system table
> values and then putting it back in standby state by resetting that system
> table value.
>
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> news:%23EwGLRe%23EHA.2032@.tk2msftngp13.phx.gbl...
> recovery
> recovered.
> in
>|||Oops, should have been:
" The RESTORE process will apply the UNDO... "
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message
news:%234UaCli%23EHA.1400@.TK2MSFTNGP11.phx.gbl...
> Not possible. The recovery process will apply the UNDO logic based on the
transaction log, and
> once that is done, you cannot restore any further backups.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Hassan" <fatima_ja@.hotmail.com> wrote in message news:OFfF1of%23EHA.3368@.
TK2MSFTNGP15.phx.gbl...
>|||"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:OFfF1of%23EHA.3368@.TK2MSFTNGP15.phx.gbl...
> Yes I am aware of this.. Just wanted to know if theres any other way by
> internally hacking a system table that would make the database available..
> i.e. assuming I do not wish to change anything on this standby database. I
> would like to make this database available by updating some system table
> values and then putting it back in standby state by resetting that system
> table value.
Why not use WITH STANDBY?
This will make it a READ-ONLY database that you can later RECOVER further if
need be.

>
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> news:%23EwGLRe%23EHA.2032@.tk2msftngp13.phx.gbl...
option[vbcol=seagreen]
> recovery
this[vbcol=seagreen]
> recovered.
to[vbcol=seagreen]
is[vbcol=seagreen]
> in
>

Change SSIS File System Connection

Hi,

i've been asked to move our ssis project to another machine
and i've a lot of file system connection whice i must rename them to the new path in the other machine.
there is away to rename the file system connection dynamic or i must go and rename one by one ?
thanks.You'll have to edit them one by one, but the good news is that when you are editing each one, you can use expressions to dynamically create the file path. You can also use package configurations to allow you to set the "base path" via an environment variable, XML file, etc...

You may also be able to open the .dtsx file, though, and use Search/Replace to alter the file paths.|||

Ok thanks i will use Search/Replace to alter the file paths but after it i will have to enter each package and test connection so it will work.

there is away to bypass it?

thanks.

|||Why do you have to test it so that it will work? If the file format is the same, changing the directory shouldn't have any impact.|||

what i meant was that if i move my project to another machine i have to enter each package and there enter to each connection to sql server or odbc edit them,test connection and save the package.

there is any way to skip those levels?

|||

Best solution is to take your own time and make use of config files so that you dont have to bang your head on this in future.

Also i dont think you need to change the settings for ODBC and SQL connections unless and until you plan to execute the package on a different server.

change SQLSERVERAGENT account

are there any issues to be aware of when changing the SQLSERVERAGENT
service's account to LOCAL SYSTEM or to a domain account with local "Log on
as a service" privilege ?
in other words, at time of install of SQL Server 2000, the SQLSERVERAGENT
account was specified to be the domain account for a specific user, and now
I'd like to change it ...
Domain accounts are often used if the Service need permissions in the
network. Perhpas you installed a SQMail on the Server ? That runs with the
associated MAPI account of the user which is configured on the SQL Server.
Perhpas you are pulling ot some data from a torage which has NTFS file
security ? You will need these sort of accounts then too. So first you have
to make sure that there are not issues around when you change the account to
a local system or a service account
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"John Grandy" <johnagrandy-at-yahoo-dot-com> schrieb im Newsbeitrag
news:OHWCD0fSFHA.3188@.TK2MSFTNGP09.phx.gbl...
> are there any issues to be aware of when changing the SQLSERVERAGENT
> service's account to LOCAL SYSTEM or to a domain account with local "Log
> on as a service" privilege ?
> in other words, at time of install of SQL Server 2000, the SQLSERVERAGENT
> account was specified to be the domain account for a specific user, and
> now I'd like to change it ...
>
|||"John Grandy" wrote:

> are there any issues to be aware of when changing the SQLSERVERAGENT
> service's account to LOCAL SYSTEM or to a domain account with local "Log on
> as a service" privilege ?
>
Hello, I'm in a similar situation - I want to use SQL Mail on my sql server,
and according to do so, it appears I need to change the account associated
with MSSQLSERVER, so that it has an email address, and I'm hesitant to do so
before I can be sure I won't spill anything, as this server runs our
accounting system, and integrates via biztalk to our CRM system.
Are there any things I should be aware of that any of you know about? The
only complexity I can think of is the Biztalk thing.

change SQLSERVERAGENT account

are there any issues to be aware of when changing the SQLSERVERAGENT
service's account to LOCAL SYSTEM or to a domain account with local "Log on
as a service" privilege ?
in other words, at time of install of SQL Server 2000, the SQLSERVERAGENT
account was specified to be the domain account for a specific user, and now
I'd like to change it ...Domain accounts are often used if the Service need permissions in the
network. Perhpas you installed a SQMail on the Server ? That runs with the
associated MAPI account of the user which is configured on the SQL Server.
Perhpas you are pulling ot some data from a torage which has NTFS file
security ? You will need these sort of accounts then too. So first you have
to make sure that there are not issues around when you change the account to
a local system or a service account
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"John Grandy" <johnagrandy-at-yahoo-dot-com> schrieb im Newsbeitrag
news:OHWCD0fSFHA.3188@.TK2MSFTNGP09.phx.gbl...
> are there any issues to be aware of when changing the SQLSERVERAGENT
> service's account to LOCAL SYSTEM or to a domain account with local "Log
> on as a service" privilege ?
> in other words, at time of install of SQL Server 2000, the SQLSERVERAGENT
> account was specified to be the domain account for a specific user, and
> now I'd like to change it ...
>|||"John Grandy" wrote:
> are there any issues to be aware of when changing the SQLSERVERAGENT
> service's account to LOCAL SYSTEM or to a domain account with local "Log on
> as a service" privilege ?
>
Hello, I'm in a similar situation - I want to use SQL Mail on my sql server,
and according to do so, it appears I need to change the account associated
with MSSQLSERVER, so that it has an email address, and I'm hesitant to do so
before I can be sure I won't spill anything, as this server runs our
accounting system, and integrates via biztalk to our CRM system.
Are there any things I should be aware of that any of you know about? The
only complexity I can think of is the Biztalk thing.

Change Self reference values in a data flow task

Hi,

We migrate data from a legacy system to new system using SSIS. The primary key of legacy system is a user-defined sql server which holds alpha-numeric values. The primary key of new system is a big int(sequential numbers).

When we migrate data, we generate a sequential number for each legacy key(the primary key of legacy data) and insert data in to new system tables. The newly generated sequential numbers and the legacy keys are persisted in an intermidiate table for look up operations of child tables.

We are facing problem when we try to migrate tables which has self referring coulumns. For example a table called Employee has a column ManagerKey which refers to Key column of Employee table. We are struck up in defining data flow tasks to replace legacy ManagerKey column values with the new values(sequential values) generated during the migration process.

Please help me to solve this problem.

Regards,

Gopi

Hi Gopi,

Did you ever resolve this? If so, how? I am facing the same issue.

Thanks,

Dave

|||The way to solve this is by creating your own lookup component using a custom script transformation. Instead of looking up reference values from an external table, your script should cache each unique key translation pair in a memory-based structure like a dictionary. Each old/new EmployeeKey pair gets cached into memory, and each old ManagerKey gets looked up in that cache and replaced with the new value. You would need to make sure that your data is sorted appropriately so that you don't get a ManagerKey before the EmployeeKey.
|||

Hi Dave,

Good morning. We preferred to resolve this problem at SQL Server Engine instead at Integration Services Flow. We are using query built with a Common Table Expression of SQL Server 2005 to identify all the invalid self referencing records. The SSIS Components are proven as very poor performing to identify invalid self referencing records

Cheers,

Gopi

Change Self reference values in a data flow task

Hi,

We migrate data from a legacy system to new system using SSIS. The primary key of legacy system is a user-defined sql server which holds alpha-numeric values. The primary key of new system is a big int(sequential numbers).

When we migrate data, we generate a sequential number for each legacy key(the primary key of legacy data) and insert data in to new system tables. The newly generated sequential numbers and the legacy keys are persisted in an intermidiate table for look up operations of child tables.

We are facing problem when we try to migrate tables which has self referring coulumns. For example a table called Employee has a column ManagerKey which refers to Key column of Employee table. We are struck up in defining data flow tasks to replace legacy ManagerKey column values with the new values(sequential values) generated during the migration process.

Please help me to solve this problem.

Regards,

Gopi

Hi Gopi,

Did you ever resolve this? If so, how? I am facing the same issue.

Thanks,

Dave|||The way to solve this is by creating your own lookup component using a custom script transformation. Instead of looking up reference values from an external table, your script should cache each unique key translation pair in a memory-based structure like a dictionary. Each old/new EmployeeKey pair gets cached into memory, and each old ManagerKey gets looked up in that cache and replaced with the new value. You would need to make sure that your data is sorted appropriately so that you don't get a ManagerKey before the EmployeeKey.|||

Hi Dave,

Good morning. We preferred to resolve this problem at SQL Server Engine instead at Integration Services Flow. We are using query built with a Common Table Expression of SQL Server 2005 to identify all the invalid self referencing records. The SSIS Components are proven as very poor performing to identify invalid self referencing records

Cheers,

Gopi

Change ownership of model and msdb to 'sa'

From BOL:
The owner of the master, model, or tempdb system databases
cannot be changed.
- Rob

>--Original Message--
>We are trying to exec sp_changedbowner 'sa' on model
database to change
>ownership from the service account 'service_sql' to 'sa'
account
>However, we got the follow error:
>15109 16 Cannot change the owner of the master database.
>Is there any know how to Change ownership of model and
msdb to 'sa' if in
>case 'sa' is not owner of msdb and model?
>Thanks!!
>.
>
I am facing the same problem as Maggie. My Production's SQL2k MSDB & Model
database owner is my old NT Domain Administrator (olddomain/administrator).
Not sure how it ended that way. Master owner is SA.
We have completed domain migration to Active Directory, if sp_changedbowner
is not going to allow me to change DB owner for MSDB & Model, does that mean
I still got to keep my old domain forever ?
There must be a work-around for this.
"Rob" wrote:

> From BOL:
> The owner of the master, model, or tempdb system databases
> cannot be changed.
> - Rob
> database to change
> account
> msdb to 'sa' if in
>

Change ownership of model and msdb to 'sa'

From BOL:
The owner of the master, model, or tempdb system databases
cannot be changed.
- Rob

>--Original Message--
>We are trying to exec sp_changedbowner 'sa' on model
database to change
>ownership from the service account 'service_sql' to 'sa'
account
>However, we got the follow error:
>15109 16 Cannot change the owner of the master database.
>Is there any know how to Change ownership of model and
msdb to 'sa' if in
>case 'sa' is not owner of msdb and model?
>Thanks!!
>.
>I am facing the same problem as Maggie. My Production's SQL2k MSDB & Model
database owner is my old NT Domain Administrator (olddomain/administrator).
Not sure how it ended that way. Master owner is SA.
We have completed domain migration to Active Directory, if sp_changedbowner
is not going to allow me to change DB owner for MSDB & Model, does that mean
I still got to keep my old domain forever ?
There must be a work-around for this.
"Rob" wrote:

> From BOL:
> The owner of the master, model, or tempdb system databases
> cannot be changed.
> - Rob
>
> database to change
> account
> msdb to 'sa' if in
>

Change owner

Is there a system SP to change object owner in the DB?Yes. Look up
sp_changeobjectowner

In Books on Line.

Jackie

"William F. O'Neill" <wfoneill@.bellsouth.net> wrote in message
news:J2A9d.299313$%n4.203169@.bignews6.bellsouth.ne t...
> Is there a system SP to change object owner in the DB?