Microsoft Support for SQL Server 2000

Hello,
I would like to see if Microsoft has issued any announcement on SQL Server 2000 end of support. If anyone is aware of this or seen new posts/articles, please let me know.
Thank you!

MS official Lifecycle support for SQL 2000 is posted here: http://support.microsoft.com/lifecycle/?p1=2852

Thanks,

AWAL

Microsoft SSMSE - Printing database layout?

I'm connected to my remote SQL 2000 server using Microsofts SQL Server
Management Studio Express.
I can't see any way to print out my database table properties. Under
Database Diagrams all I have is "Working with SQL Server 2000 Diagrams",
which does not work.
How does one print out the layout of their database from this app?
Thanks!Noozer
Do you want to print a diagram by using SSMS of the SQL Server 2000
database?
"Noozer" <dont.spam@.me.here> wrote in message
news:%23S4naZ$ZGHA.4060@.TK2MSFTNGP02.phx.gbl...
> I'm connected to my remote SQL 2000 server using Microsofts SQL Server
> Management Studio Express.
> I can't see any way to print out my database table properties. Under
> Database Diagrams all I have is "Working with SQL Server 2000 Diagrams",
> which does not work.
> How does one print out the layout of their database from this app?
> Thanks!
>|||Diagrams would be great!
But, I'd settle for simply printing the properties from each of my tables.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23$oEp0CaGHA.4292@.TK2MSFTNGP02.phx.gbl...
> Noozer
> Do you want to print a diagram by using SSMS of the SQL Server 2000
> database?
>
>
> "Noozer" <dont.spam@.me.here> wrote in message
> news:%23S4naZ$ZGHA.4060@.TK2MSFTNGP02.phx.gbl...
>> I'm connected to my remote SQL 2000 server using Microsofts SQL Server
>> Management Studio Express.
>> I can't see any way to print out my database table properties. Under
>> Database Diagrams all I have is "Working with SQL Server 2000 Diagrams",
>> which does not work.
>> How does one print out the layout of their database from this app?
>> Thanks!
>|||Noozer
What properties? There is an option Script Table As , are you talking about
this feature?
"Noozer" <dont.spam@.me.here> wrote in message
news:%23EuOR6CaGHA.1192@.TK2MSFTNGP03.phx.gbl...
> Diagrams would be great!
> But, I'd settle for simply printing the properties from each of my tables.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%23$oEp0CaGHA.4292@.TK2MSFTNGP02.phx.gbl...
>> Noozer
>> Do you want to print a diagram by using SSMS of the SQL Server 2000
>> database?
>>
>>
>> "Noozer" <dont.spam@.me.here> wrote in message
>> news:%23S4naZ$ZGHA.4060@.TK2MSFTNGP02.phx.gbl...
>> I'm connected to my remote SQL 2000 server using Microsofts SQL Server
>> Management Studio Express.
>> I can't see any way to print out my database table properties. Under
>> Database Diagrams all I have is "Working with SQL Server 2000 Diagrams",
>> which does not work.
>> How does one print out the layout of their database from this app?
>> Thanks!
>>
>|||Why can't you go to File, Print...
or right-click the db diagram, "Copy Diagram to Clipboard," and paste/print
from Word?
"Noozer" <dont.spam@.me.here> wrote in message
news:%23EuOR6CaGHA.1192@.TK2MSFTNGP03.phx.gbl...
> Diagrams would be great!
> But, I'd settle for simply printing the properties from each of my tables.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%23$oEp0CaGHA.4292@.TK2MSFTNGP02.phx.gbl...
>> Noozer
>> Do you want to print a diagram by using SSMS of the SQL Server 2000
>> database?
>>
>>
>> "Noozer" <dont.spam@.me.here> wrote in message
>> news:%23S4naZ$ZGHA.4060@.TK2MSFTNGP02.phx.gbl...
>> I'm connected to my remote SQL 2000 server using Microsofts SQL Server
>> Management Studio Express.
>> I can't see any way to print out my database table properties. Under
>> Database Diagrams all I have is "Working with SQL Server 2000 Diagrams",
>> which does not work.
>> How does one print out the layout of their database from this app?
>> Thanks!
>>
>|||Because "Print..." is coming up disabled.
The server is a remote MS SQL 2000 server.
Diagrams does not work at all.
"JFoushee" <someone@.somewhere-donotspam.com> wrote in message
news:O$O9PTRbGHA.4116@.TK2MSFTNGP05.phx.gbl...
> Why can't you go to File, Print...
> or right-click the db diagram, "Copy Diagram to Clipboard," and
> paste/print from Word?
> "Noozer" <dont.spam@.me.here> wrote in message
> news:%23EuOR6CaGHA.1192@.TK2MSFTNGP03.phx.gbl...
>> Diagrams would be great!
>> But, I'd settle for simply printing the properties from each of my
>> tables.
>>
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:%23$oEp0CaGHA.4292@.TK2MSFTNGP02.phx.gbl...
>> Noozer
>> Do you want to print a diagram by using SSMS of the SQL Server 2000
>> database?
>>
>>
>> "Noozer" <dont.spam@.me.here> wrote in message
>> news:%23S4naZ$ZGHA.4060@.TK2MSFTNGP02.phx.gbl...
>> I'm connected to my remote SQL 2000 server using Microsofts SQL Server
>> Management Studio Express.
>> I can't see any way to print out my database table properties. Under
>> Database Diagrams all I have is "Working with SQL Server 2000
>> Diagrams", which does not work.
>> How does one print out the layout of their database from this app?
>> Thanks!
>>
>>
>

Microsoft SSMSE - Printing database layout?

I'm connected to my remote SQL 2000 server using Microsofts SQL Server
Management Studio Express.
I can't see any way to print out my database table properties. Under
Database Diagrams all I have is "Working with SQL Server 2000 Diagrams",
which does not work.
How does one print out the layout of their database from this app?
Thanks!Noozer
Do you want to print a diagram by using SSMS of the SQL Server 2000
database?
"Noozer" <dont.spam@.me.here> wrote in message
news:%23S4naZ$ZGHA.4060@.TK2MSFTNGP02.phx.gbl...
> I'm connected to my remote SQL 2000 server using Microsofts SQL Server
> Management Studio Express.
> I can't see any way to print out my database table properties. Under
> Database Diagrams all I have is "Working with SQL Server 2000 Diagrams",
> which does not work.
> How does one print out the layout of their database from this app?
> Thanks!
>|||Diagrams would be great!
But, I'd settle for simply printing the properties from each of my tables.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23$oEp0CaGHA.4292@.TK2MSFTNGP02.phx.gbl...
> Noozer
> Do you want to print a diagram by using SSMS of the SQL Server 2000
> database?
>
>
> "Noozer" <dont.spam@.me.here> wrote in message
> news:%23S4naZ$ZGHA.4060@.TK2MSFTNGP02.phx.gbl...
>|||Noozer
What properties? There is an option Script Table As , are you talking about
this feature?
"Noozer" <dont.spam@.me.here> wrote in message
news:%23EuOR6CaGHA.1192@.TK2MSFTNGP03.phx.gbl...
> Diagrams would be great!
> But, I'd settle for simply printing the properties from each of my tables.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%23$oEp0CaGHA.4292@.TK2MSFTNGP02.phx.gbl...
>|||Why can't you go to File, Print...
or right-click the db diagram, "Copy Diagram to Clipboard," and paste/print
from Word?
"Noozer" <dont.spam@.me.here> wrote in message
news:%23EuOR6CaGHA.1192@.TK2MSFTNGP03.phx.gbl...
> Diagrams would be great!
> But, I'd settle for simply printing the properties from each of my tables.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%23$oEp0CaGHA.4292@.TK2MSFTNGP02.phx.gbl...
>|||Because "Print..." is coming up disabled.
The server is a remote MS SQL 2000 server.
Diagrams does not work at all.
"JFoushee" <someone@.somewhere-donotspam.com> wrote in message
news:O$O9PTRbGHA.4116@.TK2MSFTNGP05.phx.gbl...
> Why can't you go to File, Print...
> or right-click the db diagram, "Copy Diagram to Clipboard," and
> paste/print from Word?
> "Noozer" <dont.spam@.me.here> wrote in message
> news:%23EuOR6CaGHA.1192@.TK2MSFTNGP03.phx.gbl...
>

Microsoft SQLXML Bulkload 4.0 Type Library with SQL Express

Hello,

I'm trying to follow a sample from microsoft for Using SQLXML Bulk Load in the .NET Environment

In the sample c# console app. it says to select add reference then In theCOM tab, selectMicrosoft SQLXML Bulkload 4.0 Type Library (xblkld4.dll) and clickOK.

The problem I have is I cannot find the library or the xblkd4.dll file on my pc.

Does anyone have any suggestions? Any help would be much appreicated.

Thanks

Karl

Hi,

From your description, it seems that you are unable to import the Microsoft SQLXML BulkLoad 4.0 type library, right?

Based on my understanding, XML Bulk Load is a standalone COM object that allows you to load semistructured XML data into Microsoft SQL Server tables. So before you are going to add the library, make sure that you have installed Microsoft SQL Server (i.e Microsoft SQLServer2005) product.

Thanks.

|||

I have the same problem. I have SQL Server 2005 with notification services installed locally and am using v2.0 of the frameworks and Team edition VS.Net 2005 SP1 and am working in C#. I have install SQLXML v4 and have located the dll next to the v3 dll which is listed as a COM object in the reference listing of COMs.

Any help on what steps to take to install so the library shows up in the COM listing would be appreciated.

Edwin

|||

I found a good article on this.

http://64.233.169.104/search?q=cache:jsAQOib9cFoJ:wijix.com/blogs/centricity/archive/2007/04/30/bulk-loading-xml-into-sql-server-2005-using-net.aspx+SQLXMLBulkLoad+Visual+studio+2005+reference&hl=en&ct=clnk&cd=2&gl=us

|||

The link was extremely helpful. Thanks.

Microsoft SqlServer Desktop Engine Connection Problem

i installed the MSDE2000A on server and i tried to connect from client machine through vb Application using connection string. Server anad client are in LAN. but Some systems able to connect and some systems are unable to connect.

i am getting the error:

"SqlServer does not exist or access denied "

for non connected machines.

the server is listening from these machines. but not connecting to MSDE.

can anyone give me solution what may be the cause.Ensure the System DSN used and login must have required privileges to connect to SQL server.

What is the authentication mode used?

Try:
1. Make sure the SQL server is on
2. Ping the server machine
3. Try connecting to the IP address rather than the server name

Review information from this KBA (http://support.microsoft.com/default.aspx?scid=kb;en-us;328306) for potential causes and resolve it.|||i am using user authentication mode.
i have set DISABLENETWORKPROTOCOLS=0
i have done pinging through IP Address.
i am able ping database.
after doing all these test .. still getting same error...

is there any other possibilities....

Originally posted by Satya
Ensure the System DSN used and login must have required privileges to connect to SQL server.

What is the authentication mode used?

Try:
1. Make sure the SQL server is on
2. Ping the server machine
3. Try connecting to the IP address rather than the server name

Review information from this KBA (http://support.microsoft.com/default.aspx?scid=kb;en-us;328306) for potential causes and resolve it.|||Review points listed in the knowledgebase article.

i am using user authentication mode.
SQL Server does have only 2 modes - Windows only or mixed. Which on e is yours?

i have set DISABLENETWORKPROTOCOLS=0
Don't know about this protocol in SQL, it should be named-pipes, TCP/ip or Multi-protocol. From Start--> programs --> goto MSSQLServer program group and select Server network utility and check for enabled protocols.
i am able ping database.
How can you do that in SQL?|||mine is MIXEDMODE.

this is obtained by setting parameter SECURITYMODE=SQL

i am sorry to tell u that i ping to database.

not database... it is server.

i am able to ping to server where i installed MSDE.

Originally posted by Satya
Review points listed in the knowledgebase article.

SQL Server does have only 2 modes - Windows only or mixed. Which on e is yours?

Don't know about this protocol in SQL, it should be named-pipes, TCP/ip or Multi-protocol. From Start--> programs --> goto MSSQLServer program group and select Server network utility and check for enabled protocols.

How can you do that in SQL?|||I'm probably being silly, but could you have installed SQL as a named server and tried to access it as a default (unnamed) server?

-PatP|||Check for any h/w issues on server installed by referring to event viewer log.

microsoft SQLServer CE

hi all..
just wondering that:
microsoft SQLServer = microsoft SQLServer CE?
how to use the microsoft SQLServer CE?
isiz the microsoft SQLServer CE can be used on the
microsoft SQLServer?
i really doubt abt this..hope someone can help me!!
thanks...CE is for embedded applications (for devices), and will have different features etc...

Microsoft SQL-DMO(ODBC SQLState:42000)

I am getting the following error message in SQL 2K when I try to give
database access to a login Id "LogInId1".
****************************************
*************
Microsoft SQL-DMO(ODBC SQLState:42000)
Error 15023: User or role 'LogInId1' already exists in the current database.
****************************************
************************************
*
The "public" role in the above "current database" has a user Id "LogInId1".
This is the one it is generating the above error message. I can not remove
the above user ID from that role (public).
What I did to generate the above error message?
I restored one user database on SQL 2K (running under windows 2003) from the
backup of SQL2K running under Win2K. The user Id "LogInId1" existed in the
database from which back was ran.
How to add database access permissions to the login Id ""LogInId1"?
Thank you,
SmithYou can try:
exec sp_changedbowner 'LogInId1'
"John Smith" wrote:

> I am getting the following error message in SQL 2K when I try to give
> database access to a login Id "LogInId1".
>
> ****************************************
*************
> Microsoft SQL-DMO(ODBC SQLState:42000)
> Error 15023: User or role 'LogInId1' already exists in the current databas
e.
> ****************************************
**********************************
**
> *
>
> The "public" role in the above "current database" has a user Id "LogInId1"
.
> This is the one it is generating the above error message. I can not remove
> the above user ID from that role (public).
>
> What I did to generate the above error message?
> I restored one user database on SQL 2K (running under windows 2003) from t
he
> backup of SQL2K running under Win2K. The user Id "LogInId1" existed in the
> database from which back was ran.
>
> How to add database access permissions to the login Id ""LogInId1"?
> Thank you,
> Smith
>
>
>|||Take a look at sp_resolve_logins in BOL, etc.
The internal (to the database) user tables have entries that are either not
in the Master SYSLOGINS table or have different pointers to that table. You
need to either repoint(resolve) or remove those logins.
--
Joseph R.P. Maloney, CSP,CCP,CDP
"Fahim" wrote:
[vbcol=seagreen]
> You can try:
> exec sp_changedbowner 'LogInId1'
>
> "John Smith" wrote:
>