Yes, it is better to do the 20 joins in one query than to go back to the server 19 times for descriptions in each row.  Each of your dlookup...

This is what I think you are asking:  You have a table with a column storing a  code.  There is another table that lists all of the possible codes and...

What is the recovery model set to? 

Are you doing log backups which will remove committed transactions from the file? 

You can script log shipping using Standard Edition.  The reason that we are doing log shipping instead of replication in this scenario is that there are no primary keys defined on...

If you mean that you want the data replicated to the backup server, two of the most common ways are transactional replication and log shipping.

I wasn't able to do it in one query -- maybe someone else will figure that out.

Here is an example involving 2 steps:

create table stats (playerID int, teamID int)  --...

You can remap columns by clicking "Transform" but the import failed when I tried it because of the identify field.

Create a work table that has all of the fields...

This doesn't work if the inserts are not done in order:

INSERT INTO #Test Select '2B' as 'Column'

INSERT INTO #Test select '2A' as 'Column'

SELECT * FROM #Test ORDER BY CONVERT(...

I tried it on Pubs before posting the answer and it worked for me. 

So, today, I created a new database and made sure that the recovery model was set...

If there is anyway to avoid the use of cursors by using set statements, you will see a big gain in performance.  I recently converted the cursor type code to set statements in...

Try attaching the database in EM and it will create a new log file for you.

1. Right click "Databases"

2. Choose "All Tasks" -> "Attach Database"

3. Browse to your mdf file

4....

I know that your question is quite long, but I'm still not sure what you are asking.  I'm not sure if you are asking if objects should be owned by...

Try filtering on databaseID.  You can find it out with the sp_helpdb <database name> command, the dbid column.  That works better for me.

Kathi 

I completely misunderstood the question.  Sorry about that.

Kathi

alter table X drop column Y

Hope this helps,

Kathi