Viewing 15 posts - 4,711 through 4,725 (of 9,643 total)
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...
July 14, 2009 at 12:29 pm
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...
July 14, 2009 at 12:25 pm
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...
July 14, 2009 at 11:09 am
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...
July 14, 2009 at 9:38 am
This is a duplicate post. I have also placed a reply here
edit: fixed typo and changed answer to reply
July 14, 2009 at 9:12 am
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...
July 14, 2009 at 9:10 am
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.
July 14, 2009 at 9:09 am
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,...
July 14, 2009 at 9:06 am
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...
July 14, 2009 at 8:42 am
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...
July 14, 2009 at 7:54 am
Grant Fritchey (7/13/2009)
jcrawf02 (7/13/2009)
Paul White (7/13/2009)
GilaMonster (7/13/2009)
Done, apparently, because 'null' is faster than NULLBut only if you use little letters (less aerodynamic drag = faster!)
...then he should use cursive...
You mean...
July 13, 2009 at 7:01 pm
ahenderson (7/13/2009)
July 13, 2009 at 2:53 pm
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...
July 13, 2009 at 2:47 pm
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...
July 13, 2009 at 1:57 pm
There are a couple of things listed in BOL that you should watch out for as well. Here's the article for master.
July 13, 2009 at 1:42 pm
Viewing 15 posts - 4,711 through 4,725 (of 9,643 total)