Showing posts with label downloaded. Show all posts
Showing posts with label downloaded. Show all posts

Wednesday, March 28, 2012

How do I load SQL Samples?

Hello,

I am a total beginner to SQL and I'm unable to load the samples. I downloaded the .msi file and installed it but I don't know where to go from here.

Am I importing one of the samples in SQL or do I open them in Visual Basic?

The samples folder has several sub-folders with no executable so I don't know where to begin.

Can someone point me in the right direction?

thanks in advance.

Chris

Try this reference:

http://download.microsoft.com/download/d/8/6/d865cf0c-c44b-401b-b426-b3bf5c628112/GettingStartedWithSQLSamples.htm

|||

I read that reference and I'm still not sure how to load the samples. I don't know if I'm supposed to open them in VB or SQL and if so, which file?

I navigated to the "samples" folder on my local drive and there are eight folders "analysis services", "engine", "Integrated samples"......"Integration services", "notification services", "replication" and "reporting services.

Not really sure where to start.

Any and all help is appreciated.

Chris

|||

You need to read in Books Online (the SQL Reference) about using the ATTACH keyword.

How do I know if SQLXML 3.0 is installed

I downloaded and installed (at least I think I did), sqlxml 3.0
However when I go into Visual Basic.NET and try to add a reference, I dont
see in my list of COM objects, SQLXMLBULKLOADLib
HOWEVER, I can do a objBulkLoad =
CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad")
Can anybody HELP?
It should be in ARP (Add/Remove Programs). If you don't have it there,
download the latest v3, which is SQLXML 3.0 SP3.
Best regards
Niklas Engfelt
"MSSQLServerDeveloper" <MSSQLServerDeveloper@.discussions.microsoft.com>
wrote in message news:4135CD77-7669-43EF-901C-D65CE702CDB1@.microsoft.com...
>I downloaded and installed (at least I think I did), sqlxml 3.0
> However when I go into Visual Basic.NET and try to add a reference, I dont
> see in my list of COM objects, SQLXMLBULKLOADLib
> HOWEVER, I can do a objBulkLoad =
> CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad")
> Can anybody HELP?

How do I know if SQLXML 3.0 is installed

I downloaded and installed (at least I think I did), sqlxml 3.0
However when I go into Visual Basic.NET and try to add a reference, I dont
see in my list of COM objects, SQLXMLBULKLOADLib
HOWEVER, I can do a objBulkLoad =
CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad")
Can anybody HELP?It should be in ARP (Add/Remove Programs). If you don't have it there,
download the latest v3, which is SQLXML 3.0 SP3.
Best regards
Niklas Engfelt
"MSSQLServerDeveloper" <MSSQLServerDeveloper@.discussions.microsoft.com>
wrote in message news:4135CD77-7669-43EF-901C-D65CE702CDB1@.microsoft.com...
>I downloaded and installed (at least I think I did), sqlxml 3.0
> However when I go into Visual Basic.NET and try to add a reference, I dont
> see in my list of COM objects, SQLXMLBULKLOADLib
> HOWEVER, I can do a objBulkLoad =
> CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad")
> Can anybody HELP?