Discussions
Activity
Best Of...
Sign In
·
Register
Home
›
SQL General
Howdy, Stranger!
It looks like you're new here. Sign in or register to get started.
Sign In
Register
Quick Links
Categories
Recent Discussions
Activity
Best Of...
Unanswered
Categories
All Categories
73
General
73
Announcements
66.6K
Microsoft Dynamics NAV
18.7K
NAV Three Tier
38.4K
NAV/Navision Classic Client
3.6K
Navision Attain
2.4K
Navision Financials
115
Navision DOS
854
Navision e-Commerce
1K
NAV Tips & Tricks
772
NAV Dutch speaking only
615
NAV Courses, Exams & Certification
2K
Microsoft Dynamics-Other
1.5K
Dynamics AX
305
Dynamics CRM
109
Dynamics GP
10
Dynamics SL
1.5K
Other
993
SQL General
384
SQL Performance
34
SQL Tips & Tricks
34
Design Patterns (General & Best Practices)
Architectural Patterns
10
Design Patterns
5
Implementation Patterns
53
3rd Party Products, Services & Events
1.7K
General
1.1K
General Chat
1.6K
Website
79
Testing
1.2K
Download section
23
How Tos section
260
Feedback
12
NAV TechDays 2013 Sessions
13
NAV TechDays 2012 Sessions
Transfer Logins to lower version SQL
Angelo
Member
Posts:
180
2012-08-09
edited 2012-10-02
in
SQL General
Hi All,
Is there T-Script like sp_help_revlogin to transfer logins from SQL 2008 R2 back to SQL 2000?
I am only able to find the other way (SQL 2000 to SQL 2008). :roll:
Rgds,
Angelo
0
Comments
macuxpc
Member
Posts:
16
2012-10-02
I would analyze the scripts in the following two KB articles and come up with my own to achieve what you are trying to do:
http://support.microsoft.com/kb/246133
http://support.microsoft.com/kb/918992
This would take quite some time, so it depends on how many users you are trying to transfer. Might be faster to do it manually.
On the other hand, I can't imagine a business scenario going from 2008 back to 2000
MacUxPC
Dynamics-NAV.org
0
Sign In
or
Register
to comment.
Comments
http://support.microsoft.com/kb/246133
http://support.microsoft.com/kb/918992
This would take quite some time, so it depends on how many users you are trying to transfer. Might be faster to do it manually.
On the other hand, I can't imagine a business scenario going from 2008 back to 2000
Dynamics-NAV.org