Hi,
Is there any relationship between a sql server error number and the naming
convention used in SqlServer Books Online documentation error documentation
files?
Example:
The file name for Error # 207 in books Online ends with "_1_1qyf.htm",
in the msdn version of books online it ends with "_1_1qyf.asp"
The file name for error # 208 ends with "_1_1qyg.asp"
My goal: to programtically generate urls that point to each error's
documentation in books online (sqlException's "Number" property contains the
error number value, so the idea is to programatically set the helplink
property to the correct url by evaluating the number value and running it
through some operation to create the correct url).
I know the error numbers refer to the error id column value in
master.dbo.sysmessages -- but i want to be able to derive urls to books
online from the error number b/c those files have more complete information.
Any suggestions?> Is there any relationship between a sql server error number and the naming
> convention used in SqlServer Books Online documentation error
> documentation
> files?
> My goal: to programtically generate urls that point to each error's
> documentation in books online (sqlException's "Number" property contains
> the
> error number value, so the idea is to programatically set the helplink
> property to the correct url by evaluating the number value and running it
> through some operation to create the correct url).
Sorry, there is no intentional relationship between an error message number
and the filename of the corresponding topic in BOL. Nor is there a way to
predict the filename based on the error number. The filenames for Books
Online topics are auto-generated by the authoring system we use. At best
you can know that the topics for system error messages will have a filename
that starts with "tr_reslsyserr_%" , but the numbering sequence used to
create a unique filename (for example, tr_reslsyserr_1_2a0j.htm) is not
predictable.
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
"Chris Mohan" <ChrisMohan@.discussions.microsoft.com> wrote in message
news:86009ACC-4B0E-4308-B642-4BCA8D9E12E9@.microsoft.com...
> Hi,
> Is there any relationship between a sql server error number and the naming
> convention used in SqlServer Books Online documentation error
> documentation
> files?
> Example:
> The file name for Error # 207 in books Online ends with "_1_1qyf.htm",
> in the msdn version of books online it ends with "_1_1qyf.asp"
> The file name for error # 208 ends with "_1_1qyg.asp"
> My goal: to programtically generate urls that point to each error's
> documentation in books online (sqlException's "Number" property contains
> the
> error number value, so the idea is to programatically set the helplink
> property to the correct url by evaluating the number value and running it
> through some operation to create the correct url).
> I know the error numbers refer to the error id column value in
> master.dbo.sysmessages -- but i want to be able to derive urls to books
> online from the error number b/c those files have more complete
> information.
> Any suggestions?
Showing posts with label sqlserver. Show all posts
Showing posts with label sqlserver. Show all posts
Wednesday, March 28, 2012
Relationship between Error Numbers and books Online URls?
Hi,
Is there any relationship between a sql server error number and the naming
convention used in SqlServer Books Online documentation error documentation
files?
Example:
The file name for Error # 207 in books Online ends with "_1_1qyf.htm",
in the msdn version of books online it ends with "_1_1qyf.asp"
The file name for error # 208 ends with "_1_1qyg.asp"
My goal: to programtically generate urls that point to each error's
documentation in books online (sqlException's "Number" property contains the
error number value, so the idea is to programatically set the helplink
property to the correct url by evaluating the number value and running it
through some operation to create the correct url).
I know the error numbers refer to the error id column value in
master.dbo.sysmessages -- but i want to be able to derive urls to books
online from the error number b/c those files have more complete information.
Any suggestions?
> Is there any relationship between a sql server error number and the naming
> convention used in SqlServer Books Online documentation error
> documentation
> files?
> My goal: to programtically generate urls that point to each error's
> documentation in books online (sqlException's "Number" property contains
> the
> error number value, so the idea is to programatically set the helplink
> property to the correct url by evaluating the number value and running it
> through some operation to create the correct url).
Sorry, there is no intentional relationship between an error message number
and the filename of the corresponding topic in BOL. Nor is there a way to
predict the filename based on the error number. The filenames for Books
Online topics are auto-generated by the authoring system we use. At best
you can know that the topics for system error messages will have a filename
that starts with "tr_reslsyserr_%" , but the numbering sequence used to
create a unique filename (for example, tr_reslsyserr_1_2a0j.htm) is not
predictable.
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
"Chris Mohan" <ChrisMohan@.discussions.microsoft.com> wrote in message
news:86009ACC-4B0E-4308-B642-4BCA8D9E12E9@.microsoft.com...
> Hi,
> Is there any relationship between a sql server error number and the naming
> convention used in SqlServer Books Online documentation error
> documentation
> files?
> Example:
> The file name for Error # 207 in books Online ends with "_1_1qyf.htm",
> in the msdn version of books online it ends with "_1_1qyf.asp"
> The file name for error # 208 ends with "_1_1qyg.asp"
> My goal: to programtically generate urls that point to each error's
> documentation in books online (sqlException's "Number" property contains
> the
> error number value, so the idea is to programatically set the helplink
> property to the correct url by evaluating the number value and running it
> through some operation to create the correct url).
> I know the error numbers refer to the error id column value in
> master.dbo.sysmessages -- but i want to be able to derive urls to books
> online from the error number b/c those files have more complete
> information.
> Any suggestions?
Is there any relationship between a sql server error number and the naming
convention used in SqlServer Books Online documentation error documentation
files?
Example:
The file name for Error # 207 in books Online ends with "_1_1qyf.htm",
in the msdn version of books online it ends with "_1_1qyf.asp"
The file name for error # 208 ends with "_1_1qyg.asp"
My goal: to programtically generate urls that point to each error's
documentation in books online (sqlException's "Number" property contains the
error number value, so the idea is to programatically set the helplink
property to the correct url by evaluating the number value and running it
through some operation to create the correct url).
I know the error numbers refer to the error id column value in
master.dbo.sysmessages -- but i want to be able to derive urls to books
online from the error number b/c those files have more complete information.
Any suggestions?
> Is there any relationship between a sql server error number and the naming
> convention used in SqlServer Books Online documentation error
> documentation
> files?
> My goal: to programtically generate urls that point to each error's
> documentation in books online (sqlException's "Number" property contains
> the
> error number value, so the idea is to programatically set the helplink
> property to the correct url by evaluating the number value and running it
> through some operation to create the correct url).
Sorry, there is no intentional relationship between an error message number
and the filename of the corresponding topic in BOL. Nor is there a way to
predict the filename based on the error number. The filenames for Books
Online topics are auto-generated by the authoring system we use. At best
you can know that the topics for system error messages will have a filename
that starts with "tr_reslsyserr_%" , but the numbering sequence used to
create a unique filename (for example, tr_reslsyserr_1_2a0j.htm) is not
predictable.
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
"Chris Mohan" <ChrisMohan@.discussions.microsoft.com> wrote in message
news:86009ACC-4B0E-4308-B642-4BCA8D9E12E9@.microsoft.com...
> Hi,
> Is there any relationship between a sql server error number and the naming
> convention used in SqlServer Books Online documentation error
> documentation
> files?
> Example:
> The file name for Error # 207 in books Online ends with "_1_1qyf.htm",
> in the msdn version of books online it ends with "_1_1qyf.asp"
> The file name for error # 208 ends with "_1_1qyg.asp"
> My goal: to programtically generate urls that point to each error's
> documentation in books online (sqlException's "Number" property contains
> the
> error number value, so the idea is to programatically set the helplink
> property to the correct url by evaluating the number value and running it
> through some operation to create the correct url).
> I know the error numbers refer to the error id column value in
> master.dbo.sysmessages -- but i want to be able to derive urls to books
> online from the error number b/c those files have more complete
> information.
> Any suggestions?
Monday, March 26, 2012
Relationship between Error Numbers and books Online URls?
Hi,
Is there any relationship between a sql server error number and the naming
convention used in SqlServer Books Online documentation error documentation
files?
Example:
The file name for Error # 207 in books Online ends with "_1_1qyf.htm",
in the msdn version of books online it ends with "_1_1qyf.asp"
The file name for error # 208 ends with "_1_1qyg.asp"
My goal: to programtically generate urls that point to each error's
documentation in books online (sqlException's "Number" property contains the
error number value, so the idea is to programatically set the helplink
property to the correct url by evaluating the number value and running it
through some operation to create the correct url).
I know the error numbers refer to the error id column value in
master.dbo.sysmessages -- but i want to be able to derive urls to books
online from the error number b/c those files have more complete information.
Any suggestions?> Is there any relationship between a sql server error number and the naming
> convention used in SqlServer Books Online documentation error
> documentation
> files?
> My goal: to programtically generate urls that point to each error's
> documentation in books online (sqlException's "Number" property contains
> the
> error number value, so the idea is to programatically set the helplink
> property to the correct url by evaluating the number value and running it
> through some operation to create the correct url).
Sorry, there is no intentional relationship between an error message number
and the filename of the corresponding topic in BOL. Nor is there a way to
predict the filename based on the error number. The filenames for Books
Online topics are auto-generated by the authoring system we use. At best
you can know that the topics for system error messages will have a filename
that starts with "tr_reslsyserr_%" , but the numbering sequence used to
create a unique filename (for example, tr_reslsyserr_1_2a0j.htm) is not
predictable.
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
"Chris Mohan" <ChrisMohan@.discussions.microsoft.com> wrote in message
news:86009ACC-4B0E-4308-B642-4BCA8D9E12E9@.microsoft.com...
> Hi,
> Is there any relationship between a sql server error number and the naming
> convention used in SqlServer Books Online documentation error
> documentation
> files?
> Example:
> The file name for Error # 207 in books Online ends with "_1_1qyf.htm",
> in the msdn version of books online it ends with "_1_1qyf.asp"
> The file name for error # 208 ends with "_1_1qyg.asp"
> My goal: to programtically generate urls that point to each error's
> documentation in books online (sqlException's "Number" property contains
> the
> error number value, so the idea is to programatically set the helplink
> property to the correct url by evaluating the number value and running it
> through some operation to create the correct url).
> I know the error numbers refer to the error id column value in
> master.dbo.sysmessages -- but i want to be able to derive urls to books
> online from the error number b/c those files have more complete
> information.
> Any suggestions?
Is there any relationship between a sql server error number and the naming
convention used in SqlServer Books Online documentation error documentation
files?
Example:
The file name for Error # 207 in books Online ends with "_1_1qyf.htm",
in the msdn version of books online it ends with "_1_1qyf.asp"
The file name for error # 208 ends with "_1_1qyg.asp"
My goal: to programtically generate urls that point to each error's
documentation in books online (sqlException's "Number" property contains the
error number value, so the idea is to programatically set the helplink
property to the correct url by evaluating the number value and running it
through some operation to create the correct url).
I know the error numbers refer to the error id column value in
master.dbo.sysmessages -- but i want to be able to derive urls to books
online from the error number b/c those files have more complete information.
Any suggestions?> Is there any relationship between a sql server error number and the naming
> convention used in SqlServer Books Online documentation error
> documentation
> files?
> My goal: to programtically generate urls that point to each error's
> documentation in books online (sqlException's "Number" property contains
> the
> error number value, so the idea is to programatically set the helplink
> property to the correct url by evaluating the number value and running it
> through some operation to create the correct url).
Sorry, there is no intentional relationship between an error message number
and the filename of the corresponding topic in BOL. Nor is there a way to
predict the filename based on the error number. The filenames for Books
Online topics are auto-generated by the authoring system we use. At best
you can know that the topics for system error messages will have a filename
that starts with "tr_reslsyserr_%" , but the numbering sequence used to
create a unique filename (for example, tr_reslsyserr_1_2a0j.htm) is not
predictable.
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
"Chris Mohan" <ChrisMohan@.discussions.microsoft.com> wrote in message
news:86009ACC-4B0E-4308-B642-4BCA8D9E12E9@.microsoft.com...
> Hi,
> Is there any relationship between a sql server error number and the naming
> convention used in SqlServer Books Online documentation error
> documentation
> files?
> Example:
> The file name for Error # 207 in books Online ends with "_1_1qyf.htm",
> in the msdn version of books online it ends with "_1_1qyf.asp"
> The file name for error # 208 ends with "_1_1qyg.asp"
> My goal: to programtically generate urls that point to each error's
> documentation in books online (sqlException's "Number" property contains
> the
> error number value, so the idea is to programatically set the helplink
> property to the correct url by evaluating the number value and running it
> through some operation to create the correct url).
> I know the error numbers refer to the error id column value in
> master.dbo.sysmessages -- but i want to be able to derive urls to books
> online from the error number b/c those files have more complete
> information.
> Any suggestions?
Relational database
Hi
I'm using VB.NET,ADO.NET in ASP.NET .
Microsoft .Net framework 1.0
Windows 2000
Visual Studio IDE
and SQLServer.
I have to create to tables as
Table1 contains ID,Name
Table2 contains ID,Marks,Foreign Key ie Primary key of the table Table1.
Give me an information how to create these two tables in SQLServer (I know how to create a table but i don't know how to create a table which includes Foreign Key.)
Then using Dataset i want to display the records as Name,Marks which are stored in two tables.
I have studied that in ADO Join query and record set object is used but it gives a problems and it is not good when we want to transfer the data between two applications or pages but dataset solves all those problems.
Give me an information about it.
Kindly help me
Thanks in advance
Regards.
To create table with Foreign key constraint using T-SQL:
create table tbl_PK (ID int primary key,name varchar(30))
go
create table tbl_FK (ID int foreign key REFERENCES tbl_PK(ID),
Marks varchar(50))
To get the joined result:
select p.name,f.marks from tbl_PK p join tbl_FK f
on p.ID=f.ID
Hi
What you have given is also a join query.but i have studied that no need of join query in case of dataset but it is required for record set.
Thanks
|||To do that, please take a look a the following short movie:http://msdn.microsoft.com/vstudio/express/media/en/AbsoluteBeginner/vb/08VB.wvx
This is tutorial movie about VWD 2005 and SQL server EE, I believe you can also apply it to VS 2005 because the similarity.
Basically what you do is you create database diagram with right clickon 'Database Diagram' under the Database explorer of your databasefilename. Then add new diagram. After that you can add all your tables,then drag the primary key to create the foreign key.
hope this will help.
Tuesday, March 20, 2012
Reinstall 2nd Node - SQLServer
Cluster active-active. The installation in one server was lost and the S.O.
was reinstalled. Now in one node there are two instances. How can I reinstall
de second node and move the instance to it ?
Look up Maintaining a Failover Cluster in SQL Books-Online. It has step by
step instructions on how to replace a failed cluster node.
Geoff N. Hiten
Microsoft SQL Server MVP
"Shima" <Shima@.discussions.microsoft.com> wrote in message
news:E612484F-C23F-4EAA-ADEA-3144C3247EE4@.microsoft.com...
> Cluster active-active. The installation in one server was lost and the
> S.O.
> was reinstalled. Now in one node there are two instances. How can I
> reinstall
> de second node and move the instance to it ?
>
|||I found on Technet a guideline about "Restoring a Node After a Catastrophic
Failure"
In one of the steps is necessary Remove the node from a virtual server (SQL
Server). My doubt is if in this moment the instance will be unavailable.
The last step is install SQL Server. Is it possible rebuild node to the
virtual server before install SQL Server ?
"Geoff N. Hiten" wrote:
> Look up Maintaining a Failover Cluster in SQL Books-Online. It has step by
> step instructions on how to replace a failed cluster node.
> Geoff N. Hiten
> Microsoft SQL Server MVP
> "Shima" <Shima@.discussions.microsoft.com> wrote in message
> news:E612484F-C23F-4EAA-ADEA-3144C3247EE4@.microsoft.com...
>
>
|||Again, Books-On-line has specific step-by step instructions on how to
restore a node under these exact circumstances. If you do the installation
according to the instructions, the instance will not need to go offline. If
you do not follow the instructions, you may damage your installation.
Geoff N. Hiten
Microsoft SQL Server MVP
"Shima" <Shima@.discussions.microsoft.com> wrote in message
news:EDBEA1E4-87FA-496A-893D-C8A354D57B37@.microsoft.com...[vbcol=seagreen]
>I found on Technet a guideline about "Restoring a Node After a Catastrophic
> Failure"
> In one of the steps is necessary Remove the node from a virtual server
> (SQL
> Server). My doubt is if in this moment the instance will be unavailable.
> The last step is install SQL Server. Is it possible rebuild node to the
> virtual server before install SQL Server ?
> "Geoff N. Hiten" wrote:
|||Thanks for your informations.
I tried to follow the instructions and the setup asked me to Uninstall the
Instance. What does it mean ? The instance will be removed physically ? My
doubt is in this moment. I'm not sure what SQL Setup will do. If the 2
instances will keep available or not. I'm in production environment and the
instances can't be unavailable.
thanks,
Simone
"Geoff N. Hiten" wrote:
> Again, Books-On-line has specific step-by step instructions on how to
> restore a node under these exact circumstances. If you do the installation
> according to the instructions, the instance will not need to go offline. If
> you do not follow the instructions, you may damage your installation.
> Geoff N. Hiten
> Microsoft SQL Server MVP
>
> "Shima" <Shima@.discussions.microsoft.com> wrote in message
> news:EDBEA1E4-87FA-496A-893D-C8A354D57B37@.microsoft.com...
>
>
|||The SQL installer needs to modify the remaining bits on Node 1 to remove all
references to Node 2. In essence, it is erasing all traces of Node 2 from
the SQL instance. It will not completely remove your SQL instance. If this
is done correctly, the SQL instance currently running on Node 1 will not be
affected.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
"Shima" <Shima@.discussions.microsoft.com> wrote in message
news:64C2F5EB-54A1-4233-87FA-122081210718@.microsoft.com...[vbcol=seagreen]
> Thanks for your informations.
> I tried to follow the instructions and the setup asked me to Uninstall the
> Instance. What does it mean ? The instance will be removed physically ? My
> doubt is in this moment. I'm not sure what SQL Setup will do. If the 2
> instances will keep available or not. I'm in production environment and
> the
> instances can't be unavailable.
> thanks,
> Simone
> "Geoff N. Hiten" wrote:
was reinstalled. Now in one node there are two instances. How can I reinstall
de second node and move the instance to it ?
Look up Maintaining a Failover Cluster in SQL Books-Online. It has step by
step instructions on how to replace a failed cluster node.
Geoff N. Hiten
Microsoft SQL Server MVP
"Shima" <Shima@.discussions.microsoft.com> wrote in message
news:E612484F-C23F-4EAA-ADEA-3144C3247EE4@.microsoft.com...
> Cluster active-active. The installation in one server was lost and the
> S.O.
> was reinstalled. Now in one node there are two instances. How can I
> reinstall
> de second node and move the instance to it ?
>
|||I found on Technet a guideline about "Restoring a Node After a Catastrophic
Failure"
In one of the steps is necessary Remove the node from a virtual server (SQL
Server). My doubt is if in this moment the instance will be unavailable.
The last step is install SQL Server. Is it possible rebuild node to the
virtual server before install SQL Server ?
"Geoff N. Hiten" wrote:
> Look up Maintaining a Failover Cluster in SQL Books-Online. It has step by
> step instructions on how to replace a failed cluster node.
> Geoff N. Hiten
> Microsoft SQL Server MVP
> "Shima" <Shima@.discussions.microsoft.com> wrote in message
> news:E612484F-C23F-4EAA-ADEA-3144C3247EE4@.microsoft.com...
>
>
|||Again, Books-On-line has specific step-by step instructions on how to
restore a node under these exact circumstances. If you do the installation
according to the instructions, the instance will not need to go offline. If
you do not follow the instructions, you may damage your installation.
Geoff N. Hiten
Microsoft SQL Server MVP
"Shima" <Shima@.discussions.microsoft.com> wrote in message
news:EDBEA1E4-87FA-496A-893D-C8A354D57B37@.microsoft.com...[vbcol=seagreen]
>I found on Technet a guideline about "Restoring a Node After a Catastrophic
> Failure"
> In one of the steps is necessary Remove the node from a virtual server
> (SQL
> Server). My doubt is if in this moment the instance will be unavailable.
> The last step is install SQL Server. Is it possible rebuild node to the
> virtual server before install SQL Server ?
> "Geoff N. Hiten" wrote:
|||Thanks for your informations.
I tried to follow the instructions and the setup asked me to Uninstall the
Instance. What does it mean ? The instance will be removed physically ? My
doubt is in this moment. I'm not sure what SQL Setup will do. If the 2
instances will keep available or not. I'm in production environment and the
instances can't be unavailable.
thanks,
Simone
"Geoff N. Hiten" wrote:
> Again, Books-On-line has specific step-by step instructions on how to
> restore a node under these exact circumstances. If you do the installation
> according to the instructions, the instance will not need to go offline. If
> you do not follow the instructions, you may damage your installation.
> Geoff N. Hiten
> Microsoft SQL Server MVP
>
> "Shima" <Shima@.discussions.microsoft.com> wrote in message
> news:EDBEA1E4-87FA-496A-893D-C8A354D57B37@.microsoft.com...
>
>
|||The SQL installer needs to modify the remaining bits on Node 1 to remove all
references to Node 2. In essence, it is erasing all traces of Node 2 from
the SQL instance. It will not completely remove your SQL instance. If this
is done correctly, the SQL instance currently running on Node 1 will not be
affected.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
"Shima" <Shima@.discussions.microsoft.com> wrote in message
news:64C2F5EB-54A1-4233-87FA-122081210718@.microsoft.com...[vbcol=seagreen]
> Thanks for your informations.
> I tried to follow the instructions and the setup asked me to Uninstall the
> Instance. What does it mean ? The instance will be removed physically ? My
> doubt is in this moment. I'm not sure what SQL Setup will do. If the 2
> instances will keep available or not. I'm in production environment and
> the
> instances can't be unavailable.
> thanks,
> Simone
> "Geoff N. Hiten" wrote:
Reinitializing Subscriptions
I am new to SQL Server Replication so I still have a cloud over my
head.
Our target system for a new application is to have a central Sql
Server 2000 SP3 with at least 50 laptops running MSDE 2000 SP3. Mobile
workforce will be updating data offline that will then need to synch
to the master and back down throughout the other laptops (some of it
anyway, dynamic filtering is next on my list). We want to use
anonymous subscriptions.
For testing, I have the Northwind database setup on Windows 2000
running Sql Server 2000 and an XP machine running MSDE. I am using
Visual Studio .NET on the XP machine to go against the ActiveX
Replication objects.
I have successfully setup merge replication. The XP machine uses .NET
code against the SQLMerge ActiveX object to use an anonymous
subscription to pull down data from the publisher. I was able to see
changes made on both databases get merged correctly. I was also able
to see conflicts and see them get resolved correctly.
One area I still fail to understand (and there are many) is
Reinitializing Subscriptions. The scenario I am trying to test is how
we roll out a new release of the existing application -- and in this
case -- changes to the database. I have read and re-read the
Reinitializing Subscriptions in Books Online but I just don't get it.
I changed my publication on the Northwind database to exclude sending
the Picture column in the Categories table. EM told me that all
subscriptions would be marked for reinitialization and that subscriber
data not synchronized first would be lost. So it works as EM and Books
Online say as I lost my data I changed on the laptop (I changed a
description field in the Categories table).
One thing that did not seem to jive with the documentation was that I
tried to synchronize the laptop database before creating the new
snapshot but the SQLMerge.Initialize method received an error saying
the snapshot was not up to date. So I did not have any way of getting
my changed data from the laptop to the server once I had made the
change to the publication.
In our production environment, the laptops will trickle in over time
complicating matters.
But basically, how do I make a change to the database that needs to
get down to the laptops AND preserve the data that has been collecting
on the laptops for weeks?
Crossing my fingers for something built-in,
Gar
There is an option called upload changes to publisher before
reinitialization.
Have a look at this property
Sub ReinitializeSubscription([bUploadBeforeReinit As Boolean = False])
I think you want to set this to True.
What will happen is changes which are pooled on the subscriber are uploaded
to the publisher before the schema changes and the merged data are sent to
the subscriber.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Now available on Amazon.com
http://www.amazon.com/gp/product/off...?condition=all
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"post messages" <post.messages@.gmail.com> wrote in message
news:c45b744b.0502031406.5dbd12bc@.posting.google.c om...
> I am new to SQL Server Replication so I still have a cloud over my
> head.
> Our target system for a new application is to have a central Sql
> Server 2000 SP3 with at least 50 laptops running MSDE 2000 SP3. Mobile
> workforce will be updating data offline that will then need to synch
> to the master and back down throughout the other laptops (some of it
> anyway, dynamic filtering is next on my list). We want to use
> anonymous subscriptions.
> For testing, I have the Northwind database setup on Windows 2000
> running Sql Server 2000 and an XP machine running MSDE. I am using
> Visual Studio .NET on the XP machine to go against the ActiveX
> Replication objects.
> I have successfully setup merge replication. The XP machine uses .NET
> code against the SQLMerge ActiveX object to use an anonymous
> subscription to pull down data from the publisher. I was able to see
> changes made on both databases get merged correctly. I was also able
> to see conflicts and see them get resolved correctly.
> One area I still fail to understand (and there are many) is
> Reinitializing Subscriptions. The scenario I am trying to test is how
> we roll out a new release of the existing application -- and in this
> case -- changes to the database. I have read and re-read the
> Reinitializing Subscriptions in Books Online but I just don't get it.
> I changed my publication on the Northwind database to exclude sending
> the Picture column in the Categories table. EM told me that all
> subscriptions would be marked for reinitialization and that subscriber
> data not synchronized first would be lost. So it works as EM and Books
> Online say as I lost my data I changed on the laptop (I changed a
> description field in the Categories table).
> One thing that did not seem to jive with the documentation was that I
> tried to synchronize the laptop database before creating the new
> snapshot but the SQLMerge.Initialize method received an error saying
> the snapshot was not up to date. So I did not have any way of getting
> my changed data from the laptop to the server once I had made the
> change to the publication.
> In our production environment, the laptops will trickle in over time
> complicating matters.
> But basically, how do I make a change to the database that needs to
> get down to the laptops AND preserve the data that has been collecting
> on the laptops for weeks?
> Crossing my fingers for something built-in,
> Gar
|||Hi Hilary,
Thanks for the reply. Based on what you said I did more searching in
the newsgroup. I found a post that is a little dated, didn't get
promising answers and is still important to the success of trying to
send out database schema upgrades through replication.
Detect Reinitialization is required.
http://groups-beta.google.com/group/...public.sqlser
ver.replication%26q%3DReinitializeSubscription%26q t_g%3D1%26searchnow%3DSearch+this+group%26&_doneTi tle=Back+to+Search&&d#62baf38ab39170d6
Since the laptops are going to have compiled .NET code calling the
merge object, how should they detect that they need to call
ReinitializeSubscription(true) before calling the usual Initialize,
Run, Terminate methods? My understanding is it is wrong to always call
ReinitializeSubscription(true) -- it has to be called only when
necessary.
Thanks,
Gary
head.
Our target system for a new application is to have a central Sql
Server 2000 SP3 with at least 50 laptops running MSDE 2000 SP3. Mobile
workforce will be updating data offline that will then need to synch
to the master and back down throughout the other laptops (some of it
anyway, dynamic filtering is next on my list). We want to use
anonymous subscriptions.
For testing, I have the Northwind database setup on Windows 2000
running Sql Server 2000 and an XP machine running MSDE. I am using
Visual Studio .NET on the XP machine to go against the ActiveX
Replication objects.
I have successfully setup merge replication. The XP machine uses .NET
code against the SQLMerge ActiveX object to use an anonymous
subscription to pull down data from the publisher. I was able to see
changes made on both databases get merged correctly. I was also able
to see conflicts and see them get resolved correctly.
One area I still fail to understand (and there are many) is
Reinitializing Subscriptions. The scenario I am trying to test is how
we roll out a new release of the existing application -- and in this
case -- changes to the database. I have read and re-read the
Reinitializing Subscriptions in Books Online but I just don't get it.
I changed my publication on the Northwind database to exclude sending
the Picture column in the Categories table. EM told me that all
subscriptions would be marked for reinitialization and that subscriber
data not synchronized first would be lost. So it works as EM and Books
Online say as I lost my data I changed on the laptop (I changed a
description field in the Categories table).
One thing that did not seem to jive with the documentation was that I
tried to synchronize the laptop database before creating the new
snapshot but the SQLMerge.Initialize method received an error saying
the snapshot was not up to date. So I did not have any way of getting
my changed data from the laptop to the server once I had made the
change to the publication.
In our production environment, the laptops will trickle in over time
complicating matters.
But basically, how do I make a change to the database that needs to
get down to the laptops AND preserve the data that has been collecting
on the laptops for weeks?
Crossing my fingers for something built-in,
Gar
There is an option called upload changes to publisher before
reinitialization.
Have a look at this property
Sub ReinitializeSubscription([bUploadBeforeReinit As Boolean = False])
I think you want to set this to True.
What will happen is changes which are pooled on the subscriber are uploaded
to the publisher before the schema changes and the merged data are sent to
the subscriber.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Now available on Amazon.com
http://www.amazon.com/gp/product/off...?condition=all
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"post messages" <post.messages@.gmail.com> wrote in message
news:c45b744b.0502031406.5dbd12bc@.posting.google.c om...
> I am new to SQL Server Replication so I still have a cloud over my
> head.
> Our target system for a new application is to have a central Sql
> Server 2000 SP3 with at least 50 laptops running MSDE 2000 SP3. Mobile
> workforce will be updating data offline that will then need to synch
> to the master and back down throughout the other laptops (some of it
> anyway, dynamic filtering is next on my list). We want to use
> anonymous subscriptions.
> For testing, I have the Northwind database setup on Windows 2000
> running Sql Server 2000 and an XP machine running MSDE. I am using
> Visual Studio .NET on the XP machine to go against the ActiveX
> Replication objects.
> I have successfully setup merge replication. The XP machine uses .NET
> code against the SQLMerge ActiveX object to use an anonymous
> subscription to pull down data from the publisher. I was able to see
> changes made on both databases get merged correctly. I was also able
> to see conflicts and see them get resolved correctly.
> One area I still fail to understand (and there are many) is
> Reinitializing Subscriptions. The scenario I am trying to test is how
> we roll out a new release of the existing application -- and in this
> case -- changes to the database. I have read and re-read the
> Reinitializing Subscriptions in Books Online but I just don't get it.
> I changed my publication on the Northwind database to exclude sending
> the Picture column in the Categories table. EM told me that all
> subscriptions would be marked for reinitialization and that subscriber
> data not synchronized first would be lost. So it works as EM and Books
> Online say as I lost my data I changed on the laptop (I changed a
> description field in the Categories table).
> One thing that did not seem to jive with the documentation was that I
> tried to synchronize the laptop database before creating the new
> snapshot but the SQLMerge.Initialize method received an error saying
> the snapshot was not up to date. So I did not have any way of getting
> my changed data from the laptop to the server once I had made the
> change to the publication.
> In our production environment, the laptops will trickle in over time
> complicating matters.
> But basically, how do I make a change to the database that needs to
> get down to the laptops AND preserve the data that has been collecting
> on the laptops for weeks?
> Crossing my fingers for something built-in,
> Gar
|||Hi Hilary,
Thanks for the reply. Based on what you said I did more searching in
the newsgroup. I found a post that is a little dated, didn't get
promising answers and is still important to the success of trying to
send out database schema upgrades through replication.
Detect Reinitialization is required.
http://groups-beta.google.com/group/...public.sqlser
ver.replication%26q%3DReinitializeSubscription%26q t_g%3D1%26searchnow%3DSearch+this+group%26&_doneTi tle=Back+to+Search&&d#62baf38ab39170d6
Since the laptops are going to have compiled .NET code calling the
merge object, how should they detect that they need to call
ReinitializeSubscription(true) before calling the usual Initialize,
Run, Terminate methods? My understanding is it is wrong to always call
ReinitializeSubscription(true) -- it has to be called only when
necessary.
Thanks,
Gary
Friday, March 9, 2012
Regular expression..
Does SqlServer support Regular expression?
I want to know if it's avilable or not...
And if it's not available, I want to know any other efficient way to validate string.. manipulating Regular expression style validation.
Thank you all...use sp_oaxxx, works like a charm :)|||Transact-SQL 2000 supports a very crude, grep like set of regular expressions for the LIKE (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_la-lz_115x.asp) operator. I don't know of anything like the regular expressions in Perl, awk, vi, or gres within Transact-SQL (and would often kill for such a thing!). This is coming in Yukon, but that is still a ways off.
-PatP|||Pat, check this (http://www.sqlteam.com/item.asp?ItemID=13947) out, it may change your mind ;)|||That example gets you about 30% of grep, which is a considerable improvement over what LIKE gives you. It doesn't get any significant part of regexp as offered by Perl, awk, gres, etc.
I still use Perl when the going gets tough. Perl can open an ODBC connection, mangle the data, and be done before I could figure out how to identify the data that I needed to change using LIKE!
-PatP|||No pressure, just a thought ;)|||Thank you all for considering.
rdjabarov's link give that I really needed.
I want to know if it's avilable or not...
And if it's not available, I want to know any other efficient way to validate string.. manipulating Regular expression style validation.
Thank you all...use sp_oaxxx, works like a charm :)|||Transact-SQL 2000 supports a very crude, grep like set of regular expressions for the LIKE (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_la-lz_115x.asp) operator. I don't know of anything like the regular expressions in Perl, awk, vi, or gres within Transact-SQL (and would often kill for such a thing!). This is coming in Yukon, but that is still a ways off.
-PatP|||Pat, check this (http://www.sqlteam.com/item.asp?ItemID=13947) out, it may change your mind ;)|||That example gets you about 30% of grep, which is a considerable improvement over what LIKE gives you. It doesn't get any significant part of regexp as offered by Perl, awk, gres, etc.
I still use Perl when the going gets tough. Perl can open an ODBC connection, mangle the data, and be done before I could figure out how to identify the data that I needed to change using LIKE!
-PatP|||No pressure, just a thought ;)|||Thank you all for considering.
rdjabarov's link give that I really needed.
Wednesday, March 7, 2012
Registry For Cluster
What is the registry path for checking if there is a SQLServer installed as a
virtual server on the machine. What I am trying to get here is if I logged on
to a machine and I want to read from registry if there is any SQL Virtual
server installed on this machine or not. I need to know all the names of SQL
that could be a default instance on virtual server or a named instance.
It is a windows 2003 in sql 2000 environment.
Any help will be appreciated.
-Nitin
What a terrible newsgroup it is. Not even people from MS respond to the
request hanging for over 2 days
"Nitin" wrote:
> What is the registry path for checking if there is a SQLServer installed as a
> virtual server on the machine. What I am trying to get here is if I logged on
> to a machine and I want to read from registry if there is any SQL Virtual
> server installed on this machine or not. I need to know all the names of SQL
> that could be a default instance on virtual server or a named instance.
> It is a windows 2003 in sql 2000 environment.
> Any help will be appreciated.
> -Nitin
|||Personally, I would not interrogate the registry to find whether there is any
clustered SQL instance. rather, I'd just use Cluster Automation Server (CAS)
via a script. See this article
http://support.microsoft.com/default...B;en-us;244597
for an example on how to script with CAS.
Linchi
"Nitin" wrote:
> What is the registry path for checking if there is a SQLServer installed as a
> virtual server on the machine. What I am trying to get here is if I logged on
> to a machine and I want to read from registry if there is any SQL Virtual
> server installed on this machine or not. I need to know all the names of SQL
> that could be a default instance on virtual server or a named instance.
> It is a windows 2003 in sql 2000 environment.
> Any help will be appreciated.
> -Nitin
virtual server on the machine. What I am trying to get here is if I logged on
to a machine and I want to read from registry if there is any SQL Virtual
server installed on this machine or not. I need to know all the names of SQL
that could be a default instance on virtual server or a named instance.
It is a windows 2003 in sql 2000 environment.
Any help will be appreciated.
-Nitin
What a terrible newsgroup it is. Not even people from MS respond to the
request hanging for over 2 days
"Nitin" wrote:
> What is the registry path for checking if there is a SQLServer installed as a
> virtual server on the machine. What I am trying to get here is if I logged on
> to a machine and I want to read from registry if there is any SQL Virtual
> server installed on this machine or not. I need to know all the names of SQL
> that could be a default instance on virtual server or a named instance.
> It is a windows 2003 in sql 2000 environment.
> Any help will be appreciated.
> -Nitin
|||Personally, I would not interrogate the registry to find whether there is any
clustered SQL instance. rather, I'd just use Cluster Automation Server (CAS)
via a script. See this article
http://support.microsoft.com/default...B;en-us;244597
for an example on how to script with CAS.
Linchi
"Nitin" wrote:
> What is the registry path for checking if there is a SQLServer installed as a
> virtual server on the machine. What I am trying to get here is if I logged on
> to a machine and I want to read from registry if there is any SQL Virtual
> server installed on this machine or not. I need to know all the names of SQL
> that could be a default instance on virtual server or a named instance.
> It is a windows 2003 in sql 2000 environment.
> Any help will be appreciated.
> -Nitin
Registration from Enterprise Manager
Here is my problem:
I have a sqlserver SQLA which I have registered in EM with a sqlserver
authentication with a uid and password and that connection works fine. The
problem is that when I look at the security log of SQLA, i see continuous
failure audits but with a uid that I am logging in to my local machine with.
My question is that when I am choosing to use sqlserver authentication and
not windows authentication to connect to SQLA, how come it is in turn still
sending windows authentication requests at the same time.
Few thing that have led me to this is:
1.When I delete the sqlserver registration from EM, those failure audits
stop, so that nakes me sure that these are coming from EM only.
2. When I map a drive to SQLA with windows credentials, these failure audits
stop, which indicates that it is succeeding in windows authentication ,
thats why the audits stop.
Please let me know your thoughts?
What you are seeing is probably related to the polling that Enterprise
Manager does - it polls the SQL and related services on the servers
that you have registered. You can turn this off in Enterprise Manager
by going up to the menu to Tools and selecting Options. On the general
tab, you can remove the check for Server State Polling.
-Sue
On Fri, 10 Sep 2004 15:44:06 GMT, "Renu Doda" <r_doda@.hotmail.com>
wrote:
>Here is my problem:
>I have a sqlserver SQLA which I have registered in EM with a sqlserver
>authentication with a uid and password and that connection works fine. The
>problem is that when I look at the security log of SQLA, i see continuous
>failure audits but with a uid that I am logging in to my local machine with.
>My question is that when I am choosing to use sqlserver authentication and
>not windows authentication to connect to SQLA, how come it is in turn still
>sending windows authentication requests at the same time.
>Few thing that have led me to this is:
>1.When I delete the sqlserver registration from EM, those failure audits
>stop, so that nakes me sure that these are coming from EM only.
>2. When I map a drive to SQLA with windows credentials, these failure audits
>stop, which indicates that it is succeeding in windows authentication ,
>thats why the audits stop.
>Please let me know your thoughts?
>
I have a sqlserver SQLA which I have registered in EM with a sqlserver
authentication with a uid and password and that connection works fine. The
problem is that when I look at the security log of SQLA, i see continuous
failure audits but with a uid that I am logging in to my local machine with.
My question is that when I am choosing to use sqlserver authentication and
not windows authentication to connect to SQLA, how come it is in turn still
sending windows authentication requests at the same time.
Few thing that have led me to this is:
1.When I delete the sqlserver registration from EM, those failure audits
stop, so that nakes me sure that these are coming from EM only.
2. When I map a drive to SQLA with windows credentials, these failure audits
stop, which indicates that it is succeeding in windows authentication ,
thats why the audits stop.
Please let me know your thoughts?
What you are seeing is probably related to the polling that Enterprise
Manager does - it polls the SQL and related services on the servers
that you have registered. You can turn this off in Enterprise Manager
by going up to the menu to Tools and selecting Options. On the general
tab, you can remove the check for Server State Polling.
-Sue
On Fri, 10 Sep 2004 15:44:06 GMT, "Renu Doda" <r_doda@.hotmail.com>
wrote:
>Here is my problem:
>I have a sqlserver SQLA which I have registered in EM with a sqlserver
>authentication with a uid and password and that connection works fine. The
>problem is that when I look at the security log of SQLA, i see continuous
>failure audits but with a uid that I am logging in to my local machine with.
>My question is that when I am choosing to use sqlserver authentication and
>not windows authentication to connect to SQLA, how come it is in turn still
>sending windows authentication requests at the same time.
>Few thing that have led me to this is:
>1.When I delete the sqlserver registration from EM, those failure audits
>stop, so that nakes me sure that these are coming from EM only.
>2. When I map a drive to SQLA with windows credentials, these failure audits
>stop, which indicates that it is succeeding in windows authentication ,
>thats why the audits stop.
>Please let me know your thoughts?
>
Saturday, February 25, 2012
Registering/licensing DEMO SQLserver....
Hello,
I am new to SQLserver and have installed the DEMO version of SQLserver 2000 on my system. I got it up and running and verified that it was working properly.
I then purchased two CPU's of the standard edition for my system. The software has arrived, but all that arrived are the CD's. I see no key, nor do I see a way to provide a key even if I had one.
I do not know how to proceeed and need help to figure out how to obtain a key or how to enter it if I ever obtain one.
Any help is greatly appreciated!!!!!
Thanks,
JamesActually, your CD's are supposed to be accompanied by invoice where corresponding keys are clearly printed out. If this is not the case you fell victim to some SW scam.|||Ask the vendor for such keys, in general MS software CDs comes with CD key printed on the CD or a paper attached to the CD cover.|||No such keys on the CD or paper. We are trying to get paperwork for the licenses. When I do get it how do I put them in? I saw no place to put a license in the system. I looked at length, but it obviously means I was not looking in the right place!
Anyone know how to put the key into the system?
James|||look in adminstrative tools
open licensing
you can add\update your lic there
when you say DEMO version of SQL Server, what do you mean?|||I take it DEMO means eval version, and Licensing service in Control Panel has nothing to do with Product Key, BTW.|||i didnt think that he was talking about a product key
he mentions
No such keys on the CD or paper. We are trying to get paperwork for the licenses. When I do get it how do I put them in? I saw no place to put a license in the system. I looked at length, but it obviously means I was not looking in the right place!
Anyone know how to put the key into the system?
i assume he is discussing lics and then he mentions keys!!!??
i'm linguistically hogtied.|||I think it is I that is not making myself clear due to the fact that I really do not know. I have never done this before, and I am sure it is a very simple question.
We have ordered two CPU licenses for SQL Server and I have not seen anything that looks like a "key" that I would normally associate as a Microsoft license key. Hence, I think we need the paperwork that goes with the licenses from my vendor as the others have mentioned. I am awaiting that now (I hope).
I think the issues came when I asked how to register (license) the product once I get the license keys. I have found no way to actually put those ubiquitous Microsoft keys in (that I am not in possession of at this time) to any software.
To an old unix person it is a mystery.
Thanks again for putting up with my silliness.
James|||Oh, so you're saying that throughout the installation process you did not have to nor were you asked to enter the Product Key?
Can you send me this CD?|||Are those by any chance "SELECT" CD's? If you work for a corporation with volume licensing, your company may get CDs with their registration number "burned in", and pay for licenses based on inventory rather than buying them at retail.
-PatP|||Yup, that's what it sounds like...unless it's an eval, 90 or 120-day.|||I initially loaded the evaluation version that I downloaded off the web. I was calling this the DEMO version in earlier emails, sorry for that mixup.
I was also told that it was a full copy and all I needed to do was apply my licenses when they arrived. That is where the problem is, both not having the license keys, nor knowing how or being able to find out how to apply them when they do arrive.
I am handling getting the keys, but need to know how to apply them when they come.
James|||So, do you have a CD?|||I do now, but I do not see anything that looks like a Microsoft key anywhere on them. Nor did the paperwork have anything like that.|||Did you buy these CDs from a vendor, or requisition them from some kind of "IT Central" within your organization?
-PatP|||If the CD does NOT have anything like "Evaluation...", then uninstall your eval AFTER BACKING UP MASTER, MSDB, and your own DATABASES (!!!), and proceed with normal installation from the CD. If you do run into "Enter Product Key..." situation, contact your SW vendor or whoever you purchased it from, else - keep going. Once installed, you'll need to restore your master (check Books Online) and msdb, along with your user database. Last, but not least - download and apply SP3.|||Heck, I'm paranoid. I remove the TCP/IP, install SQL 2000, install either sp2 or sp3a, then reboot. Once the box has gone down, then I plug the TCP/IP cable back into it.
-PatP|||Answers:
1) These are licenses we pruchased from a vendor we deal with all the time. I actually got two sets of CD's instead of just one, I guess since I ordered two CPU's worth of licenses.
2) We do not have a site license, we are a small organization and this is the first time we are using SQLserver.
Outlook:
So, it looks like I will need to do the thing I didn't want to do which is de-install the evaluation copy and re-install the real one off CD. Of course I will not do this until I get what looks like Microsoft keys (or the like) in my hands.
Thanks for all the help. Hopefully I can learn more about this stuff and help a few others along the way.
James
I am new to SQLserver and have installed the DEMO version of SQLserver 2000 on my system. I got it up and running and verified that it was working properly.
I then purchased two CPU's of the standard edition for my system. The software has arrived, but all that arrived are the CD's. I see no key, nor do I see a way to provide a key even if I had one.
I do not know how to proceeed and need help to figure out how to obtain a key or how to enter it if I ever obtain one.
Any help is greatly appreciated!!!!!
Thanks,
JamesActually, your CD's are supposed to be accompanied by invoice where corresponding keys are clearly printed out. If this is not the case you fell victim to some SW scam.|||Ask the vendor for such keys, in general MS software CDs comes with CD key printed on the CD or a paper attached to the CD cover.|||No such keys on the CD or paper. We are trying to get paperwork for the licenses. When I do get it how do I put them in? I saw no place to put a license in the system. I looked at length, but it obviously means I was not looking in the right place!
Anyone know how to put the key into the system?
James|||look in adminstrative tools
open licensing
you can add\update your lic there
when you say DEMO version of SQL Server, what do you mean?|||I take it DEMO means eval version, and Licensing service in Control Panel has nothing to do with Product Key, BTW.|||i didnt think that he was talking about a product key
he mentions
No such keys on the CD or paper. We are trying to get paperwork for the licenses. When I do get it how do I put them in? I saw no place to put a license in the system. I looked at length, but it obviously means I was not looking in the right place!
Anyone know how to put the key into the system?
i assume he is discussing lics and then he mentions keys!!!??
i'm linguistically hogtied.|||I think it is I that is not making myself clear due to the fact that I really do not know. I have never done this before, and I am sure it is a very simple question.
We have ordered two CPU licenses for SQL Server and I have not seen anything that looks like a "key" that I would normally associate as a Microsoft license key. Hence, I think we need the paperwork that goes with the licenses from my vendor as the others have mentioned. I am awaiting that now (I hope).
I think the issues came when I asked how to register (license) the product once I get the license keys. I have found no way to actually put those ubiquitous Microsoft keys in (that I am not in possession of at this time) to any software.
To an old unix person it is a mystery.
Thanks again for putting up with my silliness.
James|||Oh, so you're saying that throughout the installation process you did not have to nor were you asked to enter the Product Key?
Can you send me this CD?|||Are those by any chance "SELECT" CD's? If you work for a corporation with volume licensing, your company may get CDs with their registration number "burned in", and pay for licenses based on inventory rather than buying them at retail.
-PatP|||Yup, that's what it sounds like...unless it's an eval, 90 or 120-day.|||I initially loaded the evaluation version that I downloaded off the web. I was calling this the DEMO version in earlier emails, sorry for that mixup.
I was also told that it was a full copy and all I needed to do was apply my licenses when they arrived. That is where the problem is, both not having the license keys, nor knowing how or being able to find out how to apply them when they do arrive.
I am handling getting the keys, but need to know how to apply them when they come.
James|||So, do you have a CD?|||I do now, but I do not see anything that looks like a Microsoft key anywhere on them. Nor did the paperwork have anything like that.|||Did you buy these CDs from a vendor, or requisition them from some kind of "IT Central" within your organization?
-PatP|||If the CD does NOT have anything like "Evaluation...", then uninstall your eval AFTER BACKING UP MASTER, MSDB, and your own DATABASES (!!!), and proceed with normal installation from the CD. If you do run into "Enter Product Key..." situation, contact your SW vendor or whoever you purchased it from, else - keep going. Once installed, you'll need to restore your master (check Books Online) and msdb, along with your user database. Last, but not least - download and apply SP3.|||Heck, I'm paranoid. I remove the TCP/IP, install SQL 2000, install either sp2 or sp3a, then reboot. Once the box has gone down, then I plug the TCP/IP cable back into it.
-PatP|||Answers:
1) These are licenses we pruchased from a vendor we deal with all the time. I actually got two sets of CD's instead of just one, I guess since I ordered two CPU's worth of licenses.
2) We do not have a site license, we are a small organization and this is the first time we are using SQLserver.
Outlook:
So, it looks like I will need to do the thing I didn't want to do which is de-install the evaluation copy and re-install the real one off CD. Of course I will not do this until I get what looks like Microsoft keys (or the like) in my hands.
Thanks for all the help. Hopefully I can learn more about this stuff and help a few others along the way.
James
Monday, February 20, 2012
register sql2000 on SQL2005 manager
I have two servers 2003, one running sqlserver 2005 and the second sqlserver
2000.
I'd like to register the sql2000 on the sqlserver management studio provides
with sql2005.
when I trie to connect to server with sql2000 I get an time out error. I've
already activated all the protocol : tcp/ip, named pipe ...
The target is to restore sql2000 database on sqlserver 2005.
thanks for your help.Hi,
Welcome to MSDE Managed NewsGroup. This is Justin from Microsoft.
It is supported to manage SQL2000 in SQL 2005 Management Studio. However,
if you only need to restore SQL2000 database to SQL2005, I recommend you
backup the SQL2000 database in the SQL2000 Enterprise Manager and copy the
backup file tot he SQL 2005 machine and then restore the backup file to
SQL2005.
I do not see much benefit to manage SQL2000 in Management Studio in this
case.
If you really need to register SQL2000 in Management Studio, please verify
that you can connect to the SQL 2000 from the 2005 machine.
1. Ping the 2000 server from the 2005 box and see if it succeeds
2. Telnet to the particular port and see if it works:
Telnet ServerName 1433
NOTE: Please run the Server Network Utility from the 2000 box to
determine the port SQL Server is listening. It might not be 1433 if it is a
named instance.
3. Create a UDL file to connect to the 2000 and see if it works.
- You can create a .txt file on the desktop, change its extension to
UDL and double-click it to launch the Data Link dialog box
If the step 1 & 2 do not work, you need to contact your network team and
see if there is any problem in the Network.
If you have any question, please feel free to let me know.
Thanks & Regards,
Justin Shen
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
--
| Thread-Topic: register sql2000 on SQL2005 manager
| thread-index: AcYmlKMdyn41f0o1QSWXgimqxWzbcg==| X-WBNR-Posting-Host: 82.228.221.13
| From: "=?Utf-8?B?UEJFTklTVFk=?=" <pbenisty@.newsgroups.nospam>
| Subject: register sql2000 on SQL2005 manager
| Date: Tue, 31 Jan 2006 10:32:06 -0800
| Lines: 11
| Message-ID: <4F8CEDBF-7DBF-4699-BADF-8D20D12B3A15@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:419556
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| I have two servers 2003, one running sqlserver 2005 and the second
sqlserver
| 2000.
| I'd like to register the sql2000 on the sqlserver management studio
provides
| with sql2005.
|
| when I trie to connect to server with sql2000 I get an time out error.
I've
| already activated all the protocol : tcp/ip, named pipe ...
|
| The target is to restore sql2000 database on sqlserver 2005.
|
| thanks for your help.
|
2000.
I'd like to register the sql2000 on the sqlserver management studio provides
with sql2005.
when I trie to connect to server with sql2000 I get an time out error. I've
already activated all the protocol : tcp/ip, named pipe ...
The target is to restore sql2000 database on sqlserver 2005.
thanks for your help.Hi,
Welcome to MSDE Managed NewsGroup. This is Justin from Microsoft.
It is supported to manage SQL2000 in SQL 2005 Management Studio. However,
if you only need to restore SQL2000 database to SQL2005, I recommend you
backup the SQL2000 database in the SQL2000 Enterprise Manager and copy the
backup file tot he SQL 2005 machine and then restore the backup file to
SQL2005.
I do not see much benefit to manage SQL2000 in Management Studio in this
case.
If you really need to register SQL2000 in Management Studio, please verify
that you can connect to the SQL 2000 from the 2005 machine.
1. Ping the 2000 server from the 2005 box and see if it succeeds
2. Telnet to the particular port and see if it works:
Telnet ServerName 1433
NOTE: Please run the Server Network Utility from the 2000 box to
determine the port SQL Server is listening. It might not be 1433 if it is a
named instance.
3. Create a UDL file to connect to the 2000 and see if it works.
- You can create a .txt file on the desktop, change its extension to
UDL and double-click it to launch the Data Link dialog box
If the step 1 & 2 do not work, you need to contact your network team and
see if there is any problem in the Network.
If you have any question, please feel free to let me know.
Thanks & Regards,
Justin Shen
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
--
| Thread-Topic: register sql2000 on SQL2005 manager
| thread-index: AcYmlKMdyn41f0o1QSWXgimqxWzbcg==| X-WBNR-Posting-Host: 82.228.221.13
| From: "=?Utf-8?B?UEJFTklTVFk=?=" <pbenisty@.newsgroups.nospam>
| Subject: register sql2000 on SQL2005 manager
| Date: Tue, 31 Jan 2006 10:32:06 -0800
| Lines: 11
| Message-ID: <4F8CEDBF-7DBF-4699-BADF-8D20D12B3A15@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:419556
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| I have two servers 2003, one running sqlserver 2005 and the second
sqlserver
| 2000.
| I'd like to register the sql2000 on the sqlserver management studio
provides
| with sql2005.
|
| when I trie to connect to server with sql2000 I get an time out error.
I've
| already activated all the protocol : tcp/ip, named pipe ...
|
| The target is to restore sql2000 database on sqlserver 2005.
|
| thanks for your help.
|
register sql2000 on SQL2005 manager
I have two servers 2003, one running sqlserver 2005 and the second sqlserver
2000.
I'd like to register the sql2000 on the sqlserver management studio provides
with sql2005.
when I trie to connect to server with sql2000 I get an time out error. I've
already activated all the protocol : tcp/ip, named pipe ...
The target is to restore sql2000 database on sqlserver 2005.
thanks for your help.
Hi,
Welcome to MSDE Managed NewsGroup. This is Justin from Microsoft.
It is supported to manage SQL2000 in SQL 2005 Management Studio. However,
if you only need to restore SQL2000 database to SQL2005, I recommend you
backup the SQL2000 database in the SQL2000 Enterprise Manager and copy the
backup file tot he SQL 2005 machine and then restore the backup file to
SQL2005.
I do not see much benefit to manage SQL2000 in Management Studio in this
case.
If you really need to register SQL2000 in Management Studio, please verify
that you can connect to the SQL 2000 from the 2005 machine.
1. Ping the 2000 server from the 2005 box and see if it succeeds
2. Telnet to the particular port and see if it works:
Telnet ServerName 1433
NOTE: Please run the Server Network Utility from the 2000 box to
determine the port SQL Server is listening. It might not be 1433 if it is a
named instance.
3. Create a UDL file to connect to the 2000 and see if it works.
- You can create a .txt file on the desktop, change its extension to
UDL and double-click it to launch the Data Link dialog box
If the step 1 & 2 do not work, you need to contact your network team and
see if there is any problem in the Network.
If you have any question, please feel free to let me know.
Thanks & Regards,
Justin Shen
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/tec...rview/40010469
Others: https://partner.microsoft.com/US/tec...pportoverview/
If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/default...national.aspx.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: register sql2000 on SQL2005 manager
| thread-index: AcYmlKMdyn41f0o1QSWXgimqxWzbcg==
| X-WBNR-Posting-Host: 82.228.221.13
| From: "=?Utf-8?B?UEJFTklTVFk=?=" <pbenisty@.newsgroups.nospam>
| Subject: register sql2000 on SQL2005 manager
| Date: Tue, 31 Jan 2006 10:32:06 -0800
| Lines: 11
| Message-ID: <4F8CEDBF-7DBF-4699-BADF-8D20D12B3A15@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSF TNGXA03.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:419556
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| I have two servers 2003, one running sqlserver 2005 and the second
sqlserver
| 2000.
| I'd like to register the sql2000 on the sqlserver management studio
provides
| with sql2005.
|
| when I trie to connect to server with sql2000 I get an time out error.
I've
| already activated all the protocol : tcp/ip, named pipe ...
|
| The target is to restore sql2000 database on sqlserver 2005.
|
| thanks for your help.
|
2000.
I'd like to register the sql2000 on the sqlserver management studio provides
with sql2005.
when I trie to connect to server with sql2000 I get an time out error. I've
already activated all the protocol : tcp/ip, named pipe ...
The target is to restore sql2000 database on sqlserver 2005.
thanks for your help.
Hi,
Welcome to MSDE Managed NewsGroup. This is Justin from Microsoft.
It is supported to manage SQL2000 in SQL 2005 Management Studio. However,
if you only need to restore SQL2000 database to SQL2005, I recommend you
backup the SQL2000 database in the SQL2000 Enterprise Manager and copy the
backup file tot he SQL 2005 machine and then restore the backup file to
SQL2005.
I do not see much benefit to manage SQL2000 in Management Studio in this
case.
If you really need to register SQL2000 in Management Studio, please verify
that you can connect to the SQL 2000 from the 2005 machine.
1. Ping the 2000 server from the 2005 box and see if it succeeds
2. Telnet to the particular port and see if it works:
Telnet ServerName 1433
NOTE: Please run the Server Network Utility from the 2000 box to
determine the port SQL Server is listening. It might not be 1433 if it is a
named instance.
3. Create a UDL file to connect to the 2000 and see if it works.
- You can create a .txt file on the desktop, change its extension to
UDL and double-click it to launch the Data Link dialog box
If the step 1 & 2 do not work, you need to contact your network team and
see if there is any problem in the Network.
If you have any question, please feel free to let me know.
Thanks & Regards,
Justin Shen
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/tec...rview/40010469
Others: https://partner.microsoft.com/US/tec...pportoverview/
If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/default...national.aspx.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: register sql2000 on SQL2005 manager
| thread-index: AcYmlKMdyn41f0o1QSWXgimqxWzbcg==
| X-WBNR-Posting-Host: 82.228.221.13
| From: "=?Utf-8?B?UEJFTklTVFk=?=" <pbenisty@.newsgroups.nospam>
| Subject: register sql2000 on SQL2005 manager
| Date: Tue, 31 Jan 2006 10:32:06 -0800
| Lines: 11
| Message-ID: <4F8CEDBF-7DBF-4699-BADF-8D20D12B3A15@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSF TNGXA03.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:419556
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| I have two servers 2003, one running sqlserver 2005 and the second
sqlserver
| 2000.
| I'd like to register the sql2000 on the sqlserver management studio
provides
| with sql2005.
|
| when I trie to connect to server with sql2000 I get an time out error.
I've
| already activated all the protocol : tcp/ip, named pipe ...
|
| The target is to restore sql2000 database on sqlserver 2005.
|
| thanks for your help.
|
register sql2000 on SQL2005 manager
I have two servers 2003, one running sqlserver 2005 and the second sqlserver
2000.
I'd like to register the sql2000 on the sqlserver management studio provides
with sql2005.
when I trie to connect to server with sql2000 I get an time out error. I've
already activated all the protocol : tcp/ip, named pipe ...
The target is to restore sql2000 database on sqlserver 2005.
thanks for your help.Hi,
Welcome to MSDE Managed NewsGroup. This is Justin from Microsoft.
It is supported to manage SQL2000 in SQL 2005 Management Studio. However,
if you only need to restore SQL2000 database to SQL2005, I recommend you
backup the SQL2000 database in the SQL2000 Enterprise Manager and copy the
backup file tot he SQL 2005 machine and then restore the backup file to
SQL2005.
I do not see much benefit to manage SQL2000 in Management Studio in this
case.
If you really need to register SQL2000 in Management Studio, please verify
that you can connect to the SQL 2000 from the 2005 machine.
1. Ping the 2000 server from the 2005 box and see if it succeeds
2. Telnet to the particular port and see if it works:
Telnet ServerName 1433
NOTE: Please run the Server Network Utility from the 2000 box to
determine the port SQL Server is listening. It might not be 1433 if it is a
named instance.
3. Create a UDL file to connect to the 2000 and see if it works.
- You can create a .txt file on the desktop, change its extension to
UDL and double-click it to launch the Data Link dialog box
If the step 1 & 2 do not work, you need to contact your network team and
see if there is any problem in the Network.
If you have any question, please feel free to let me know.
Thanks & Regards,
Justin Shen
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/te...erview/40010469
Others: https://partner.microsoft.com/US/te...upportoverview/
If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/defaul...rnational.aspx.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: register sql2000 on SQL2005 manager
| thread-index: AcYmlKMdyn41f0o1QSWXgimqxWzbcg==
| X-WBNR-Posting-Host: 82.228.221.13
| From: "examnotes" <pbenisty@.newsgroups.nospam>
| Subject: register sql2000 on SQL2005 manager
| Date: Tue, 31 Jan 2006 10:32:06 -0800
| Lines: 11
| Message-ID: <4F8CEDBF-7DBF-4699-BADF-8D20D12B3A15@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:419556
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| I have two servers 2003, one running sqlserver 2005 and the second
sqlserver
| 2000.
| I'd like to register the sql2000 on the sqlserver management studio
provides
| with sql2005.
|
| when I trie to connect to server with sql2000 I get an time out error.
I've
| already activated all the protocol : tcp/ip, named pipe ...
|
| The target is to restore sql2000 database on sqlserver 2005.
|
| thanks for your help.
|
2000.
I'd like to register the sql2000 on the sqlserver management studio provides
with sql2005.
when I trie to connect to server with sql2000 I get an time out error. I've
already activated all the protocol : tcp/ip, named pipe ...
The target is to restore sql2000 database on sqlserver 2005.
thanks for your help.Hi,
Welcome to MSDE Managed NewsGroup. This is Justin from Microsoft.
It is supported to manage SQL2000 in SQL 2005 Management Studio. However,
if you only need to restore SQL2000 database to SQL2005, I recommend you
backup the SQL2000 database in the SQL2000 Enterprise Manager and copy the
backup file tot he SQL 2005 machine and then restore the backup file to
SQL2005.
I do not see much benefit to manage SQL2000 in Management Studio in this
case.
If you really need to register SQL2000 in Management Studio, please verify
that you can connect to the SQL 2000 from the 2005 machine.
1. Ping the 2000 server from the 2005 box and see if it succeeds
2. Telnet to the particular port and see if it works:
Telnet ServerName 1433
NOTE: Please run the Server Network Utility from the 2000 box to
determine the port SQL Server is listening. It might not be 1433 if it is a
named instance.
3. Create a UDL file to connect to the 2000 and see if it works.
- You can create a .txt file on the desktop, change its extension to
UDL and double-click it to launch the Data Link dialog box
If the step 1 & 2 do not work, you need to contact your network team and
see if there is any problem in the Network.
If you have any question, please feel free to let me know.
Thanks & Regards,
Justin Shen
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/te...erview/40010469
Others: https://partner.microsoft.com/US/te...upportoverview/
If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/defaul...rnational.aspx.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: register sql2000 on SQL2005 manager
| thread-index: AcYmlKMdyn41f0o1QSWXgimqxWzbcg==
| X-WBNR-Posting-Host: 82.228.221.13
| From: "examnotes" <pbenisty@.newsgroups.nospam>
| Subject: register sql2000 on SQL2005 manager
| Date: Tue, 31 Jan 2006 10:32:06 -0800
| Lines: 11
| Message-ID: <4F8CEDBF-7DBF-4699-BADF-8D20D12B3A15@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:419556
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| I have two servers 2003, one running sqlserver 2005 and the second
sqlserver
| 2000.
| I'd like to register the sql2000 on the sqlserver management studio
provides
| with sql2005.
|
| when I trie to connect to server with sql2000 I get an time out error.
I've
| already activated all the protocol : tcp/ip, named pipe ...
|
| The target is to restore sql2000 database on sqlserver 2005.
|
| thanks for your help.
|
Subscribe to:
Posts (Atom)