Copy one coulm to another

Hi Everyone.
I have one table that has CUST_NO, LICENSE_NO and LOGIN. CUST_NO is unique.
I need to copy whatever is in LICENSE_NO field to LOGIN field. How can I do
this?
Thanks for your help.If you want to update all values in the LOGIN column, then it should be as
simple as this:
UPDATE MyTable
SET LOGIN = LICENSE_NO
HTH,
Plamen Ratchev
http://www.SQLStudio.com|||If I understand what you are trying to do...
update t1
set LOGIN=LICENSE_NO
--
Jason Massie
Web: http://statisticsio.com
RSS: http://feeds.feedburner.com/statisticsio
"Shan" <Shan@.discussions.microsoft.com> wrote in message
news:13B60DE7-BE32-426B-9EFB-1FA8B8010871@.microsoft.com...
> Hi Everyone.
> I have one table that has CUST_NO, LICENSE_NO and LOGIN. CUST_NO is
> unique.
> I need to copy whatever is in LICENSE_NO field to LOGIN field. How can I
> do
> this?
> Thanks for your help.|||"Shan" <Shan@.discussions.microsoft.com> wrote in message
news:13B60DE7-BE32-426B-9EFB-1FA8B8010871@.microsoft.com...
> Hi Everyone.
> I have one table that has CUST_NO, LICENSE_NO and LOGIN. CUST_NO is
> unique.
> I need to copy whatever is in LICENSE_NO field to LOGIN field. How can I
> do
> this?
> Thanks for your help.
UPDATE FOO set LOGIN=LICENSE_NO
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||Thanks very much. Works great.
"Plamen Ratchev" wrote:
> If you want to update all values in the LOGIN column, then it should be as
> simple as this:
> UPDATE MyTable
> SET LOGIN = LICENSE_NO
> HTH,
> Plamen Ratchev
> http://www.SQLStudio.com
>

Copy one coulm to another

Hi Everyone.
I have one table that has CUST_NO, LICENSE_NO and LOGIN. CUST_NO is unique.
I need to copy whatever is in LICENSE_NO field to LOGIN field. How can I do
this?
Thanks for your help.
If you want to update all values in the LOGIN column, then it should be as
simple as this:
UPDATE MyTable
SET LOGIN = LICENSE_NO
HTH,
Plamen Ratchev
http://www.SQLStudio.com
|||If I understand what you are trying to do...
update t1
set LOGIN=LICENSE_NO
Jason Massie
Web: http://statisticsio.com
RSS: http://feeds.feedburner.com/statisticsio
"Shan" <Shan@.discussions.microsoft.com> wrote in message
news:13B60DE7-BE32-426B-9EFB-1FA8B8010871@.microsoft.com...
> Hi Everyone.
> I have one table that has CUST_NO, LICENSE_NO and LOGIN. CUST_NO is
> unique.
> I need to copy whatever is in LICENSE_NO field to LOGIN field. How can I
> do
> this?
> Thanks for your help.
|||"Shan" <Shan@.discussions.microsoft.com> wrote in message
news:13B60DE7-BE32-426B-9EFB-1FA8B8010871@.microsoft.com...
> Hi Everyone.
> I have one table that has CUST_NO, LICENSE_NO and LOGIN. CUST_NO is
> unique.
> I need to copy whatever is in LICENSE_NO field to LOGIN field. How can I
> do
> this?
> Thanks for your help.
UPDATE FOO set LOGIN=LICENSE_NO
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
|||Thanks very much. Works great.
"Plamen Ratchev" wrote:

> If you want to update all values in the LOGIN column, then it should be as
> simple as this:
> UPDATE MyTable
> SET LOGIN = LICENSE_NO
> HTH,
> Plamen Ratchev
> http://www.SQLStudio.com
>
sqlsql

Copy Logins from Server1 to Server2

Hello,
I have 2 SqlServers, one has a lot of Login/Users/Permissions data. Is
there a way that I can export the logins acount info to the other sqlServer?
Thanks
Jose.DTS let you copy logins.
"Jose Ines Cantu Arrambide" <nospam@.nospam> wrote in message
news:%23aETDE52DHA.3416@.tk2msftngp13.phx.gbl...

quote:

---

> Hello,
> I have 2 SqlServers, one has a lot of Login/Users/Permissions data. Is
> there a way that I can export the logins acount info to the other

---

sqlServer?

quote:

---

> Thanks
> Jose.
>

---

|||There is a really good doc under Books On line, search for Log shipping...
Moving logins from one server to another is part of the failover process for
log shipping so the process is really documented well...
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.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
"Jose Ines Cantu Arrambide" <nospam@.nospam> wrote in message
news:#aETDE52DHA.3416@.tk2msftngp13.phx.gbl...

quote:

---

> Hello,
> I have 2 SqlServers, one has a lot of Login/Users/Permissions data. Is
> there a way that I can export the logins acount info to the other

---

sqlServer?

quote:

---

> Thanks
> Jose.
>

---

Copy Logins from Server1 to Server2

Hello,
I have 2 SqlServers, one has a lot of Login/Users/Permissions data. Is
there a way that I can export the logins acount info to the other sqlServer?
Thanks
Jose.DTS let you copy logins.
"Jose Ines Cantu Arrambide" <nospam@.nospam> wrote in message
news:%23aETDE52DHA.3416@.tk2msftngp13.phx.gbl...
> Hello,
> I have 2 SqlServers, one has a lot of Login/Users/Permissions data. Is
> there a way that I can export the logins acount info to the other
sqlServer?
> Thanks
> Jose.
>|||There is a really good doc under Books On line, search for Log shipping...
Moving logins from one server to another is part of the failover process for
log shipping so the process is really documented well...
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.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
"Jose Ines Cantu Arrambide" <nospam@.nospam> wrote in message
news:#aETDE52DHA.3416@.tk2msftngp13.phx.gbl...
> Hello,
> I have 2 SqlServers, one has a lot of Login/Users/Permissions data. Is
> there a way that I can export the logins acount info to the other
sqlServer?
> Thanks
> Jose.
>

Copy files from one server to another

hi,
I have a sql box under diff domain. I login as sqladmin mapped a network
drive pointed to the dir that I need to copy the files.
I created a job under command prompt--copy /Y z:\*'* \\server2\myfoleder\
If I run it under ms dos --OK, but running it through sql server job, got
this error:
The system cannot find the drive specified.
Any ideas
ThanksdOk, it is all a matter of security contexts:
WHO are you when you run from the command line?
WHO are you when you run a SQL Server Job:
If job runs as system administrator?
If job runs as a non-system administrator?
Does whatever account is actually running the job actually have rights to
the drive? Apparently not.
Also, FWIW, it is usually better not to use drive letters. Make a share and
use it with the standard non-dos notation.
RLF
"mecn" <mecn2002@.yahoo.com> wrote in message
news:%23THGzfPTGHA.4752@.TK2MSFTNGP10.phx.gbl...
> hi,
> I have a sql box under diff domain. I login as sqladmin mapped a network
> drive pointed to the dir that I need to copy the files.
> I created a job under command prompt--copy /Y z:\*'* \\server2\myfoleder\
> If I run it under ms dos --OK, but running it through sql server job,
> got this error:
> The system cannot find the drive specified.
>
> Any ideas
> Thanksd
>

Copy db - lose login mapping

Whenever I copy my production db back to my development server i lose the
user mapping for my app account and have to drop the db user, then remap the
login to the correct db. Then I have to reassign permissions to the user.
How can I prevent this from happening?
Thanks
Hi
http://dimantdatabasesolutions.blogspot.com/2007/04/sql-or-windows-authentication.html
"ken s" <kens@.discussions.microsoft.com> wrote in message
news:4B16A51F-FAD3-4D86-8D5D-1C0A03DBD660@.microsoft.com...
> Whenever I copy my production db back to my development server i lose the
> user mapping for my app account and have to drop the db user, then remap
> the
> login to the correct db. Then I have to reassign permissions to the user.
> How can I prevent this from happening?
> Thanks
>

Copy db - lose login mapping

Whenever I copy my production db back to my development server i lose the
user mapping for my app account and have to drop the db user, then remap the
login to the correct db. Then I have to reassign permissions to the user.
How can I prevent this from happening?
ThanksHi
http://dimantdatabasesolutions.blogspot.com/2007/04/sql-or-windows-authentication.html
"ken s" <kens@.discussions.microsoft.com> wrote in message
news:4B16A51F-FAD3-4D86-8D5D-1C0A03DBD660@.microsoft.com...
> Whenever I copy my production db back to my development server i lose the
> user mapping for my app account and have to drop the db user, then remap
> the
> login to the correct db. Then I have to reassign permissions to the user.
> How can I prevent this from happening?
> Thanks
>sqlsql

Copy db - lose login mapping

Whenever I copy my production db back to my development server i lose the
user mapping for my app account and have to drop the db user, then remap the
login to the correct db. Then I have to reassign permissions to the user.
How can I prevent this from happening?
ThanksThat's because the info to tie the user to the login is gone - the
users are orphaned. There is an sp you can use to fix orphaned users.
I am not where I can look it up but I have a SQL script that takes
care of mapping my users to the logins. I am assuming the logins and
users are the same on both systems. You can also check the
knowledgebase and look at the information on moving users and keeping
thier passwords, etc. when they move.
On Fri, 21 Dec 2007 15:05:00 -0800, ken s
<kens@.discussions.microsoft.com> wrote:

>Whenever I copy my production db back to my development server i lose the
>user mapping for my app account and have to drop the db user, then remap th
e
>login to the correct db. Then I have to reassign permissions to the user.
>How can I prevent this from happening?
>Thanks
>|||Hi
http://dimantdatabasesolutions.blog...on.
html
"ken s" <kens@.discussions.microsoft.com> wrote in message
news:4B16A51F-FAD3-4D86-8D5D-1C0A03DBD660@.microsoft.com...
> Whenever I copy my production db back to my development server i lose the
> user mapping for my app account and have to drop the db user, then remap
> the
> login to the correct db. Then I have to reassign permissions to the user.
> How can I prevent this from happening?
> Thanks
>

Copy Database Wizard and Logins?

I want to copy a database (including login users) from server A to server B
using the Copy Database Wizard.
I find that a Login is created at the server level, but it is disabled. When
I enable it, it seems to be a different user than at the database level.
What is the correct procedure to get the logins copied over and working?
OlavCDW doesn't create the login using the same SID as the original login. Use sp_help_revlogin (search
KB) instead.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Olav" <x@.y.com> wrote in message news:OfD%23hsZXGHA.3444@.TK2MSFTNGP05.phx.gbl...
>I want to copy a database (including login users) from server A to server B using the Copy Database
>Wizard.
> I find that a Login is created at the server level, but it is disabled. When I enable it, it seems
> to be a different user than at the database level.
> What is the correct procedure to get the logins copied over and working?
> Olav
>

Copy Database Wizard and Logins?

I want to copy a database (including login users) from server A to server B
using the Copy Database Wizard.
I find that a Login is created at the server level, but it is disabled. When
I enable it, it seems to be a different user than at the database level.
What is the correct procedure to get the logins copied over and working?
OlavCDW doesn't create the login using the same SID as the original login. Use s
p_help_revlogin (search
KB) instead.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Olav" <x@.y.com> wrote in message news:OfD%23hsZXGHA.3444@.TK2MSFTNGP05.phx.gbl...reen">
>I want to copy a database (including login users) from server A to server B
using the Copy Database
>Wizard.
> I find that a Login is created at the server level, but it is disabled. Wh
en I enable it, it seems
> to be a different user than at the database level.
> What is the correct procedure to get the logins copied over and working?
> Olav
>sqlsql

Copy Database Login Timout Expired

Hi,

I get the following error when I use the Copy Database Wizard. Tried searching for solutions but didn't find anything. One thing that caught my attention during the wizard was the "Package Location" dir. In my wizard it is greyed out and when I go to look on the server, that is where I am copying the database onto, that directory doesn't exist. Maybe that is causing it? I don't know. Really frustarted here. This looks like a very generic error to me but I don't know where to look because I'm still a M$ server newbie here. Thanks for your help.

TITLE: Copy Database Wizard

While trying to find a folder on SQL an OLE DB error was encountered with error code 0x80004005 (Login timeout expired).

ADDITIONAL INFORMATION:

While trying to find a folder on SQL an OLE DB error was encountered with error code 0x80004005 (Login timeout expired).

BUTTONS:

OK

Is this a really simple question that no one wants to answer? I ask because I saw someone else who posted the exact same problem and was never answered?

Thanks

|||

Unfortunately, there aren't enough details for us to answer the question.

What version of SQL Server are you using? If you run "SELECT @.@.Version" you will see what is installed.

We have made vast improvements in the Copy Database Wizard for SQL Server 2005 SP2. A CTP of SP2 will be released soon.

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

|||

Hi,

This is my version: Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2).

I've found another way to do what I want it to do so I'm fine for now. I will wait for SP2.

Thank you.

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!?
>>
>>
>