No worries 🙂

I'm glad it worked out for you and you found it a positive experience overall.

Paul

For next time, http://sqlserver-qa.net/blogs/tools/archive/2007/04/23/use-import-export-wizard-with-sqlexpress-edition.aspx

Haven't looked into it myself, but I thought I'd post the link so you could choose whether to.

🙂

...COUNT(*) versus COUNT(1) is...

This is the MSDN/BOL link to explain all about LOB_DATA, IN_ROW_DATA and so on: http://msdn.microsoft.com/en-us/library/ms187501(SQL.90).aspx

The link that explains all about tables and indexes is: http://msdn.microsoft.com/en-us/library/ms180978(SQL.90).aspx

Start with the Table and Index...

If the problem relates to orphaned database users (where a login of the same name exists but the mapping is broken), you can fix this with ALTER USER

bpowers (9/11/2009)

---

Ok here is our game plane.

1.) Backup the log file

2.) Set Recovery to Simple

3.) Shrink the log

4.) Set Recovery back to FULL

5.) Run a full backup

6.) Remove the Shrink...

You could help us give you a better answer by providing table structure (a CREATE TABLE statement), some sample data as INSERT statements, and the exact output (in XML) that...

I'm assuming that the question you are asking is:

Is the ID column duplicated because it is in the clustered and non-clustered indexes?

The answer is interesting, and the full detail depends...

Krishna (9/12/2009)

---

Does it not roll forward all the...

I missed the hyphen on first glance and thought that the pork chops had...

Good to know it happens to you too :laugh:

I just posted something...

As Mark & 'kll' have mentioned, this also applies to views.

Using the star construction is well-established as poor practice (except after EXISTS or with COUNT) for exactly the sorts of...

john.arnott (9/11/2009)

---

SOM=Spewing On Monitor. Another invention of the...

That's very kind of you to...

danielmanke (9/11/2009)

---

I think we can agree. But as you can see from my query, we are starting at less then 50MB of Max free space, KB. So my only option...