Forum Replies Created

Viewing 15 posts - 7,006 through 7,020 (of 13,459 total)

  • RE: UPDATE STatement

    bvsc (8/4/2011)

    I have a table with 50 columns(col1,col2....col50)

    If I want to update col5....So, Can I get col10,col15 values without x-lock???

    Like update table set col5= 'updating' where col1= 10

    at the same...

    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!

    August 4, 2011 at 1:12 pm

    #1363919

  • RE: SQL Server 2008 Convert Rows into INSERT statement

    when i read the OP, it seemed that the data layer knew which items to capture, since his presentation will create a control for input for each item if needed,...

    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!

    August 4, 2011 at 11:11 am

    #1363835

  • RE: SQL Server 2008 Convert Rows into INSERT statement

    what's wrong with a single datatable with 200 columns, maybe with just the one row the client would be fiddling with?

    then the GUI can present you 100 or 150...

    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!

    August 4, 2011 at 10:54 am

    #1363824

  • RE: How to log what table fields querys are using

    this question made me explore one of those "scary places" outside my comfort zone of tsql: XQuery and XML.

    I know you can get the actual XML plan from teh cache,...

    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!

    August 4, 2011 at 10:05 am

    #1363785

  • RE: Need a Query for levels of tables

    SQLRNNR (8/3/2011)

    Yes there is. Check this one out.

    http://jasonbrimhall.info/2011/07/11/foreign-key-hierarchy-update/

    Nice script Jason, I had done something similar for Hierarchy, but mentally skipped over dependencies in the other direction.

    i added that 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!

    August 3, 2011 at 2:54 pm

    #1363352

  • RE: grant execute permission on all sprocs

    sqlnaive (8/3/2011)

    I did that actually. But after doing this it shows "Query completed successfully". Thereafter when i logged in using user domain\u1, it gave me error saying "You do not...

    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!

    August 3, 2011 at 8:53 am

    #1363125

  • RE: grant execute permission on all sprocs

    sqlnaive (8/3/2011)

    Ok I got he idea about the view server state. My confusion lies with view database state permissions.

    1. I have this NT group domain\group1 which contains users domain\u1...

    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!

    August 3, 2011 at 8:22 am

    #1363085

  • RE: grant execute permission on all sprocs

    sqlnaive (8/3/2011)

    I've checked that granting Veiw database state to a role executes successfully. However the users having that roles mapped are still not able to access the DMVs.

    , yeah, unless...

    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!

    August 3, 2011 at 7:20 am

    #1363022

  • RE: grant execute permission on all sprocs

    sqlnaive (8/3/2011)

    Hello Lowel, Can't we similarly provide View server state and View satabase state to a ROLE ? I know that view server state permission can be given to server...

    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!

    August 3, 2011 at 5:18 am

    #1362927

  • RE: Script Out Database Mail Settings?

    Ninja's_RGR'us (8/2/2011)

    Nice script > briefcasing!.

    Had you considered the profiler method to see what was going on? Might have saved you some time.

    no, i fell into the stubborn learn without...

    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!

    August 2, 2011 at 6:37 pm

    #1362770

  • RE: Script Out Database Mail Settings?

    Thanks to a PM from a fellow member here, i found that the script i posted 10 plus months ago had a few minor flaws in it: I've edited 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!

    August 2, 2011 at 3:29 pm

    #1362700

  • RE: grant users with read access to 20 databases

    lemme see where i put Remi's password again....

    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!

    August 2, 2011 at 2:06 pm

    #1362601

  • RE: grant users with read access to 20 databases

    Ninja's_RGR'us (8/2/2011)

    sqlfriends (8/2/2011)

    Lowell, just curious how did you add the image to the post?

    Upload the image, then right click on the attachement and hit copy link.

    Then use the img tags...

    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!

    August 2, 2011 at 1:55 pm

    #1362588

  • RE: Cell Level Encryption/Decryption

    yes, it just requires a little setup.

    you create a master key on production.

    you create the cert on production.

    you backup the master key and the cert from production.

    you restore them on...

    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!

    August 2, 2011 at 1:43 pm

    #1362571

  • RE: Insert multiple column data into Another table using Trigger

    also, your example tables are all in Oracle syntax....a trigger in Oracle looks and behaves differently than SQL.

    Oracle is all row based, where SQL is set based.

    show us what you've...

    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!

    August 2, 2011 at 1:17 pm

    #1362540

Viewing 15 posts - 7,006 through 7,020 (of 13,459 total)