Forum Replies Created

Viewing 15 posts - 1,756 through 1,770 (of 13,460 total)

  • RE: SSRS INDICATOR tool not available

    it's built in, here's the best link i found when i googled that for you.

    Add or Delete an Indicator (Report Builder and SSRS)

    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!

    May 18, 2015 at 5:30 am

    #1798585

  • RE: enable promotion of Distributed Transactions for RPC: should be set to TRUE or FALSE

    does the storedprocedure ServerB.MyDatabase.MyStoreProcedure itself use an additional call to a linked server, by chance? so it double hops?

    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!

    May 15, 2015 at 2:11 pm

    #1798337

  • RE: enable promotion of Distributed Transactions for RPC: should be set to TRUE or FALSE

    i often get a similar error message when i create a new linked server, where i forgot to set the rpc and rpc out to true;

    Executed as user:...

    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!

    May 15, 2015 at 12:07 pm

    #1798295

  • RE: enable promotion of Distributed Transactions for RPC: should be set to TRUE or FALSE

    pretty sure the misisng pice is the service, if you've toggled both rpc settings in your linked server.

    On the Target/linked server, Remote desktop over to it andopen services....it has 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!

    May 15, 2015 at 11:45 am

    #1798290

  • RE: Sp_help for Oracle?

    ahh, sorry.

    DESC or DESCRIBE TableName will get you some information, not sure how pretty it will be over a linked server, but that's what you want to try.

    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!

    May 15, 2015 at 8:12 am

    #1798204

  • RE: Sp_help for Oracle?

    you can use the two built in procedures which are used specifically for interrogating linked servers.

    EXEC sp_tables_ex [OracleLinkedServerName] will get you started, but from there, you need to find 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!

    May 15, 2015 at 6:51 am

    #1798179

  • RE: Give user access to view but not base table

    i think if you don't use the schema, and leave everything in dbo, you'll be fine.

    as soon as you go cross schema, the user needs access to the underlying tables.

    leaving...

    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!

    May 14, 2015 at 1:35 pm

    #1798000

  • RE: How to test for presence of master key, certificate and symmetric key?

    the Database Master key always has an symmetric_key_id = 101, i read someplace, so my scripts all use that:

    IF NOT EXISTS (SELECT * FROM sys.symmetric_keys WHERE symmetric_key_id = 101)

    BEGIN

    ...

    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!

    May 14, 2015 at 12:47 pm

    #1797985

  • RE: Need Help to sort alpha numeric values

    they are already sortable varchar values, so how do you want to sort them differently than the natural order by text via ORDER BY [ColumnName]?

    the order you pasted them...

    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!

    May 14, 2015 at 12:41 pm

    #1797982

  • RE: script out tables with encrypted triggers

    ok, confirmation.

    Step 1: i enabled the DAC in facets on my test server. no restart or anythign required.

    Step 2: i created this procedure with encryption.

    --#################################################################################################

    --developer utility function added by Lowell,...

    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!

    May 14, 2015 at 12:35 pm

    #1797980

  • RE: script out tables with encrypted triggers

    if you connect via a Dedicated Admin Connection, i believe encrypted objects are visible as decrypted, specifically so you can debug and review.

    not quite true, now that i'm testing...

    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!

    May 14, 2015 at 12:17 pm

    #1797967

  • RE: "Deny Connect SQL " does not work

    you didn't login with that user.

    execute as tests permissions on objects, it does not test whether they can login.

    you literally have to connect via windows, as that user, and see...

    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!

    May 13, 2015 at 9:10 pm

    #1797742

  • RE: Want to run stored procedures to build maintenance database

    you need to use Registered Servers and Central Management Server to help you administer your SQL servers.

    both of them allow you to run the same script across all the servers...

    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!

    May 13, 2015 at 1:01 pm

    #1797650

  • RE: best way to grant access to sensitive data

    GilaMonster (5/12/2015)

    Lowell (5/12/2015)

    i tried putting together an example, but i keep getting a table scan, maybe becaus emy sample table is small.

    does this look right to everyone?

    Yup.

    With a tiny table...

    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!

    May 12, 2015 at 6:30 am

    #1797242

  • RE: best way to grant access to sensitive data

    i tried putting together an example, but i keep getting a table scan, maybe becaus emy sample table is small.

    does this look right to everyone?

    --DROP TABLE tempdb.dbo.MyEncryptedTable

    With MYFirstNames(FName) AS

    (

    Select...

    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!

    May 12, 2015 at 6:07 am

    #1797233

Viewing 15 posts - 1,756 through 1,770 (of 13,460 total)