Viewing 15 posts - 16 through 30 (of 179 total)
SeqNo Used
1 60000000.00
2 190000000.00
3 250000000.00
4 50000000.00
Not sure...
I want to be the very best
Like no one ever was
April 21, 2022 at 10:37 am
Heres a some selection of columns u can query from DMVs that SQL Server offers.
SELECT DER.session_id
,DER.status
,txt.text
,DER.user_id
...
I want to be the very best
Like no one ever was
April 21, 2022 at 9:41 am
The only thing i am aware of is the "inofficial" dark theme which can be unlocked, but does not change object explorer.
For available options, the best thing to do in...
I want to be the very best
Like no one ever was
March 29, 2022 at 11:36 am
Unless Z is a local drive on the server, those are not UNC paths. You should avoid mapped drives when doing this.
I went to our infrastructure asking for the...
I want to be the very best
Like no one ever was
March 18, 2022 at 7:27 am
Try using the full UNC path, eg:
\\servername\c$\folder\filename
(after verifying that the user running the job can access that path)
.
i used tried the connection string including the full path of the...
I want to be the very best
Like no one ever was
March 15, 2022 at 1:31 pm
So you need to create a credential and then a proxy in the right proxy type, then you will be able to see this in the job drop down.
Thanks...
I want to be the very best
Like no one ever was
March 15, 2022 at 8:17 am
Ok i found the solution, apparently there is a setting/column "REPLY TO" in the sys tables.
Thanks to a query i found on stackoverflow, in the results of a sys table...
I want to be the very best
Like no one ever was
March 4, 2022 at 5:23 am
@ktflash - Just as a suggestion to help clarify exactly what you want for future posts.. It would be helpful if you'd post a clipping of a spreadsheet or...
I want to be the very best
Like no one ever was
January 28, 2022 at 5:20 am
SSMS shows you the matching parenthesis when your cursor is on the matching parenthesis. Some times it is hard to see it, so you can configure it to use...
I want to be the very best
Like no one ever was
December 2, 2021 at 5:12 am
is this what ur looking for?
SELECT COUNT (DISTINCT NAME)
FROM [dbo]
I want to be the very best
Like no one ever was
November 19, 2021 at 9:50 am
Did you forget to add the code your talking about by chance?
I want to be the very best
Like no one ever was
November 19, 2021 at 8:28 am
The "solution" is the following:
i had another talk with the user, we discussed the relevancy of the individual columns
I want to be the very best
Like no one ever was
November 18, 2021 at 7:16 am
Ok issue is member can only return a single element, instead one must use sets:
CREATE Set CURRENTCUBE.[Customer].[Customer ID].[Customers with Value > 1000] AS
filter(
...
I want to be the very best
Like no one ever was
November 17, 2021 at 9:36 am
Set logins default language to British English instead of English.
Or as you should be doing, use ISO formats for dates and always provide them in a YYYY-MM-DDTHH:mm:SS.MS format
Thanks but...
I want to be the very best
Like no one ever was
October 1, 2021 at 4:17 am
String Concat missing, ur trying to concat a string and an integer
DECLARE @frdate date = '01-01-2021'DECLARE
@ytdfrDate date
if Month(@frDate) < 4begin
SET @ytdfrDate = '01/04/' +...
I want to be the very best
Like no one ever was
August 17, 2021 at 9:02 am
Viewing 15 posts - 16 through 30 (of 179 total)