Forum Replies Created

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

  • RE: Splitting City and State with variable formats

    i think if you REVERSE the string, and grab up to a space, that might be pretty close to what you are after:

    you can always REPLACE() to remove any...

    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:25 pm

    #1363932

  • 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

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