Can you please put your xml inside code tags with the ="xml" attribute? You can click the IFCode in the IFCode Shortcuts box to the left, the xml one...

Well, the error message is pretty self-explanatory. You have to have a Full database backup before you can run log backups. So either your backup chain has been...

JUst remember there is a reason it grew. You need to determine why. Are there regular log backups being done on this database? If not, you need...

Was Jeff referring to the Order By in the ROW_NUMBER() function?

A side note, I think a summary of the steps and results of this thread would make a great article...

This is a duplicate post. I have also placed a reply here

edit: fixed typo and changed answer to reply

Are you talking about a product hierarchy where you select a product from a list and the product type drop down is filtered on this value and the product name...

I believe you could mimic a tree view using a table with groups and have the data be collapsed (hidden) below the top group with a toggle on each group.

This returns the same results as your loop code:

/*

If tally table doesn't exist, create it with minimum rows needed

for this test

*/

SELECT TOP 260 IDENTITY(INT,...

My preference would be to remove the commas from the query that populates the list. This will be much easier than trying to parse out the commas.

This parses the...

Elliot is right normally you watch database size and available space and manually grow your files with autogrow as a backup. Since you are on 2005 you can query...

Grant Fritchey (7/13/2009)

---

You mean...

ahenderson (7/13/2009)

---

I need to capture counters in PerfMon or set up Profiler to capture statistics which will help me analyze performance issues when I change indexing on the database and...

I did just did a quick test and I did not see the behavior BOL states should happen. I think it will only do the DatabaseName matching if the...

According to BOL, what you heard about matching on database name is correct, but I have not experienced this personally. From BOL:

The database IDs on the target ideally should...

There are a couple of things listed in BOL that you should watch out for as well. Here's the article for master.