How Do You Launch Tutorials?

May 8, 2007

I inherited a computer from a co-worker who left. On it she installed SQL Server 2005. The help system is chock full of references to the various and sundry tutorials that come with the product, but I can't find so much as a syllable about how one actually accesses those tutorials.

When I select Start, Programs, Microsoft SQL Server 2005, Documentation and Tutorials, Tutorials, SQL Server Tutorials, it simply launches one of the help screens. That screen, and the ones it contains links to, describe the tutorials topics in great detail, but nowhere is there any explanation of how you actually launch the tutorials.

What am missing here?

View 2 Replies

Advanced SQL Tutorials

Nov 29, 2005

Dear All,

Can you suggest a good book or set of websites which have advanced SQL tutorials for SQL server? Got the basics but looking to build on my knowledge.

...cause knowledge is power...

View 3 Replies View Related

Some Nobish Tutorials

Mar 13, 2006

hi there

Can someone post some very good tutorials about MS SQL 2005 working with c#??

please

Thanks guys..

View 6 Replies View Related

Sql 2005 Tutorials

Mar 20, 2008

Can someone tell me where I can find some SQL 2005 tutorials, e-learning or learnig tool for a kind of beginner. I want something where I can learn by doing. Some of the tutorials I have seen all pertain to .NET.

Thank you
Dee

View 6 Replies View Related

Online Books / Tutorials

Aug 2, 2002

Hi All...

Can anyone guide me to a place where I can download some Tutorials / Books (Not that new) covering Microsoft SQL 2000 essentials ? I tried to find here, but artices are too advanced for me.. I need something that covers the Basic and that could be used as a small reference/guide while I am learing...

Thanks to ALL

View 1 Replies View Related

SQL 2005 Reporting Tutorials

Mar 21, 2008

Could someone point me to some good SQL 2005 Reporting Tutorials? Types of Reporting? Reporting without using .NET?

Dee

View 3 Replies View Related

Installing SSIS Tutorials

Jun 30, 2006

I feel stupid for asking this but I can't seem to find where to install the SSIS tutorials referenced in msdn.. specifically the "Deploying Packages Tutorial". In the SQL Server 2005 Developer Edition DVD that I have, I've chosen to install all of the samples etc. I have the AdventureWorks and AdventureWorksDW and a whole bunch of samples in "C:Program FilesMicrosoft SQL Server90SamplesIntegration ServicesPackage Samples" but under the directory "C:Program FilesMicrosoft SQL Server90SamplesIntegration ServicesTutorial" I only have sample data for "Creating a Simple ETL Package".

I know... feels like a dumb question but I have run the install wizard on both the dev edition dvd and the msdn library dvd several times and looked at all the options and can't find anything about tutorials under the SQL server installation or the workstation component installation. Please help. Thanks.

View 4 Replies View Related

ADS Wizard, Tutorials And Examples - Please Help.

Oct 26, 2006

Hi,

I'm new to SQL Server Technology and am trying to learn how to create a Mobile Device application and to sync it with a desktop application that uses Access. I have found a lot of information but some of it doesn't seem to make sense.

I found this blog: http://blogs.msdn.com/sqlservereverywhere/archive/2006/08/29/729730.aspx which is the announcement of Access Database Synchronizer (ADS) CTP. I downloaded it and installed it with all the prerequisites. This is the part i can't understand:

"The CTP setup installs the desktop component required for synchronizing Microsoft Access database with SQL Server Everywhere Edition database on the device."

I cannot seem to find the desktop component to try out! The Readme shows you how to pull and push data but i can't see where the desktop data sync wizard is located. Should there be something installed on my desktop that i can see?

Also, there doesn't seem to be much help or examples around on this component as yet. Can anyone point me in the right direction for examples, help, or tutorials on this.

This paragraph also confuses me:

"Note: As of today only SQL Server Mobile Edition is available for devices. SQL Server Everywhere Edition whould be available for devices at time of SQL Server Everywhere Edition RTW whihc is planned for November 2006".

Does this mean SQL Everywhere won't work on mobile devices until November?

Sorry for all the questions but i'm still trying to learn this stuff so i can write my application for Windows CE. Thanks in advance.

View 8 Replies View Related

Service Broker Tutorials

Nov 16, 2005

Where can I find tutorials on Service Broker with C#?

View 1 Replies View Related

SQL Server 2005 Video Tutorials Please

Aug 14, 2007

Hiii everyone,

Can anyone send me the link of SQL Server 2005 Video tutorial please..
I am waiting for it.....

View 1 Replies View Related

New SQL Site For Code Library; Tutorials & FAQ.

Aug 20, 1999

Check out www.sql-server.co.uk.

This site offers a growing code library; tutorials & the full FAQ from Neil Pike SQL Server MVP in an easily readable search/review format.

Also a possible UK user group is being formed, initially information for this will be passed through this site - register there.

View 1 Replies View Related

MS SQL Server 2005 Newbie Tutorials Available?

Aug 29, 2006

I am trying to learn MS Sql Server and MS VB, ASP, .Net, etc., have installed SQL Server 2005 and Visual Studio 2005 on an XP Pro machine. I find fairly good MSDN help with VB & ASP stuff, but not with SQL Server. Can anyone recommend a good place to start, like online tutorials, or training, or even a good basic book that can show me how to create db�s, tables, load data, basic stuff like that?

View 3 Replies View Related

SQL Express - Guides/tutorials/intros

Apr 18, 2006

Hi - can anyone recommend tutorials/guides for beginners? The Microsoft documentation seems very poor to me especially in comparison to Oracle Express. I am really struggling to find a good intro/tutorial.
Many thanks
db

View 1 Replies View Related

Anyone Direct Me To Good JOIN Tutorials..

Oct 8, 2007

ok i need to know the difference between inner outer , left , right joins ....

anyone know any good tutorials ?

View 3 Replies View Related

SQL Server Mobile Editon Tutorials

Sep 12, 2005

I installed SQL Server 2005 and want to practice the "Creating a Mobile Application with SQL Server Mobile" in SQL Server Mobile Editon Tutorials,but I can't find the file sqlmobile.sql listed in "C:" according to tutorial document.

View 3 Replies View Related

Can't Install Sample Databases Plus No Documents Or Tutorials

May 17, 2006

I have downloaded and run all the .msi's for the sample databases. To install them I am suppose to use "SQL Server 2005 Setup, you need to click the Advanced button....". I don't seem to have a "SQL Server 2005 Setup" - did the docs revert back to SQL Server rather than SQL Express or what ???

R

View 5 Replies View Related

Where To Get More In-dept Tutorials For The Data Mining Add-In For Excel?

Jun 13, 2007

Does anyone know where we can get more in-dept tutorials for the Data Mining Add-Ins for Excel? Currently, all we have are the videos from the microsoft web site as well as some white papers.

View 1 Replies View Related

Database Filename Error -- Cannot Create Db From MS Online Tutorials

Apr 20, 2006

I am using VB with Visual Studio Express. I am new to these tools. I have SQL Server 2005 Express installed on my machine. I think that I have the right version. I am just using Express for taking classes and teaching myself on my machine.
When I follow the examples in the book, I keep getting this error when I go to my ASP.NET configuration and click on the security tab to add myself as a user.
"There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store. The following message may help in diagnosing the problem: The database filename can not contain the following 3 characters: [ (open square brace), ] (close square brace) and ' (single quote) " -- end of erro msg.
I have an apostrophe in my last name. Could that be what is causing it? Is it creating a db based on my name or something? Or do I have the wrong version of SQL Server Express installed.
Thank you for any help. I appreciate it.

--Mark

View 1 Replies View Related

SSIS Tutorials: Lesson 1 - Missing Customers.xls File

Nov 28, 2006

I can not seem to locate this file any where on my computer let alone in the specified directory. With out this file, it would be very difficult if not impossible to go through rest of the SSIS tutorials. Could I ftp this file from some locations so I could get started on the tutorials.

I would very much appreciate any help.

Thanks

View 2 Replies View Related

How To Launch Them??

Nov 7, 2006

Hi everyone,

Primary platform is Framework 2.0

Our vb application throws .dtsx by means of the usual methods.

When I want to run packages allocated in my Windows folder I use LoadPackage; when I want to run packages allocated in my MSDB I use LoadFromSqlServer and at the end of the day when
I want to run packages allocated in my File System SSIS folder I use LoadFromDtsServer.

Drawbacks come here according a "new sort of SSIS packages". I'm talking about those packages which are imported from Sql2k from
Database Engine->Management->Legacy->Data Transformation Services.

How do I launch this kind of SSIS packages??

I'm totally stuck with this. Or maybe the problem is easier: the ones aren't ssis but dts????????????????

Thanks in advance for your input,

View 3 Replies View Related

Using Asp.net To Launch A DTS Package

Aug 18, 2006

does anyone know an easy way (or any way for that matter) to run a DTS package from an asp.net page?

View 1 Replies View Related

Launch A Package From VBA...

Mar 13, 2006

Hi all,

I'm trying to launch a SIS package from a VBA macro in excel...now I launch the dtexec.exe from a shell but a have this error:

Started: 10.14.33
Could not load package "Package1" because of error 0xC0014062.
Description: The LoadFromSQLServer method has encountered OLE DB error code 0x80004005 (Login timeout expired). The SQL statement that was issued has failed.
Source:
Started: 10.14.33
Finished: 10.14.49
Elapsed: 16.594 seconds

but all credential are correct...

any ideas ???

thanks in advance

Wolly

View 3 Replies View Related

Can't Launch ReportBuilder

Feb 20, 2008

I was the happy admin of some reportservers (build 3175) until someone asked me to get the ReportBuilder to work. I've read through the documentation and configured the SSRS site security so that the icon is visible. However when I click on it nothing happens. If I try to launch it by right clicking and then save as -- open I receive the following error:

- Downloading file:///C:/UserTemp/_temp/ReportBuilder.exe.manifest did not succeed.
- Source: System.Deployment
- Stack trace:
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
at System.Deployment.Application.SystemNetDownloader.DownloadAllFiles()
at System.Deployment.Application.FileDownloader.Download(SubscriptionState subState)
at System.Deployment.Application.DownloadManager.DownloadManifestAsRawFile(Uri& sourceUri, String targetPath, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadApplicationManifest(AssemblyManifest deploymentManifest, String targetDir, Uri deploymentUri, IDownloadNotification notification, DownloadOptions options, Uri& appSourceUri, String& appManifestPath)
at System.Deployment.Application.ApplicationActivator.DownloadApplication(SubscriptionState subState, ActivationDescription actDesc, Int64 transactionId, TempDirectory& downloadTemp)
at System.Deployment.Application.ApplicationActivator.InstallApplication(SubscriptionState subState, ActivationDescription actDesc)
at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut)
at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)
--- Inner Exception ---
System.Net.WebException
- Could not find file 'C:UserTemp\_tempReportBuilder.exe.manifest'.
- Source: System
- Stack trace:
at System.Net.FileWebRequest.EndGetResponse(IAsyncResult asyncResult)
at System.Net.FileWebRequest.GetResponse()
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
--- Inner Exception ---
System.Net.WebException
- Could not find file 'C:UserTemp\_tempReportBuilder.exe.manifest'.
- Source: System
- Stack trace:
at System.Net.FileWebResponse..ctor(FileWebRequest request, Uri uri, FileAccess access, Boolean asyncHint)
at System.Net.FileWebRequest.WrappedGetResponseCallback(Object state)
--- Inner Exception ---
System.IO.FileNotFoundException
- Could not find file 'C:UserTemp\_tempReportBuilder.exe.manifest'.
- Source: mscorlib
- Stack trace:
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, Boolean useAsync)
at System.Net.FileWebStream..ctor(FileWebRequest request, String path, FileMode mode, FileAccess access, FileShare sharing, Int32 length, Boolean async)
at System.Net.FileWebResponse..ctor(FileWebRequest request, Uri uri, FileAccess access, Boolean asyncHint)
COMPONENT STORE TRANSACTION DETAILS
No transaction information is available.

Here are the things I have checked/tried:

Ensured the .NET Framework Reliant components are enabled in the browser

Running the browser with a user account that is local admin on the workstation

MIME settings on IIS server look ok

I am not seeing any access denieds on my workstation (checked with file and regmon)

I am not seeing any failures in the security event log

For the test that I am doing, both the user account, workstation and server are in the same domain

Don't see any errors in the SSRS logs
Can anyone think of anything else that would lead me to resolving this problem?

Thanks

View 3 Replies View Related

How To Launch An Oracle SP From SQL Trigger?

Aug 16, 2006

I need to know a few things about this..
1. What do I need running or available on SQL Server machine (presuming an Oracle client)
2. Has anyone done this and perhaps can give me some quidance?
3. Any concerns about going from outside a firewall to the Oracle instance?

Architecture is probably going look like this:

SQL -> ON INSERT Trigger -> business logic -> Call Oracle Procedure

Any help is appreciated, thanks!

JTGIS

View 3 Replies View Related

Create A SP That Will Launch A DTS Package

Oct 10, 2006

Hi all. How can I create a Stored Procedure that will launch a DTS package that I have already built dynamically ?

I have a string already built and I need to put it in a SP because my application is php (linux) and the database is SQL Server on a Windows machine.

I will use php to execute the stored proc, which is the only way to access it.

My string looks like this :
C:Progra~1Micros~380ToolsBinnISQL.EXE -S [MyServer] -U [Username] -P [Password] -Q "ISQL_Batch 'D:DDFIImporteIMPICAFI.bat [user] [Schema] [Pwd] '" -n -d [database]

(Words in [] are only to show that I will put other values)

Thanks

CFGilles

View 2 Replies View Related

When Did Microsoft Launch SQL Server ?

Dec 13, 2006

Hi Folks,

My understanding is that Microsoft acquired the rights to use and re-badge Sybase as SQL Server and since then have engaged in a substantial re-write as part of their commitment to it.

Is this correct and can anyone give me some dates ?

Thanks very much

B.Dimple
Senior DBA

View 8 Replies View Related

Quick Launch 2005 On PC

Jul 25, 2007

Poor me :o I have to share a home PC now so cannot have things my own way. When using my own PC I had SQL Server 2005 dev edition run on start up. Now I am sharing it seems rather churlish to not have it start on demand.With 2000 you got a little icon in the taskbar that indicated the status of SQL Server and a quick right click -> start was all you needed to get the little fella up and running. With 2005 you need to go all the way to configuration manager and start it. I have four options:#1 - a few mouse clicks to start SQL Server via configuration manager (unacceptable - imagine all the wasted time and RSI!)#2 - bat file to start SQL Server (ok)#3 - more sophisticated little app that shows the status of SQL Server in the taskbar and allows me to start it (nice but a pain to put together)#4 - something much spiffier which one of you gurus can let me in on I am sat on the edge of my little seat in anticipation :)

View 1 Replies View Related

DTS Launch From SQL Server Agent

Mar 18, 2004

Hi,

I want to build a task that does 3 things automatically at a fixed time interval:

1) Refresh the data (copy newly inserted data from a datamart to a datawarehouse)
2) Run a program (exe) to produce some external reports
3) Refresh an OLAP Cube with the new data so that users can access it

Basically, using SQL Server Agent, setting up steps 1 and 2 was pretty straightforward (for step 1, the main point of entry is a single sp).

I ran into some trouble figuring the easiest way to complete step 3. I created a DTS package with one object that updates the Cude on my server. This seems to be working fine. Then, I created step 3 in Agent and chose 'CmdExec' as the type of command. I then referenced the external exe 'dtsrun' to execute my DTS package.

Everything seems fine but I'm not sure I used the "best" way of doing things. Since the SQL Server Agent and DTS manager are both SQL Server tools (so is the Analysis services), I'm wondering if there wasn't an easier (thus more robust) way of completing my 3rd step?

Anyone? How is this done where you've worked?

Thanks,

Skip.

View 2 Replies View Related

Launch Storedquery For Each Record

Nov 21, 2007

hiI have a scenario where I have created a stored procedure wich task isto search in my database with certain criterias. For each record fromthis search, I want to run a couple of other stored procedure.Here is some code:decare $myid nvarchar(15)select id, desc, customer from project where customer = 'cust1'--------------------------------------------HERE IS CODE MISSING----------------------------------------------for each of the records returned, I want to run 4 stored procedureswith the id as parameter.beginexecute StoredProcedure1 $myidexecute StoredProcedure2 $myidexecute StoredProcedure3 $myidexecute StoredProcedure4 $myidendThe problem is I don't know how to get hold of the result set and loopthrough. Maybe you can help me.regardsRoger

View 6 Replies View Related

Report Builder Will Not Launch

Nov 10, 2006

I am having problems launching the Report Builder. I click the button and nothing happens. I did see the other suggestions about re-installing the .NET 2.0 Framework but that did not help. I tried to launch it directly from the address bar and I am getting the same reponse as when I click on the Report Builder button. I can access the Report Builder from other machines and it works fine. I did just recently install IE 7 and I tried to uninstall it and go back to IE 6 but I got the same results.

Any help would be appreciated.

Thanks Tim

View 8 Replies View Related

Launch Instance Only When Is Required

Aug 7, 2015

I've SQL instance used for Telecom Software, that SQL instance kept to run automatically consume 2 GB RAM and slow my machine..How could I configure it to lunch only when I open my Telecom Software and to close when I exit it.

View 9 Replies View Related

Failed To Launch 'osql'

Sep 13, 2006

I use one-way Transactional Replication on 38 servers with same configuration.
On one server I have problem with OSQL.EXE path.

On
Publication properties ->
snapshot ->
Additional scripts ->
Before applying the snapshot, execute this script:
Is set preinit script (C:ReplDataReplPreInit.sql).

On Distribution agent properties -> step "Run Agent"
I set additional command for log problem.
command= -Output C:ReplOutFile.txt -Outputverboselevel 2

Here is part of ReplOutFile.txt:
--------------------------------
The osql command is: "C:Program FilesMicrosoft SQL Server80ToolBinnosql.exe" -U"***" -P"***" -i "\STROSBBReplDatauncSTROSBB_antikor_DataCDB20060908104051ReplPreInit_0.sql" -S "BTSVR" -d "AntikorCDB" -o "C:WINNTTEMPReplPreInit_0.sql_20060912150416.log" -b -X1
Launching osql to apply the script 'ReplPreInit_0.sql'
[9/12/2006 3:04:16 PM]STROSBB.distributionAntikor: {call sp_MSadd_distribution_history(1, 3, ?, ?, 0, 0, 0.00, 0x00, 1, ?, 0, 0x01, 0x00)}
Agent message code 20130. Failed to launch 'osql'
[9/12/2006 3:04:16 PM]STROSBB.distributionAntikor: {call sp_MSadd_distribution_history(1, 6, ?, ?, 0, 0, 0.00, 0x01, 1, ?, 4, 0x01, 0x01)}
Adding alert to msdb..sysreplicationalerts: ErrorId = 1233,
Transaction Seqno = 00000491000618f4007000000001, Command ID = 4
Message: Replication-Replication Distribution Subsystem: agent STROSBB-antikor-BTSVR-1 failed. Failed to launch 'osql'[9/12/2006 3:04:16 PM]STROSBB.distributionAntikor: {call sp_MSadd_repl_alert(3, 1, 1233, 14151, ?, 4, N'STROSBB', N'antikor', N'BTSVR', N'AntikorCDB', ?)}
ErrorId = 1233, SourceTypeId = 3
ErrorCode = '3'
ErrorText = 'The system cannot find the path specified.
--------------------------------

Problem is that the path to osql command in log ReplOutFile.txt is
C:Program FilesMicrosoft SQL Server80ToolBinn
but SQL is installed on path
C:Program FilesMicrosoft SQL Server80ToolsBinn

Diferences is between Tool vs. Tools

I think that when server create OSQL command for preinit sql script he use STATIC path to osql.exe and there is my problem.

Where is this path stored and can I change it?

View 4 Replies View Related

Launch DTS With OLAP From .net Application

Sep 19, 2006

Hi,

with reference to the following thread:

http://forums.microsoft.com/msdn/ShowPost.aspx?postid=740855&isthread=false&siteid=1&authhash=775a583435c503730bf96695fe78ffc77f04a290&ticks=632942355374528292

Which in summary is that I am trying to execute DTS packages containing OLAP tasks to process cubes from an application. It hangs and fails after an hour and some minutes.

the code :

Package2Class package = new Package2Class();

object pVarPersistStgOfHost = null;

package.LoadFromSQLServer(serverName,null,null,DTSSQLServerStorageFlags.DTSSQLStgFlag_UseTrustedConnection,null,null,null,packageName,ref VarPersistStgOfHost);

package.Execute();

I have launched the DTS on command prompt using DTSRUN on the computer I am trying to execute my code, and it executes marvellously.

DTSRUN can also execute a DTS on another physical server Alpha for instance which process a cube of AS2000 found on another physical server Beta for instance.

Since I need to check that each steps have been executed properly and that running DTSRUN from the application is not a possibility to do so, I need a way to be able to launch the DTS and get to know which steps is failing. the above code is supposingly a way but its failing on LoadFromSQLServer() method.

I am using SQL Server 2000 and AS2000 and .net 1.1 (modifying a legacy system to enable the above facility).

Any views please?

Thanks

View 6 Replies View Related