I would start with Exam 70-432: Microsoft SQL Server 2008, Implementation and Maintenance.

There are a lot of simulation questions on this Exam. If you do not have the experience look...

You may want to try the last post on the following thread:

http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/8b52557b-cd13-4db6-87b6-230b7e051a9e/

kickersdj (6/16/2011)

---

I can't figure out I create a sample of what I'm trying to do. Every time I try I just confuse myself more.

Table 1

ProjectMain_sales_Rep,Assoc1_SalesRep,Assoc2_SalesRep,Assoc3_SalesRep,Spend

Alpha_1,100001, ...

To expand on Steve's comment:

If your instance name is contained in a string variable, make sure you do either:

string server = "myServer\\myInstance"; or

string server = @"myServer\myInstance";

Exporting...

The following books by Itzik Ben-Gan are very good:

Inside Microsoft® SQL Server® 2008: T-SQL Programming

http://www.amazon.com/Inside-Microsoft%C2%AE-Server%C2%AE-2008-ebook/dp/B0043M52MC/ref=sr_1_1?s=books&ie=UTF8&qid=1308507910&sr=1-1/

Inside Microsoft® SQL Server® 2008: T-SQL Querying

http://www.amazon.com/Inside-Microsoft%C2%AE-Server%C2%AE-2008-ebook/dp/B0043EWUUW/ref=sr_1_2?s=books&ie=UTF8&qid=1308508011&sr=1-2

Under the other issues category Microsoft® SQL Server®...

Personally I would find out of the Database is in use and by who and go from there?

I usually check out Amazon.com first. Many books are not in Stock in the book stores.

You can read the reviews and if they have a Look inside you can look...

mike 57299 (6/18/2011)

---

There are 3 of developers here in my office. Two of them can restore a database (4GB compressed backup) in 20-25 min. I take over 2...

The following script can be used to detemine if a Database is currently in use.

USE Master

DECLARE @dbid INT

SELECT @dbid = dbid FROM sys.sysdatabases WHERE name = ”

IF EXISTS (SELECT spid...

In my opinion even if you do plan well...

Have you client on the link provided to install the client?

After installing...

What is the exact requirement for your homework assignment?

I would take a close look at it and assign the appropriate permissions wheter it be at the database or server level.

It is possible to have more than one person with the same name.

You can define UserName as a unique constraint but if more than one person has the same name...

I have to admit that I do not like the design.

Where are you getting your data from?

In your code you always want to INSERT into the Payment Item Table.

Then you...