Forum Replies Created

Viewing 15 posts - 5,221 through 5,235 (of 13,460 total)

  • RE: EXECUTE AS Problem

    I would test the linked server as that user to see if the problem is in the credentials:

    EXECUTE AS USER='mydomain\lowell'

    --who am i?

    select user_name()

    ,suser_name()

    --do stuff

    SELECT TOP 1 * FROM myLinkedServer.DatabaseName.dbo.TableName

    --change back...

    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!

    July 10, 2012 at 9:11 am

    #1511014

  • RE: EXECUTE AS Problem

    just checking the basics here:

    MyLogin is actually a user in the database, right? you know it cannot be a login, but must be a user, right?

    --the EXECUTE AS must be...

    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!

    July 10, 2012 at 8:42 am

    #1510984

  • RE: Searching Database for spesific column in all tables

    sp_find

    this home made procedure is probably my most used proc on my dev server!

    too many times i think to myself "i know there are columns or tables that 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!

    July 10, 2012 at 8:35 am

    #1510971

  • RE: How to Send mail from Sql mail to mobile ?

    Are you talking about sending an SMS to a phone (Shor tMessage Service)

    or talking bout sending an email in general, where a smart phone picks up mail like a normail...

    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!

    July 10, 2012 at 8:25 am

    #1510959

  • RE: OPENROWSET issue with 64bit vs 32bit

    Joe-420121 (7/10/2012)

    lowell,

    I get err msg respectively:

    -----------------------------------------------

    OLE DB provider "MSDASQL" for linked server "(null)" returned message "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified".

    Msg 7303, Level...

    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!

    July 10, 2012 at 7:50 am

    #1510925

  • RE: OPENROWSET issue with 64bit vs 32bit

    try openrowset like this, using the aCe driver;

    this is a tested working example for me:

    SELECT * FROM OPENROWSET('MSDASQL',

    ...

    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!

    July 10, 2012 at 7:34 am

    #1510910

  • RE: Help with SQL query please

    sjerromeharris (7/10/2012)

    Thanks - v helpful.

    If I want to select just the top 10 clients in terms of costs billed/branch (top ten clients in branch 1, top ten in branch 2,...

    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!

    July 10, 2012 at 6:31 am

    #1510865

  • RE: Microsoft Connector for Oracle by Attunity

    Welsh Corgi (7/10/2012)

    prvmine (7/9/2012)

    according to Microsoft you do, if you want both to develop and to run SSIS packages on a 64-bit computer:

    http://msdn.microsoft.com/en-us/library/ee470675(v=sql.100).aspx

    I understand that you need both a...

    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!

    July 10, 2012 at 6:02 am

    #1510853

  • RE: Help with SQL query please

    without an explicit ORDER BY department,SumOfCostsNet at the end of your query, SQL server is free to return the data in any order at all.

    the order you get is 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!

    July 10, 2012 at 5:54 am

    #1510849

  • RE: possible to see when a piece of text was removed from an SP?

    crazy4sql (7/10/2012)

    there is a report that you can run that till tell you who last changed the stored procedure and when. from ssms navigate to your database, right mouse click...

    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!

    July 10, 2012 at 5:50 am

    #1510845

  • RE: How do I script alter database statement for multiple databases?

    crazy4sql (7/10/2012)

    its because, sql not able to understand

    alter database @databasename set recovery simple

    in your code.

    If you put this in some variable, like I did in @sql and then...

    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!

    July 10, 2012 at 5:44 am

    #1510843

  • RE: Help on SQL query

    i should also mention my reports are mostly agaisnt hte OLAP , with minimal data warehousing; I agree witht eh other posts, it makes sense in a data warehouse scenario...

    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!

    July 9, 2012 at 12:30 pm

    #1510506

  • RE: Help on SQL query

    Well Andy this is all one man's opinion, although it is built from experience:

    my basic premise: a static table that has rolled up totals is never as accurate as 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!

    July 9, 2012 at 12:21 pm

    #1510495

  • RE: Converting Case for a text field on the fly?

    the UPPER function is what you want in the query, or you can format it in the report side of things with the UCASE or .ToUpper function;

    similarly, there is a...

    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!

    July 9, 2012 at 11:31 am

    #1510462

  • RE: Help on SQL query

    it's not clear what you are asking...why would i want to update "mick"s balance with the information from "Jack"? for example? I'm sure that's not what you meant, but you...

    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!

    July 9, 2012 at 11:14 am

    #1510453

Viewing 15 posts - 5,221 through 5,235 (of 13,460 total)