Forum Replies Created
Viewing 15 posts - 1,696 through 1,710 (of 13,460 total)
-
RE: I need to make a sql login also be a db user with the same name
Create LOGIN [ClarkKent] WITH PASSWORD='NotTheRealPassword'
USE [WHATEVER]
Create USER [ClarkKent] FOR LOGIN [ClarkKent]
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: scalar function returning zero when it shouldn't
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]')...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Finding the connection string for ChefTec software
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...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: scalar function returning zero when it shouldn't
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...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: SSRS - Report server cannot access the private key for the service account
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...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Seconds to AM/PM Time
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'...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: CONNECTIONPROPERTY('local_net_address') does not work in SQL Scheduled job.
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...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: CONNECTIONPROPERTY('local_net_address') does not work in SQL Scheduled job.
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...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Sql Server Core vs Full blown version of SQL Server
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...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Sql Server Core vs Full blown version of SQL Server
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...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: script to Find current date modify table list
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...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Connect to Report Server from client through Internet Browser
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...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Intermittent SQLException "Could not find stored procedure"
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...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Intermittent SQLException "Could not find stored procedure"
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...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Parsing large varbinary fields
ok, using pure string manipulation, can you ASSUME, the value you want is between a tab and the first left parenthesis?
someone will pretty this up with a cross apply, which...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Viewing 15 posts - 1,696 through 1,710 (of 13,460 total)