Copy Linked Server Password

Is there a way in SQL2005 to copy the linked server password from SQL2000?

We are about to copy our SQL 2000 database to SQL 2005 (and change operating systems and make other changes to the system). We can't do an upgrade in place because of the other changes, plus we want to have the original in case we can't get it updated before the start of business the next day.

I plan to move the databases by copying the files and attaching them, and I have a program that pulls users and encrypted passwords and adds them to the new system without encrypting the already encrypted passwords. Jobs I can script and run on the new system, DTS jobs I can open and save to the new system, and linked servers I can get the names of and link on the new server.

In SQL 2000 I would have "cheated" and copied the "DTS" and "Jobs" tables from one server to the other, but SQL 2005 has made it more complicated, so I will do it the slower way.

The problem comes with the linked server passwords. While I can see the linked server data in the master system tables, including the names and that there is an encrypted password. The problem is I don't know the passwords, so I can't enter it myself, and I can't update the system table, so I can't insert it as is. And sp_addlinkedsrvlogin does not have an option to not re-encrypt the password (like @.encryptopt = 'skip_encryption' in sp_addlogin).

Is there a way to figure out the password, or copy/insert the password without having it re-encrypt? In SQL2000 I would have done:

update A set
name = b.name,
password = b.password
from sysxlogins A, sysxlogins B
where A.srvid = 22
and B.srvid = 11

But SQL 2005 will not allow you to do this kind of update (allow updates has no effect).

Thanks, Tim

PS - Anything I might have missed that anyone can suggest, or any faster method of copying the database? We have a limited maintenance window to do this upgrade, so anything I can do ahead of time will help. Thanks again. Tim

Unfortunately, there is no supported method for doing this. You will have to recreate and respecify the passwords for those accounts.

Thanks
Laurentiu

|||Or, consider copying (backing up/restoring) everything to another machine and upgrading there from SQL Server 2000 to SQL Server 2005.

copy db sql7 ->2000 newbie question

Hi,
I have a backup copy of a database in sql 7. I am copying it over to sql
2000 and then restoring it. There are 3 views that show up in both the table
and view section in sql 2000 but they are only in the view section in sql 7.
(sql 7 running on windows 2000 server/sql 2000 on windows 2003 server.) why
is that happening?
Thanks for any help with this. much appreciated!
kak37
On Jun 13, 10:12 am, kak37 <k...@.discussions.microsoft.com> wrote:
> Hi,
> I have a backup copy of a database in sql 7. I am copying it over to sql
> 2000 and then restoring it. There are 3 views that show up in both the table
> and view section in sql 2000 but they are only in the view section in sql 7.
> (sql 7 running on windows 2000 server/sql 2000 on windows 2003 server.) why
> is that happening?
> Thanks for any help with this. much appreciated!
> --
> kak37
Try refresh at databse level (EM) and check again
sqlsql

copy db sql7 ->2000 newbie question

Hi,
I have a backup copy of a database in sql 7. I am copying it over to sql
2000 and then restoring it. There are 3 views that show up in both the table
and view section in sql 2000 but they are only in the view section in sql 7.
(sql 7 running on Windows 2000 server/sql 2000 on windows 2003 server.) why
is that happening?
Thanks for any help with this. much appreciated!
--
kak37On Jun 13, 10:12 am, kak37 <k...@.discussions.microsoft.com> wrote:
> Hi,
> I have a backup copy of a database in sql 7. I am copying it over to sql
> 2000 and then restoring it. There are 3 views that show up in both the tab
le
> and view section in sql 2000 but they are only in the view section in sql
7.
> (sql 7 running on Windows 2000 server/sql 2000 on windows 2003 server.) wh
y
> is that happening?
> Thanks for any help with this. much appreciated!
> --
> kak37
Try refresh at databse level (EM) and check again

Copy Database Wizard

Hello at all,
I want to transfer sql2000 databases and DTS from machine to another; I have
tried to use "Copy Datebase Wizard", but I'm not sure this is the best
choice. Does anyone want to help me?
thank you
Thanks a lot.
"vt" <vinu.t.1976@.gmail.com> wrote in message
news:eVmy20EnHHA.4424@.TK2MSFTNGP03.phx.gbl...
> hi
> see my blog
> http://oneplace4sql.blogspot.com/
> --
> VT
> Knowledge is power, share it...
> http://oneplace4sql.blogspot.com/
> "acolmano" <acolmano@.tin.it> wrote in message
> news:OL37WlEnHHA.3952@.TK2MSFTNGP03.phx.gbl...
>
|||Another question. what does occur if don't copy master database to target
machine?
Can I restore all DB with sql backup/restore utility? It's the same?
Thanks
"vt" <vinu.t.1976@.gmail.com> wrote in message
news:eVmy20EnHHA.4424@.TK2MSFTNGP03.phx.gbl...
> hi
> see my blog
> http://oneplace4sql.blogspot.com/
> --
> VT
> Knowledge is power, share it...
> http://oneplace4sql.blogspot.com/
> "acolmano" <acolmano@.tin.it> wrote in message
> news:OL37WlEnHHA.3952@.TK2MSFTNGP03.phx.gbl...
>
sqlsql

Copy Database Wizard

Hello at all,
I want to transfer sql2000 databases and DTS from machine to another; I have
tried to use "Copy Datebase Wizard", but I'm not sure this is the best
choice. Does anyone want to help me?
thank youhi
see my blog
http://oneplace4sql.blogspot.com/
--
VT
Knowledge is power, share it...
http://oneplace4sql.blogspot.com/
"acolmano" <acolmano@.tin.it> wrote in message
news:OL37WlEnHHA.3952@.TK2MSFTNGP03.phx.gbl...
> Hello at all,
> I want to transfer sql2000 databases and DTS from machine to another; I
> have tried to use "Copy Datebase Wizard", but I'm not sure this is the
> best choice. Does anyone want to help me?
> thank you|||Thanks a lot.
"vt" <vinu.t.1976@.gmail.com> wrote in message
news:eVmy20EnHHA.4424@.TK2MSFTNGP03.phx.gbl...
> hi
> see my blog
> http://oneplace4sql.blogspot.com/
> --
> VT
> Knowledge is power, share it...
> http://oneplace4sql.blogspot.com/
> "acolmano" <acolmano@.tin.it> wrote in message
> news:OL37WlEnHHA.3952@.TK2MSFTNGP03.phx.gbl...
>> Hello at all,
>> I want to transfer sql2000 databases and DTS from machine to another; I
>> have tried to use "Copy Datebase Wizard", but I'm not sure this is the
>> best choice. Does anyone want to help me?
>> thank you
>|||Another question. what does occur if don't copy master database to target
machine?
Can I restore all DB with sql backup/restore utility? It's the same?
Thanks
"vt" <vinu.t.1976@.gmail.com> wrote in message
news:eVmy20EnHHA.4424@.TK2MSFTNGP03.phx.gbl...
> hi
> see my blog
> http://oneplace4sql.blogspot.com/
> --
> VT
> Knowledge is power, share it...
> http://oneplace4sql.blogspot.com/
> "acolmano" <acolmano@.tin.it> wrote in message
> news:OL37WlEnHHA.3952@.TK2MSFTNGP03.phx.gbl...
>> Hello at all,
>> I want to transfer sql2000 databases and DTS from machine to another; I
>> have tried to use "Copy Datebase Wizard", but I'm not sure this is the
>> best choice. Does anyone want to help me?
>> thank you
>|||Hi
You can restore master database restore backup cmd. Microsoft recomended way
is using sqlcmd tool
http://msdn2.microsoft.com/en-us/library/ms190679.aspx
--
VT
Knowledge is power, share it...
http://oneplace4sql.blogspot.com/
"acolmano" <acolmano@.tin.it> wrote in message
news:eHwb62FnHHA.4196@.TK2MSFTNGP06.phx.gbl...
> Another question. what does occur if don't copy master database to target
> machine?
> Can I restore all DB with sql backup/restore utility? It's the same?
> Thanks
>
> "vt" <vinu.t.1976@.gmail.com> wrote in message
> news:eVmy20EnHHA.4424@.TK2MSFTNGP03.phx.gbl...
>> hi
>> see my blog
>> http://oneplace4sql.blogspot.com/
>> --
>> VT
>> Knowledge is power, share it...
>> http://oneplace4sql.blogspot.com/
>> "acolmano" <acolmano@.tin.it> wrote in message
>> news:OL37WlEnHHA.3952@.TK2MSFTNGP03.phx.gbl...
>> Hello at all,
>> I want to transfer sql2000 databases and DTS from machine to another; I
>> have tried to use "Copy Datebase Wizard", but I'm not sure this is the
>> best choice. Does anyone want to help me?
>> thank you
>>
>

Copy Database Wizard

Hello at all,
I want to transfer sql2000 databases and DTS from machine to another; I have
tried to use "Copy Datebase Wizard", but I'm not sure this is the best
choice. Does anyone want to help me?
thank youhi
see my blog
http://oneplace4sql.blogspot.com/
VT
Knowledge is power, share it...
http://oneplace4sql.blogspot.com/
"acolmano" <acolmano@.tin.it> wrote in message
news:OL37WlEnHHA.3952@.TK2MSFTNGP03.phx.gbl...
> Hello at all,
> I want to transfer sql2000 databases and DTS from machine to another; I
> have tried to use "Copy Datebase Wizard", but I'm not sure this is the
> best choice. Does anyone want to help me?
> thank you|||Thanks a lot.
"vt" <vinu.t.1976@.gmail.com> wrote in message
news:eVmy20EnHHA.4424@.TK2MSFTNGP03.phx.gbl...
> hi
> see my blog
> http://oneplace4sql.blogspot.com/
> --
> VT
> Knowledge is power, share it...
> http://oneplace4sql.blogspot.com/
> "acolmano" <acolmano@.tin.it> wrote in message
> news:OL37WlEnHHA.3952@.TK2MSFTNGP03.phx.gbl...
>|||Another question. what does occur if don't copy master database to target
machine?
Can I restore all DB with sql backup/restore utility? It's the same?
Thanks
"vt" <vinu.t.1976@.gmail.com> wrote in message
news:eVmy20EnHHA.4424@.TK2MSFTNGP03.phx.gbl...
> hi
> see my blog
> http://oneplace4sql.blogspot.com/
> --
> VT
> Knowledge is power, share it...
> http://oneplace4sql.blogspot.com/
> "acolmano" <acolmano@.tin.it> wrote in message
> news:OL37WlEnHHA.3952@.TK2MSFTNGP03.phx.gbl...
>|||Hi
You can restore master database restore backup cmd. Microsoft recomended way
is using sqlcmd tool
http://msdn2.microsoft.com/en-us/library/ms190679.aspx
--
VT
Knowledge is power, share it...
http://oneplace4sql.blogspot.com/
"acolmano" <acolmano@.tin.it> wrote in message
news:eHwb62FnHHA.4196@.TK2MSFTNGP06.phx.gbl...
> Another question. what does occur if don't copy master database to target
> machine?
> Can I restore all DB with sql backup/restore utility? It's the same?
> Thanks
>
> "vt" <vinu.t.1976@.gmail.com> wrote in message
> news:eVmy20EnHHA.4424@.TK2MSFTNGP03.phx.gbl...
>

Copy Database Question

Setting up a sql2005 db server, trying to use Copy Database to move from sql2000 to sql2000.

When I use the copy database wizard it does copy the tables and logins but it does not appear to be copying the permissions (like db_datareader, db_datawriter, db_denydatareader, db_denydatawriter, etc.)

What could I be missing?

Thanks

i could never get Copy Database to work when migrating to 2005. i ended up detaching the database and copying the mdf to the new server and re-attaching.|||

The Copy DB wizard does not copy all metadata from one server to another. Check out this article:

http://msdn2.microsoft.com/en-us/library/ms188664.aspx

Specifically, this section that tells how to migrate everything else over:

Managing Metadata When Restoring to Another Server Instance

When you copy a database to another server instance, to provide a consistent experience to users and applications, you might have to re-create some or all of the metadata for the database, such as logins and jobs, on the other server instance. For more information, see Managing Metadata When Making a Database Available on Another Server Instance.

Thanks,
Sam Lester (MSFT)

Copy Database from SQL 2000 to SQL 2005

I'm trying to use "Copy Database" to copy a database from a SQL2000 instance
to a SQL2005 instance; everthing looks ok until I execute the operation and
get an error message on the action "Create Package" of "One or more
arguments are invalid (Copy Database Wizard)"
I've gone over it and over it and cannot see where the problem might be ...
TIA for any suggestions ..
LI would use SSIS for this instead of DTS
"Liz" <liz@.tiredofspam.com> wrote in message
news:e82zA%2346HHA.1164@.TK2MSFTNGP02.phx.gbl...
> I'm trying to use "Copy Database" to copy a database from a SQL2000
> instance to a SQL2005 instance; everthing looks ok until I execute the
> operation and get an error message on the action "Create Package" of "One
> or more arguments are invalid (Copy Database Wizard)"
> I've gone over it and over it and cannot see where the problem might be
> ...
> TIA for any suggestions ..
> L
>

copy database feature

Hello,
I am trying to use the copy database funtion from sql2000 to sql2005. It
fails miserably and logs only says:
step 0: The job failed. The Job was invoked by User domain\user. The last
step to run was step 1 (CDW_DBSERVERNAME_USERMACHINE_1_Step).
step 1: Executed as user: domain\user. The package execution failed. The
step failed.
There is no destination db already existing, the feature drop any database
on the destination server is activated, it fails at Execute SQL Server Agent
Job.
Although the database is created there is no tables created.
The user in the source and destination server is the same for the sql
service and the agent.
I am a bit lost. Is ity possible to do that between sql2k and sql2k5?
Thanks for the help
Wilfrid
If you are copying the whole db why not just restore from a full backup of
the 2000 db on 2005?
Andrew J. Kelly SQL MVP
"Wilfrid" <grille11@.yahoo.com> wrote in message
news:4399b19d$0$22164$afc38c87@.news.easynet.fr...
> Hello,
> I am trying to use the copy database funtion from sql2000 to sql2005. It
> fails miserably and logs only says:
> step 0: The job failed. The Job was invoked by User domain\user. The
> last step to run was step 1 (CDW_DBSERVERNAME_USERMACHINE_1_Step).
> step 1: Executed as user: domain\user. The package execution failed. The
> step failed.
> There is no destination db already existing, the feature drop any database
> on the destination server is activated, it fails at Execute SQL Server
> Agent Job.
> Although the database is created there is no tables created.
> The user in the source and destination server is the same for the sql
> service and the agent.
> I am a bit lost. Is ity possible to do that between sql2k and sql2k5?
> Thanks for the help
> Wilfrid
>
|||The process of dumping a db from one server and then restore it to another server takes longer than just using a feature
available form sql2k5.
I was using, with sql2k, the exporting objects functionnality from one server to another but this feature is not
available anymore with sql 2k5 and I believe it has been replaced with the copy db.
Andrew J. Kelly wrote:
> If you are copying the whole db why not just restore from a full backup of
> the 2000 db on 2005?
>
|||The copy db functionality was available in 200 as well and is not new. But
it is usually not faster or cleaner than a backup and restore. You should
already be doing regular backups so all you have to do is issue the restore.
You don't even have to copy the file first. As long as the folder is
accessible from the other server you can restore directly from there.
Andrew J. Kelly SQL MVP
"grille11" <grille11@.yahoo.com> wrote in message
news:439b429e$0$22164$afc38c87@.news.easynet.fr...[vbcol=seagreen]
> The process of dumping a db from one server and then restore it to another
> server takes longer than just using a feature available form sql2k5.
> I was using, with sql2k, the exporting objects functionnality from one
> server to another but this feature is not available anymore with sql 2k5
> and I believe it has been replaced with the copy db.
>
> Andrew J. Kelly wrote:

copy database feature

Hello,
I am trying to use the copy database funtion from sql2000 to sql2005. It
fails miserably and logs only says:
step 0: The job failed. The Job was invoked by User domain\user. The last
step to run was step 1 (CDW_DBSERVERNAME_USERMACHINE_1_Step).
step 1: Executed as user: domain\user. The package execution failed. The
step failed.
There is no destination db already existing, the feature drop any database
on the destination server is activated, it fails at Execute SQL Server Agent
Job.
Although the database is created there is no tables created.
The user in the source and destination server is the same for the sql
service and the agent.
I am a bit lost. Is ity possible to do that between sql2k and sql2k5?
Thanks for the help
WilfridIf you are copying the whole db why not just restore from a full backup of
the 2000 db on 2005?
Andrew J. Kelly SQL MVP
"Wilfrid" <grille11@.yahoo.com> wrote in message
news:4399b19d$0$22164$afc38c87@.news.easynet.fr...
> Hello,
> I am trying to use the copy database funtion from sql2000 to sql2005. It
> fails miserably and logs only says:
> step 0: The job failed. The Job was invoked by User domain\user. The
> last step to run was step 1 (CDW_DBSERVERNAME_USERMACHINE_1_Step).
> step 1: Executed as user: domain\user. The package execution failed. The
> step failed.
> There is no destination db already existing, the feature drop any database
> on the destination server is activated, it fails at Execute SQL Server
> Agent Job.
> Although the database is created there is no tables created.
> The user in the source and destination server is the same for the sql
> service and the agent.
> I am a bit lost. Is ity possible to do that between sql2k and sql2k5?
> Thanks for the help
> Wilfrid
>|||The process of dumping a db from one server and then restore it to another s
erver takes longer than just using a feature
available form sql2k5.
I was using, with sql2k, the exporting objects functionnality from one serve
r to another but this feature is not
available anymore with sql 2k5 and I believe it has been replaced with the c
opy db.
Andrew J. Kelly wrote:
> If you are copying the whole db why not just restore from a full backup of
> the 2000 db on 2005?
>|||The copy db functionality was available in 200 as well and is not new. But
it is usually not faster or cleaner than a backup and restore. You should
already be doing regular backups so all you have to do is issue the restore.
You don't even have to copy the file first. As long as the folder is
accessible from the other server you can restore directly from there.
Andrew J. Kelly SQL MVP
"grille11" <grille11@.yahoo.com> wrote in message
news:439b429e$0$22164$afc38c87@.news.easynet.fr...[vbcol=seagreen]
> The process of dumping a db from one server and then restore it to another
> server takes longer than just using a feature available form sql2k5.
> I was using, with sql2k, the exporting objects functionnality from one
> server to another but this feature is not available anymore with sql 2k5
> and I believe it has been replaced with the copy db.
>
> Andrew J. Kelly wrote:

copy database feature

Hello,
I am trying to use the copy database funtion from sql2000 to sql2005. It
fails miserably and logs only says:
step 0: The job failed. The Job was invoked by User domain\user. The last
step to run was step 1 (CDW_DBSERVERNAME_USERMACHINE_1_Step).
step 1: Executed as user: domain\user. The package execution failed. The
step failed.
There is no destination db already existing, the feature drop any database
on the destination server is activated, it fails at Execute SQL Server Agent
Job.
Although the database is created there is no tables created.
The user in the source and destination server is the same for the sql
service and the agent.
I am a bit lost. Is ity possible to do that between sql2k and sql2k5?
Thanks for the help
WilfridIf you are copying the whole db why not just restore from a full backup of
the 2000 db on 2005?
--
Andrew J. Kelly SQL MVP
"Wilfrid" <grille11@.yahoo.com> wrote in message
news:4399b19d$0$22164$afc38c87@.news.easynet.fr...
> Hello,
> I am trying to use the copy database funtion from sql2000 to sql2005. It
> fails miserably and logs only says:
> step 0: The job failed. The Job was invoked by User domain\user. The
> last step to run was step 1 (CDW_DBSERVERNAME_USERMACHINE_1_Step).
> step 1: Executed as user: domain\user. The package execution failed. The
> step failed.
> There is no destination db already existing, the feature drop any database
> on the destination server is activated, it fails at Execute SQL Server
> Agent Job.
> Although the database is created there is no tables created.
> The user in the source and destination server is the same for the sql
> service and the agent.
> I am a bit lost. Is ity possible to do that between sql2k and sql2k5?
> Thanks for the help
> Wilfrid
>|||The process of dumping a db from one server and then restore it to another server takes longer than just using a feature
available form sql2k5.
I was using, with sql2k, the exporting objects functionnality from one server to another but this feature is not
available anymore with sql 2k5 and I believe it has been replaced with the copy db.
Andrew J. Kelly wrote:
> If you are copying the whole db why not just restore from a full backup of
> the 2000 db on 2005?
>|||The copy db functionality was available in 200 as well and is not new. But
it is usually not faster or cleaner than a backup and restore. You should
already be doing regular backups so all you have to do is issue the restore.
You don't even have to copy the file first. As long as the folder is
accessible from the other server you can restore directly from there.
--
Andrew J. Kelly SQL MVP
"grille11" <grille11@.yahoo.com> wrote in message
news:439b429e$0$22164$afc38c87@.news.easynet.fr...
> The process of dumping a db from one server and then restore it to another
> server takes longer than just using a feature available form sql2k5.
> I was using, with sql2k, the exporting objects functionnality from one
> server to another but this feature is not available anymore with sql 2k5
> and I believe it has been replaced with the copy db.
>
> Andrew J. Kelly wrote:
>> If you are copying the whole db why not just restore from a full backup
>> of the 2000 db on 2005?

copy database error (finding folder, login timeout)

Hello, just got SQL Server 2005 installed on a new production box and am
trying desperately to get data to it from an old SQL2000 production box -
unfortunately for me each time i try to use the copy database tools in order
to copy the database i get to the step where i am to "configure the package"
and the following popup appears:
While trying to find a folder on SQL an OLE DB error was encountered with
error code 0x80004005 (Login timeout expired).
I'm using the credentials of users who have sysAdmin priviledges.
Obviously this is leading to much hair pulling, screaming and near laptop
hurling. Someone please tell me what i'm doing wrong!?Matt
Why not just RESTORE the 'old' database (SQL Server 2000) to SQL Server
2005?
"Matt Pallatt" <matt.pallatt@.cmwnorth.com> wrote in message
news:OdKJlO5uGHA.4512@.TK2MSFTNGP05.phx.gbl...
> Hello, just got SQL Server 2005 installed on a new production box and am
> trying desperately to get data to it from an old SQL2000 production box -
> unfortunately for me each time i try to use the copy database tools in
> order to copy the database i get to the step where i am to "configure the
> package" and the following popup appears:
> While trying to find a folder on SQL an OLE DB error was encountered with
> error code 0x80004005 (Login timeout expired).
> I'm using the credentials of users who have sysAdmin priviledges.
> Obviously this is leading to much hair pulling, screaming and near laptop
> hurling. Someone please tell me what i'm doing wrong!?
>|||I unfortunately have no upload access to the box to get a backup onto it to
be able to restore an old DB
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OB$rmW5uGHA.4612@.TK2MSFTNGP02.phx.gbl...
> Matt
> Why not just RESTORE the 'old' database (SQL Server 2000) to SQL Server
> 2005?
>
> "Matt Pallatt" <matt.pallatt@.cmwnorth.com> wrote in message
> news:OdKJlO5uGHA.4512@.TK2MSFTNGP05.phx.gbl...
>|||Matt
I understood you use SQL Server200 as you wrote, did not you?
What tool dp you use to transfer the data? SSIS,DTS?
"Matt Pallatt" <matt.pallatt@.cmwnorth.com> wrote in message
news:u4riyy5uGHA.3552@.TK2MSFTNGP03.phx.gbl...[vbcol=seagreen]
>I unfortunately have no upload access to the box to get a backup onto it to
>be able to restore an old DB
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:OB$rmW5uGHA.4612@.TK2MSFTNGP02.phx.gbl...
>|||I think that this "I unfortunately have no upload access to the box" is the
clue to the situation.
SQL Server 'should' have permissions to the file system on the local server.
This error "While trying to find a folder on SQL an OLE DB error was
encountered with error code 0x80004005 (Login timeout expired)." makes it
seem like a file system permission issue.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Matt Pallatt" <matt.pallatt@.cmwnorth.com> wrote in message
news:u4riyy5uGHA.3552@.TK2MSFTNGP03.phx.gbl...
>I unfortunately have no upload access to the box to get a backup onto it to
>be able to restore an old DB
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:OB$rmW5uGHA.4612@.TK2MSFTNGP02.phx.gbl...
>

copy database error (finding folder, login timeout)

Hello, just got SQL Server 2005 installed on a new production box and am
trying desperately to get data to it from an old SQL2000 production box -
unfortunately for me each time i try to use the copy database tools in order
to copy the database i get to the step where i am to "configure the package"
and the following popup appears:
While trying to find a folder on SQL an OLE DB error was encountered with
error code 0x80004005 (Login timeout expired).
I'm using the credentials of users who have sysAdmin priviledges.
Obviously this is leading to much hair pulling, screaming and near laptop
hurling. Someone please tell me what i'm doing wrong!?Matt
Why not just RESTORE the 'old' database (SQL Server 2000) to SQL Server
2005?
"Matt Pallatt" <matt.pallatt@.cmwnorth.com> wrote in message
news:OdKJlO5uGHA.4512@.TK2MSFTNGP05.phx.gbl...
> Hello, just got SQL Server 2005 installed on a new production box and am
> trying desperately to get data to it from an old SQL2000 production box -
> unfortunately for me each time i try to use the copy database tools in
> order to copy the database i get to the step where i am to "configure the
> package" and the following popup appears:
> While trying to find a folder on SQL an OLE DB error was encountered with
> error code 0x80004005 (Login timeout expired).
> I'm using the credentials of users who have sysAdmin priviledges.
> Obviously this is leading to much hair pulling, screaming and near laptop
> hurling. Someone please tell me what i'm doing wrong!?
>|||I unfortunately have no upload access to the box to get a backup onto it to
be able to restore an old DB :(
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OB$rmW5uGHA.4612@.TK2MSFTNGP02.phx.gbl...
> Matt
> Why not just RESTORE the 'old' database (SQL Server 2000) to SQL Server
> 2005?
>
> "Matt Pallatt" <matt.pallatt@.cmwnorth.com> wrote in message
> news:OdKJlO5uGHA.4512@.TK2MSFTNGP05.phx.gbl...
>> Hello, just got SQL Server 2005 installed on a new production box and am
>> trying desperately to get data to it from an old SQL2000 production box -
>> unfortunately for me each time i try to use the copy database tools in
>> order to copy the database i get to the step where i am to "configure the
>> package" and the following popup appears:
>> While trying to find a folder on SQL an OLE DB error was encountered with
>> error code 0x80004005 (Login timeout expired).
>> I'm using the credentials of users who have sysAdmin priviledges.
>> Obviously this is leading to much hair pulling, screaming and near laptop
>> hurling. Someone please tell me what i'm doing wrong!?
>>
>|||Matt
>> trying desperately to get data to it from an old SQL2000 production
>> box - unfortunately for me each time i try to use the copy database
>> tools in order to copy the database i get to the step where i am to
>> "configure the package" and the following popup appears:
I understood you use SQL Server200 as you wrote, did not you?
What tool dp you use to transfer the data? SSIS,DTS?
"Matt Pallatt" <matt.pallatt@.cmwnorth.com> wrote in message
news:u4riyy5uGHA.3552@.TK2MSFTNGP03.phx.gbl...
>I unfortunately have no upload access to the box to get a backup onto it to
>be able to restore an old DB :(
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:OB$rmW5uGHA.4612@.TK2MSFTNGP02.phx.gbl...
>> Matt
>> Why not just RESTORE the 'old' database (SQL Server 2000) to SQL Server
>> 2005?
>>
>> "Matt Pallatt" <matt.pallatt@.cmwnorth.com> wrote in message
>> news:OdKJlO5uGHA.4512@.TK2MSFTNGP05.phx.gbl...
>> Hello, just got SQL Server 2005 installed on a new production box and am
>> trying desperately to get data to it from an old SQL2000 production
>> box - unfortunately for me each time i try to use the copy database
>> tools in order to copy the database i get to the step where i am to
>> "configure the package" and the following popup appears:
>> While trying to find a folder on SQL an OLE DB error was encountered
>> with error code 0x80004005 (Login timeout expired).
>> I'm using the credentials of users who have sysAdmin priviledges.
>> Obviously this is leading to much hair pulling, screaming and near
>> laptop hurling. Someone please tell me what i'm doing wrong!?
>>
>>
>|||I think that this "I unfortunately have no upload access to the box" is the
clue to the situation.
SQL Server 'should' have permissions to the file system on the local server.
This error "While trying to find a folder on SQL an OLE DB error was
encountered with error code 0x80004005 (Login timeout expired)." makes it
seem like a file system permission issue.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Matt Pallatt" <matt.pallatt@.cmwnorth.com> wrote in message
news:u4riyy5uGHA.3552@.TK2MSFTNGP03.phx.gbl...
>I unfortunately have no upload access to the box to get a backup onto it to
>be able to restore an old DB :(
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:OB$rmW5uGHA.4612@.TK2MSFTNGP02.phx.gbl...
>> Matt
>> Why not just RESTORE the 'old' database (SQL Server 2000) to SQL Server
>> 2005?
>>
>> "Matt Pallatt" <matt.pallatt@.cmwnorth.com> wrote in message
>> news:OdKJlO5uGHA.4512@.TK2MSFTNGP05.phx.gbl...
>> Hello, just got SQL Server 2005 installed on a new production box and am
>> trying desperately to get data to it from an old SQL2000 production
>> box - unfortunately for me each time i try to use the copy database
>> tools in order to copy the database i get to the step where i am to
>> "configure the package" and the following popup appears:
>> While trying to find a folder on SQL an OLE DB error was encountered
>> with error code 0x80004005 (Login timeout expired).
>> I'm using the credentials of users who have sysAdmin priviledges.
>> Obviously this is leading to much hair pulling, screaming and near
>> laptop hurling. Someone please tell me what i'm doing wrong!?
>>
>>
>

Converting to Hex

Hi All,

I'm needing to take a value inputted by a user via html form and convert it to a hex value upon inserting into SQL2000 db. I only need to store the 8 chars after "0x". Is there any T-SQL that can pull this off? CAST or CONVERT? Sorry if this is a silly question and hope I supplied enough info...

Thx,
Mike
Check this post (http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=386406&SiteID=1) for Umachandar's solution (which are always great!)

Converting SQL2000 database to SQL2005

Are there any stored procedures that have to be run on a database when
restoring from SQL2000 to SQL 2005? If so, which ones?
Many Thanks!
No. But you should probably run the Upgrade Advisor (found on the SQL 2005
distribution media) before moving the database over, in order to ensure that
at least most of your code is compatible (the Advisor won't find
everything).

Adam Machanic
SQL Server MVP
Author, "Expert SQL Server 2005 Development"
http://www.apress.com/book/bookDisplay.html?bID=10220
"Steve" <stevex2@.directcon.net> wrote in message
news:CD8A547F-7754-4FBB-9B6E-29C3B4AECB5C@.microsoft.com...
> Are there any stored procedures that have to be run on a database when
> restoring from SQL2000 to SQL 2005? If so, which ones?
> Many Thanks!
|||And also up date compatibility mode when you are ready for it (see sp_dbcmptlevel).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Adam Machanic" <amachanic@.IHATESPAMgmail.com> wrote in message
news:53A849D2-97E5-4ACE-A1DB-5EFC798026AF@.microsoft.com...
> No. But you should probably run the Upgrade Advisor (found on the SQL 2005 distribution media)
> before moving the database over, in order to ensure that at least most of your code is compatible
> (the Advisor won't find everything).
>
> --
> Adam Machanic
> SQL Server MVP
> Author, "Expert SQL Server 2005 Development"
> http://www.apress.com/book/bookDisplay.html?bID=10220
>
> "Steve" <stevex2@.directcon.net> wrote in message
> news:CD8A547F-7754-4FBB-9B6E-29C3B4AECB5C@.microsoft.com...
>

Converting SQL2000 database to SQL2005

Are there any stored procedures that have to be run on a database when
restoring from SQL2000 to SQL 2005? If so, which ones?
Many Thanks!No. But you should probably run the Upgrade Advisor (found on the SQL 2005
distribution media) before moving the database over, in order to ensure that
at least most of your code is compatible (the Advisor won't find
everything).
Adam Machanic
SQL Server MVP
Author, "Expert SQL Server 2005 Development"
http://www.apress.com/book/bookDisplay.html?bID=10220
"Steve" <stevex2@.directcon.net> wrote in message
news:CD8A547F-7754-4FBB-9B6E-29C3B4AECB5C@.microsoft.com...
> Are there any stored procedures that have to be run on a database when
> restoring from SQL2000 to SQL 2005? If so, which ones?
> Many Thanks!|||And also up date compatibility mode when you are ready for it (see sp_dbcmptlevel).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Adam Machanic" <amachanic@.IHATESPAMgmail.com> wrote in message
news:53A849D2-97E5-4ACE-A1DB-5EFC798026AF@.microsoft.com...
> No. But you should probably run the Upgrade Advisor (found on the SQL 2005 distribution media)
> before moving the database over, in order to ensure that at least most of your code is compatible
> (the Advisor won't find everything).
>
> --
> Adam Machanic
> SQL Server MVP
> Author, "Expert SQL Server 2005 Development"
> http://www.apress.com/book/bookDisplay.html?bID=10220
>
> "Steve" <stevex2@.directcon.net> wrote in message
> news:CD8A547F-7754-4FBB-9B6E-29C3B4AECB5C@.microsoft.com...
>> Are there any stored procedures that have to be run on a database when
>> restoring from SQL2000 to SQL 2005? If so, which ones?
>> Many Thanks!
>

Converting SQL2000 database to SQL2005

Are there any stored procedures that have to be run on a database when
restoring from SQL2000 to SQL 2005? If so, which ones?
Many Thanks!No. But you should probably run the Upgrade Advisor (found on the SQL 2005
distribution media) before moving the database over, in order to ensure that
at least most of your code is compatible (the Advisor won't find
everything).
Adam Machanic
SQL Server MVP
Author, "Expert SQL Server 2005 Development"
http://www.apress.com/book/bookDisplay.html?bID=10220
"Steve" <stevex2@.directcon.net> wrote in message
news:CD8A547F-7754-4FBB-9B6E-29C3B4AECB5C@.microsoft.com...
> Are there any stored procedures that have to be run on a database when
> restoring from SQL2000 to SQL 2005? If so, which ones?
> Many Thanks!|||And also up date compatibility mode when you are ready for it (see sp_dbcmpt
level).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Adam Machanic" <amachanic@.IHATESPAMgmail.com> wrote in message
news:53A849D2-97E5-4ACE-A1DB-5EFC798026AF@.microsoft.com...
> No. But you should probably run the Upgrade Advisor (found on the SQL 200
5 distribution media)
> before moving the database over, in order to ensure that at least most of
your code is compatible
> (the Advisor won't find everything).
>
> --
> Adam Machanic
> SQL Server MVP
> Author, "Expert SQL Server 2005 Development"
> http://www.apress.com/book/bookDisplay.html?bID=10220
>
> "Steve" <stevex2@.directcon.net> wrote in message
> news:CD8A547F-7754-4FBB-9B6E-29C3B4AECB5C@.microsoft.com...
>

Converting Pervasive SQL2000 SP3 To MS SQL2000

Does anyone know of way to convert a Pervasive SQL2000 SP3 database to a
Microsoft SQL2000 database?
Perhaps a third party conversion tool?
Thanks,
Robert
Can some one please answer this question?
Does anyone know of way to convert a Pervasive SQL2000 SP3 database to a
Microsoft SQL2000 database?
"robert_at_cbb" wrote:

> Does anyone know of way to convert a Pervasive SQL2000 SP3 database to a
> Microsoft SQL2000 database?
> Perhaps a third party conversion tool?
> Thanks,
> Robert
|||If you have an ODBC connector for the pervasive DB, you might try DTS as a
start...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"japson" <japson@.discussions.microsoft.com> wrote in message
news:6F5BB6DF-6258-4FF7-B60D-9CA9696FD168@.microsoft.com...[vbcol=seagreen]
> Can some one please answer this question?
> Does anyone know of way to convert a Pervasive SQL2000 SP3 database to a
> Microsoft SQL2000 database?
> "robert_at_cbb" wrote:

Converting Pervasive SQL2000 SP3 To MS SQL2000

Does anyone know of way to convert a Pervasive SQL2000 SP3 database to a
Microsoft SQL2000 database?
Perhaps a third party conversion tool?
Thanks,
RobertCan some one please answer this question?
Does anyone know of way to convert a Pervasive SQL2000 SP3 database to a
Microsoft SQL2000 database?
"robert_at_cbb" wrote:
> Does anyone know of way to convert a Pervasive SQL2000 SP3 database to a
> Microsoft SQL2000 database?
> Perhaps a third party conversion tool?
> Thanks,
> Robert|||If you have an ODBC connector for the pervasive DB, you might try DTS as a
start...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"japson" <japson@.discussions.microsoft.com> wrote in message
news:6F5BB6DF-6258-4FF7-B60D-9CA9696FD168@.microsoft.com...
> Can some one please answer this question?
> Does anyone know of way to convert a Pervasive SQL2000 SP3 database to a
> Microsoft SQL2000 database?
> "robert_at_cbb" wrote:
>> Does anyone know of way to convert a Pervasive SQL2000 SP3 database to a
>> Microsoft SQL2000 database?
>> Perhaps a third party conversion tool?
>> Thanks,
>> Robert

Converting Pervasive SQL2000 SP3 To MS SQL2000

Does anyone know of way to convert a Pervasive SQL2000 SP3 database to a
Microsoft SQL2000 database?
Perhaps a third party conversion tool?
Thanks,
RobertCan some one please answer this question?
Does anyone know of way to convert a Pervasive SQL2000 SP3 database to a
Microsoft SQL2000 database?
"robert_at_cbb" wrote:

> Does anyone know of way to convert a Pervasive SQL2000 SP3 database to a
> Microsoft SQL2000 database?
> Perhaps a third party conversion tool?
> Thanks,
> Robert|||If you have an ODBC connector for the pervasive DB, you might try DTS as a
start...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"japson" <japson@.discussions.microsoft.com> wrote in message
news:6F5BB6DF-6258-4FF7-B60D-9CA9696FD168@.microsoft.com...[vbcol=seagreen]
> Can some one please answer this question?
> Does anyone know of way to convert a Pervasive SQL2000 SP3 database to a
> Microsoft SQL2000 database?
> "robert_at_cbb" wrote:
>