Question about Business & Productivity Software

1 Answer

Where to get the complete microsoft sql tutorial?

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Corporal:

    An expert that hasĀ over 10 points.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 19 Answers

Search on MSDN--Library

Posted on Jan 08, 2009

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2 Answers

SQL 2008 R2 - MASTER.LDF corrupted without backup


Try this one solution...

1. First Shutdown SQL Server
2. Then move the current database file/rename (do not touch the .ldf)
3. After rename/move db, restart SQL Server
4. Create a new database with same name and log file and location also same
5. Stop SQL Server

Make use of some interesting links which might help you....
http://www.filerepairforum.com/forum/microsoft/microsoft-aa/sql-server/1465-table-in-sql-server-2008-is-corrupted - a lot of guides and tips for corrupted sql server databases
https://repairsql.recoverytoolbox.com/ Recovery Toolbox for SQL Server - free demo version of this tool, if any variant doesn't seem effective

Apr 26, 2015 | Microsoft SQL Server 2008 Enterprise Full...

2 Answers

How to fix mySQL corrupt databases?


you should follow two steps:

Create an appropriately named database on the target machine
Load the file using the mysql command:
$ mysql -u [uname] -p[pass] [db_to_restore] < [backupfile.sql]
Have a look how you can restore your tut_backup.sql file to the Tutorials database.
$ mysql -u root -p Tutorials < tut_backup.sql
To restore compressed backup files you can do the following:
gunzip < [backupfile.sql.gz] ' mysql -u [uname] -p[pass] [dbname]
If you need to restore a database that already exists, you'll need to use mysqlimport
command. The syntax for mysqlimport is as follows:
mysqlimport -u [uname] -p[pass] [dbname] [backupfile.sql]

Or make use of Repair Toolbox for MySQL

Demo version is here-: http://www.sql.repairtoolbox.com/

Feb 08, 2015 | Microsoft SQL Server 2000 Standard Edition...

5 Answers

How to recover deleted Microsoft SQL server MDF files?


Recover and repair MDF files with simple and efficetive tool to repair and recover MDF files from corrupt and damaged SQL server, which tool support all king of SQL server version and Windows OS. Visit here: http://www.en.mdfrepair.net
Read blog post: http://exchangerecovery.hubpages.com/hub/How-to-perform-SQL-Database-Recovery Corrupt MDF File Repair Utility

Apr 17, 2014 | Business & Productivity Software

1 Answer

Error installing MS Office pro 2007 with BCM


Uninstall from control panel the following:
Microsoft SQL Server native client
Microsoft SQL Server Setup Support files
Microsoft SQL Server VSS writer

Move directory C:\Program Files\Microsoft SQL Server\MSSQL.1 to another location for possible use. Delete everything under Microsoft SQL Server in c:\Program Files

Reinstall

Jan 10, 2010 | Microsoft Office Professional 2007 Full...

1 Answer

Sql server


It should install automatically when you insert the CD - double clikc cd-rom drive if it does not begin to load.

This might be a useful article - there was a bug - you may need to upgrade to SP2. http://www.microsoft.com/sql/prodinfo/previousversions/system-requirements.mspx

Note: If you are running a 64-bit version of a Microsoft Windows Server™ operating system, you need to use SQL Server 2000 Enterprise Edition (64-bit). Visit the SQL Server 2000 (64-bit) System Requirements page for additional information.

Apr 06, 2008 | Microsoft SQL Server 2000 Standard Edition...

5 Answers

SQL SERVER 2000


Perform following steps to recover sql server database:
  • Create a database with same size that you are trying to recover
  • Shutdown the SQL server
  • Swap old mdf file with new mdf file
  • Start the SQL server
  • Database may go in suspect
  • Set database in emergency mode
  • Run DBCC CHECKDB with repair_allow_data_loss to repair database


USE [master]
GO
ALTER DATABASE [RdmStoreInformation] SET EMERGENCY
GO
ALTER DATABASE [RdmStoreInformation] SET SINGLE_USER
GO
DBCC CHECKDB ([RdmStoreInformation], REPAIR_ALLOW_DATA_LOSS)
GO
ALTER DATABASE [RdmStoreInformation] SET MULTI_USER
GO
ALTER DATABASE [RdmStoreInformation] SET ONLINE


It may result some data loss. If you don't want to lose any single data then use 3rd party SQL repair software from Stellar Phoenix.

Mar 19, 2008 | Business & Productivity Software

1 Answer

Implementing the Datamining add-on


I haven't had any direct experience with data mining as of yet, but you can find some tutorials at: http://www.microsoft.com/sql/technologies/dm/addins.mspx There is also a webcast on demand that you can view at: http://www.microsoft.com/events/EventDetails.aspx?CMTYSvcSource=MSCOMMedia&Params=%7eCMTYDataSvcParams%5e%7earg+Name%3d%22ID%22+Value%3d%221032317016%22%2f%5e%7earg+Name%3d%22ProviderID%22+Value%3d%22A6B43178-497C-4225-BA42-DF595171F04C%22%2f%5e%7earg+Name%3d%22lang%22+Value%3d%22en%22%2f%5e%7earg+Name%3d%22cr%22+Value%3d%22US%22%2f%5e%7esParams%5e%7e%2fsParams%5e%7e%2fCMTYDataSvcParams%5e Hope this get you going...

Jul 03, 2007 | Microsoft Excel for PC

Not finding what you are looking for?
Business & Productivity Software Logo

Related Topics:

39 people viewed this question

Ask a Question

Usually answered in minutes!

Top Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18299 Answers

Tony

Level 3 Expert

2598 Answers

Are you a Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...