Not enough information to be of much help. Please provide the DDL (CREATE TABLE statement(s)) for the table(s) involved, sample data as INSERT INTO statement(s) for the table(s) involved,...

New Born DBA (3/31/2014)

---

I did run into some problems and I am wondering if someone can tell me what to do.

I was unable to restore the DB because the DB...

kevin_nikolai (3/31/2014)

---

Hi Lynne, a special thanks - you're a star.

--------------------------------------------------------

I noted the changes you made relating ad_SequenceId with ( --- replaced with above ).

Found that replacing the...

If all you want are the tables and the data, sure.

Take the most recent full backup of the production database and restore it to the QA server. No impact on the production database.

I think one of the things being missed here with regard to the WIT group. It isn't just a group to support women who are in technology careers, but...

Based on the information provided, the "correct" answer is wrong. There is nothing in the question to tell us that the login has been granted sysadmin privileges on the...

GilaMonster (3/31/2014)

---

Msg 156, Level 15, State 1, Line 1

Incorrect syntax near the keyword 'ORDER'.

Amusingly enough, while updates and deletes can take...

If you are trying to connect to the instance using SSMS, the object explorer takes one connection to the server, preventing you from using a query window to run an...

Spork (3/29/2014)

---

...

I want to back up both tables in case I need to restore them the next day (only these tables would need to be backed up, not the complete...

calzakk (3/30/2014)

---

"As well as computer scientists, I know of several DBAs who were once professional musicians, actors, hairdressers, artists, scientists, athletes, soldiers and even solicitors and architects. They all make...

And now for something completely different (Please note I did have to put in a COLLATE clause to make the code work in my Sandbox database, so take it out...

Pet peeve, you didn't bother to fix the inconsistency between Lvl and lvl.

Here is your script for creating and populating your tables. Notice the changes I made to the script (besides the fact that there is no USE database statement).

/****** Object:...

I have an idea, since as I go through your code and finding things that just won't work, using the sample data you posted give us a set of tables...