Forum Replies Created

Viewing 15 posts - 1,171 through 1,185 (of 13,460 total)

  • RE: Search for hyphen in database: it does not find the hyphen?

    there's at least two other longer than normal hyphens that has a different ascii code than the "normal hyphen ASCII('-')=45,without even going into nvarchar data sets.

    i'm betting it's one of...

    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!

    March 24, 2016 at 1:12 pm

    #1867586

  • RE: Access via domain\account OK BUT Access via domain\group DENIED

    ok, i'm going through the same issue as well, we have two domains with two way trusts.

    the network guys tell me it's not possible to change our existing group...

    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!

    March 24, 2016 at 11:45 am

    #1867552

  • RE: Seeking a way to correlate each missing index with SQL and Object Name (that will benefit from each index to be created).

    Jason Strates article lists missing indexes along with usecounts, costs, etc.

    i'd start there and enhance as needed.

    http://sqlmag.com/blog/missing-indexes-correlated-against-execution-costs-and-counts

    othercolumns ...include_columns usecounts Cost AggregateCost Impact

    ...

    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!

    March 23, 2016 at 8:12 am

    #1867090

  • RE: I deleted parameters and now get an error

    you have to edit the report, and remove the parameter in the report as well. the report is still happily sending the parameters as it last knew them, it doesn't...

    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!

    March 23, 2016 at 6:15 am

    #1867048

  • RE: How to allow non DBA user to run SQL backup

    yeah i think you need to use sp_executesql and pass the two out parameters to get the errors that Redgates SQL Backup will return;

    it will tell you the exact error...

    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!

    March 22, 2016 at 1:50 pm

    #1866936

  • RE: SSIS package works but fails when run as a SQL Server job.

    in that case, I'm thinking the issue is most likely that you've included a username and password in the connection, instead of letting the security be handled by the AD...

    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!

    March 22, 2016 at 6:06 am

    #1866726

  • RE: Error sending email in ssrs 2012 subscription on local machine

    sej2008 (3/21/2016)

    thank you,I will try out your solution given by you.but one question when I have configured smtp feature from server manager in my os that is windows server 2008...

    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!

    March 21, 2016 at 12:04 pm

    #1866578

  • RE: Login failed Error: 18456

    it's very easy to zip through the install clicking next next next, but forgetting to add AD login as an administrator on the SQL instance.

    you probably need to add yourself...

    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!

    March 21, 2016 at 9:48 am

    #1866513

  • RE: How to remove server names from drop-down list of servers?

    open the dropdown so it shows all your history of connections.mouse hover over an item so it is highlighted, but DO NOT mouseclick/SELECT it.

    while the dropdown is still open, and...

    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!

    March 21, 2016 at 9:42 am

    #1866512

  • RE: Trouble Deploying CLR functions

    I've also got some CLR's that i deploy to 2008R2 or 2012/2014 .

    like you, i've got multiple codebases, for R2,2012 or 2014.

    for the 2012/2014 stuff, I've also not been able...

    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!

    March 21, 2016 at 9:32 am

    #1866504

  • RE: How do I install AdventureWorks in my local PC

    mw112009 (3/21/2016)

    Lowell

    Please see attached

    when the script prompted you for the instance name, you did not type "MSSQLSERVER"

    it defaults to SQLExpress if you don't type anything.

    you don't have an extra isntance...

    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!

    March 21, 2016 at 8:41 am

    #1866479

  • RE: How do I install AdventureWorks in my local PC

    mw112009 (3/21/2016)

    Good Answer, Can you help me check whether I have SQL Server installed or not ?

    Where do I start this ?Suggestions Please

    because you got "login failed" you definitely have...

    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!

    March 21, 2016 at 7:29 am

    #1866444

  • RE: Query Performance Issue with multiple unions and a view

    I would redesign this slightly, but a few things that jumps out at me are:

    your query is hitting a view, which i try to avoid when possible. i prefer 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!

    March 21, 2016 at 7:21 am

    #1866440

  • RE: Understanding sys user / schema

    All sys objects are either views, or procs or functions. The views are based on the uneditable resource database.

    It is not possible to create your own obects in the sys...

    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!

    March 20, 2016 at 11:12 am

    #1866347

  • RE: Understanding sys user / schema

    szejiekoh (3/20/2016)

    SQLSlammer (3/17/2016)

    Hi,

    The answer to the second question is because the sys.databases is marked as a system object meaning it can be called from any database, so no matter 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!

    March 20, 2016 at 8:52 am

    #1866337

Viewing 15 posts - 1,171 through 1,185 (of 13,460 total)