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...
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
...
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...
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...
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...
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...
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...
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...
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...
December 2, 2021 at 5:12 am
is this what ur looking for?
SELECT COUNT (DISTINCT NAME)
FROM [dbo]
November 19, 2021 at 9:50 am
Did you forget to add the code your talking about by chance?
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
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(
...
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...
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/' +...
August 17, 2021 at 9:02 am
Viewing 15 posts - 16 through 30 (of 179 total)