Viewing 15 posts - 106 through 120 (of 248 total)
S, there are several things which are not clear:
July 17, 2019 at 9:33 am
current windows build :
exec xp_msver
see record "Windows version"
when the host was started
exec xp_cmdshell 'net statistics workstation | find "since"'
July 17, 2019 at 9:05 am
also, it's possible to trace Exceptions and User Errors returned to a client using Profiler
see below :
https://www.mytecbits.com/microsoft/sql-server/trace-errors-and-exceptions-using-profiler
July 16, 2019 at 10:04 am
Yeah good question. It must be part of some job than runs which I do not have visibility of yet.
it can be found out using default trace -...
July 15, 2019 at 1:49 pm
Not sure what to look for when comparing two plans.
let SSMS do it for you
https://blogs.msdn.microsoft.com/sql_server_team/comparison-tool-released-with-latest-ssms/
July 15, 2019 at 1:44 pm
I don't select, you don't select, but life is diverse and there are deviations. Let's see what the author will say.
This is nothing to do with...
July 15, 2019 at 1:37 pm
I saw many times when users used AD accounts without domain and passwords trying to connect to SQL server. So, it can be the similar case.
This...
July 15, 2019 at 1:25 pm
Please find the attached Screen shots
Those screenshots aren't Windows Authentication logins; they're SQL logins. If you're using SQL logins, who is running the application doesn't matter, as...
July 15, 2019 at 1:12 pm
Please find the attached Screen shots
On the pics attached usernames are different - ServiceAC vs SVCINFODEVEL.
Are there any logical links between them?
July 15, 2019 at 12:35 pm
I have did the same thing but while trying to connect SQL server its giving error
If you share the error text or error picture, it will be...
July 15, 2019 at 11:43 am
"is it possible to Access the SQL server from Different machine using same window Account."
It is possible if your applications run under the same AD account ("window Account") and use...
July 15, 2019 at 10:11 am
no plan attached
blocking (open trans) can cause the query run even longer
July 11, 2019 at 2:46 pm
You could also write the above as follows, which may be easier to read
with all due respect, such constructions are "easier to read" if you deal with or create...
July 11, 2019 at 2:43 pm
or such one:
with data as
(select '101,102,103,104,105,106,107' [SCHID])
select
left(SCHID,charindex(',',SCHID)-1) [Id]
,stuff(SCHID,1,charindex(',',SCHID),'') [AdditionalIds]
from data
July 11, 2019 at 2:40 pm
all you need is String Splitter
July 11, 2019 at 2:11 pm
Viewing 15 posts - 106 through 120 (of 248 total)