Viewing 15 posts - 1,696 through 1,710 (of 13,469 total)
jpserra3 (6/15/2015)
June 16, 2015 at 12:09 pm
Create LOGIN [ClarkKent] WITH PASSWORD='NotTheRealPassword'
USE [WHATEVER]
Create USER [ClarkKent] FOR LOGIN [ClarkKent]
June 16, 2015 at 11:54 am
well here's a fully tested prototype that returns two for the value
any issues you have woudl be details...the data doesn't exist, usin the wrong data types, wrong column, etc.
IF OBJECT_ID('[dbo].[member_score]')...
June 16, 2015 at 11:05 am
my quick Google-Fu tells me it's a local instance on the installed server; all i need to do is login locally to that machine and start my investigation.
from there, i'd...
June 16, 2015 at 10:55 am
you don't put quotes around the parameter; it's already the right datatype.
your real function probably raises an error, sicne you have two variables:@tbl and @source_tbl, but only one is...
June 16, 2015 at 10:25 am
I've seen this if you copied an existing ReportServer and ReportServerTemp db from one instance and restored them on another, ie copying a backup from Production To Test OR QA.
If...
June 16, 2015 at 5:36 am
there's 86400 seconds in the day.
anything prior to exactly half that, (12:00:00) , or 43200 seconds, is AM, else PM
so a CASE WHEN seconds <43200 THEN 'AM' ELSE 'PM'...
June 15, 2015 at 11:56 am
there's multiple ways to connect ot SQL; you can see that whenever you look at the SQL configuration manager.

as i understand it, shared memory is always loca, since it's local...
June 15, 2015 at 10:13 am
wouldn't NULL be normal if the connection was over named pipes, and not TCP/IP?
i'd think that that is probably what you are seeing.
can you check within your script?
SELECT net_transport
FROM...
June 15, 2015 at 7:18 am
Welsh Corgi (6/12/2015)
I misunderstood. :blush:So you can install SSMS on the Server?
No.
the point is there is no need to have SSMS on the server.
you already have it local, installed...
June 12, 2015 at 10:21 am
sqlcmd.exe only? you should know better.
you can use your local SSMS GUI to connect to any version of SQL, including a remote SQL Server Core instance.
SSMS doesn't care if the...
June 12, 2015 at 10:11 am
you can kind of infer the last tiem a table was updated from the index stats, but you cannot tell what was updated, or by who.
to have that, you need...
June 11, 2015 at 2:30 pm
yes, it's a firewall issue.
the firewall needs to be told that public traffic from an external ip , that is targeted to port 80, needs to go to your internal...
June 11, 2015 at 11:07 am
i think the case you have, where it's a high volume of calls to a specific proc, and it's intermittent, relaly makes me think connection pooling is the culprit, so...
June 11, 2015 at 7:49 am
the easiest fix is a simple change in the application call, so that it explicitly uses DatabaseName.SchemaName.ObjectName.
that resolves any possibilities of ambiguity where the query engine tries it's best to...
June 11, 2015 at 7:34 am
Viewing 15 posts - 1,696 through 1,710 (of 13,469 total)