Take a look at the books that are free pdf download from RedGate http://www.red-gate.com/community/books/#sqldev

No offense, but I'm not going to do your work for you. That's what I get paid for 🙂 What have you tried and what is causing you issues? ...

Google PIVOT and UNPIVOT for SQL Server. Also, look at CROSS TABS for SQL Server.

It seems like the user in the old database had a default schema of DMUSER, but in the new (destination) the user has a default of dbo. Then, the...

Is this a production database? If not, I would create a new one with the proper file size and then move the data there. Else, you have to shrink...

I believe you are referring to SSIS. This is SQL Server Integration Services. You create a package using BIDS (Business Intelligence Development Studio) and then you can schedule...

Something like this. Don't summarize or group your sales in tables, store all the data in 1 table as granular as you need it to be and let your...

You need to change the schema of the table, which is not simply renaming the table.

First, have the default schema for your user changed in the user properties. Then,...

Ness (7/19/2012)

---

Try creating a SystemDSN entry on the machine you are trying to connect from AdminTools > ODBC DataSource Administrator > System DSN

This can be a good initial test of...

Ok, so to recap...

1. On your "desktop" you can open ssms and connect to server type "database engine" by typing in RemoteServerName and using SQL Server Authentication

2. You can...

When you log in from your client to the server with no issues, is it Windows or SQL authentication?

Ok, so you are on the actual server that is hosting SQL Server. and you are typing nothing in the server box to connect? Try typing localhost or simply...

tt-615680 (7/19/2012)

---

I don't know if I wasn't clear before but, the problem is only connection not if I typed the Server name in myself or if the Server which I...

Huh? You are connecting from a client to a server and you don't have to type anything in? That is the problem. You have to type in the server...

Well... I'm not completely sure about this in 2008, they may have changed it to a database context. I can't find that info right now though. To be...