Viewing 15 posts - 1,021 through 1,035 (of 1,192 total)
They're more or less what it says on the tin 🙂
Size is just the total size of the database files on disk.
Space available is the total free space within the...
June 5, 2015 at 4:34 pm
You can definitely sort the results in a combo box. In the Row Source property of the combo box, just add the appropriate ORDER BY clause to the query.
As others...
June 5, 2015 at 3:10 pm
Ok, thanks! A couple notes. The table name was the same for both batches of inserts, so I changed the second batch to billing. You're also attempting to explicitly insert...
June 4, 2015 at 4:30 pm
Thanks! The DDL gets us part of the way there.
Unfortunately that sample data won't illustrate the undesired results you're getting, or your desired results (there's just no overlap between those...
June 4, 2015 at 3:09 pm
To say much more about this we'd need some DDL for those tables and sample data[/url] that illustrates the problem you're having. We can't see your data and which rows...
June 4, 2015 at 2:40 pm
That subquery is not correlated in any way with the outer query. So long as there is at least 1 row in the Billing table where the year is 2015...
June 4, 2015 at 2:34 pm
No problem! I'm glad we were able to get to the bottom of it.
Cheers!
June 4, 2015 at 2:06 pm
No problem. I'm glad we could help!
June 4, 2015 at 1:03 pm
Ok, well, that's at least progress. We know it's not the target column in the database.
To continue systematically eliminating things, have we definitely confirmed that those are indeed the values...
June 4, 2015 at 12:53 pm
Ok, if the main point here is to get the most recent full backup times for databases (excluding tempdb), with NULL for databases that have not yet been backed up,...
June 4, 2015 at 9:27 am
I'm glad you seem to have found the issue!
There actually was a hint of that even in the article I cited, and I just overlooked it because of the focus...
June 4, 2015 at 9:01 am
In that case the inserts should all work, at least on the database side. To completely rule out the target column, are you able to successfully insert those values directly...
June 4, 2015 at 7:58 am
There are basically two ranges for float, one if the number of bits for the mantissa is set to a number between 1 and 24 inclusive (treated as 24), and...
June 3, 2015 at 7:19 pm
It doesn't show you a session ID because that section of information is about replication, not active transactions. The presence of that section just means that the current log contains...
June 3, 2015 at 4:56 pm
Interesting. A similar script behaves the same (truncated results) for me both when run from Powershell and from xp_cmdshell.
I'm not sure how you're intending to use it, so this might...
June 3, 2015 at 4:39 pm
Viewing 15 posts - 1,021 through 1,035 (of 1,192 total)