how can I confirm msde sp3a upgrade information

I would need to know if the MSDE SP3a is aleady Upgraded.
I didn't search registy and Enterprise Manager(other PC)
Thank for your help
Hi,
Login to sql server using below command from command prompt:-
OSQL -sa -Ppassword -Sserver_name (enter)
1>select serverproperty('productlevel')
2>go
This will give you the service pack level of your sql server.
For older versions < SQL 2000, use the command
select @.@.version
It will give you the service pack number. with you can check the below link
to get the service pack details.
http://vyaskn.tripod.com/sqlsps.htm
Thanks
Hari
MCDBA
"peter" <anonymous@.discussions.microsoft.com> wrote in message
news:62a701c47528$ec661070$a301280a@.phx.gbl...
> I would need to know if the MSDE SP3a is aleady Upgraded.
> I didn't search registy and Enterprise Manager(other PC)
> Thank for your help
|||http://www.aspfaq.com/2160
http://www.aspfaq.com/
(Reverse address to reply.)
"peter" <anonymous@.discussions.microsoft.com> wrote in message
news:62a701c47528$ec661070$a301280a@.phx.gbl...
> I would need to know if the MSDE SP3a is aleady Upgraded.
> I didn't search registy and Enterprise Manager(other PC)
> Thank for your help

How can I be sure that MSDE is installed and running

How can I check to be sure that the MSDE is installed properly and that it is running?

Should I be able to see the Service Manger in the tray?

Thank you,Check it in task manager under the processes tab.

HOW CAN I ATTACH DATABASE TO MSDE ?

I am having little problem with it , I am using installshield for setup program and at the end when I finish with msde installation I try to attach a database, I would like to use SQL-DMO , but I dont have much clue how can I do it I need some examples sc
ripts
Thanks a lot
While you can use SQL DMO, it's really easier to simply use ADO or ADO.NET.
When you "open" a database connection against SQL Server and point to the
MDF file, ADO does an attach for you (unless the database is already
attached). This code is from a yet-to-be-published article on SQL Server
Express where I attach a new database to the local SQLEXPRESS named
instance.
Try
cn = New SqlConnection("Data Source=.\SQLExpress;" _
& "Integrated Security=True;Database=Biblio;" _
& "Timeout=60;" _
& "Application Name=SQLExpress Test;" _
& "AttachDBFilename=" & strFn)
da = New SqlDataAdapter("SELECT AU_ID, Author, Year_Born from
authors", cn)
ds = New DataSet
da.Fill(ds)
DataGridView1.DataSource = ds.Tables(0)
Catch ex As Exception
MsgBox(ex.ToString)
End Try
hth
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Robert" <Robert @.discussions.microsoft.com> wrote in message
news:1F642E5F-37AB-4BA7-88DF-5159C607AA0C@.microsoft.com...
> I am having little problem with it , I am using installshield for setup
program and at the end when I finish with msde installation I try to attach
a database, I would like to use SQL-DMO , but I dont have much clue how can
I do it I need some examples scripts
> Thanks a lot
>
|||Hello Robert.
U have said th@. u installed MSDE 2000 using installsheild. How did u do this. Pls help me as im unable to install MSDE itself. Also its givin me a message a strong SA id and password is required.
"Robert" wrote:

> I am having little problem with it , I am using installshield for setup program and at the end when I finish with msde installation I try to attach a database, I would like to use SQL-DMO , but I dont have much clue how can I do it I need some examples
scripts
> Thanks a lot
>

how can i attach access database to MSDE??

I have an mircosoft access database, but now i want to attach it to MSDE, how can i do impliment this??

i already try to use the following commands
exec sp_attach_db 'example','c:\example.mdb'

but i got the following error message
The header of this file 'c:\example.mdb' is not a valid database file header. The FILE SIZE property is incorrect.sp_attach_db is not what you need. You need to create a linked server. Seesp_addlinkedserver.

Terri|||thanks very much
i have use this command to add the access database as follow:
EXEC sp_addlinkedserver
@.server = 'example',
@.provider = 'Microsoft.Jet.OLEDB.4.0',
@.srvproduct = 'OLE DB Provider for Jet',
@.datasrc = 'C:\example.mdb'
GO

but the output is: 1 row affected
1 row affected
however in the sp_serverlinkedserver man page say it should return:server added

and i can not see example database after i performe the above command.|||i also have question
1.how can i access the database after sp_addlinkedserver
2.can i create stored procedures to this database which is sp_addlinkedserve(ed) access database|||Sorry, you've exhausted the extent of my knowledge on the subject. :-) I've only done this with Excel and other SQL Servers myself.

Terri|||that's all right
i just want to ask when you sp_addlinkedserver with Excel or other SQL server, where can you find you database(the one you just inported)?or how can you use you database|||

Dear friends,

I need some help. Here is what I am trying to do.

I have inserted and Excel object as an ActiveX control on my aspx page. When this page is opened, I do see the Excel control. - but blank.
What I would like to know, is how to specify an Excel file ( e.g MyFile.xls) that should appear in the control when the page is opened. I have tried with the properties available on the control, but with no luck.
Your help will be very helpful.
Thanks.
Mwan

sql