Forum Replies Created

Viewing 15 posts - 76 through 90 (of 9,725 total)

  • Reply To: Converting job_id to join to another table.

    kaj wrote:

    There isn't really a need to use that scalar function for the conversion.

    This will also work:

    SELECT t.SPID, t.Status, t.ProgramName, j.name AS JobName
    FROM @Table t
    LEFT OUTER JOIN...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    November 19, 2024 at 4:40 pm

    #4486057

  • Reply To: Converting job_id to join to another table.

    Ant-Green wrote:

    You could just do a straight select also, no need to convert the hex to the GUID as it will implicitly do this for you

    SELECT *...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    November 19, 2024 at 4:25 pm

    #4486032

  • Reply To: Converting job_id to join to another table.

    Weird gateway error caused repost. And won't let me delete the code block.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
     
     
     
    November 19, 2024 at 3:18 pm
     
    #4485992
         
     
    •  
  •  
     
     Reply To: Converting job_id to join to another table. 
     
       
    And after changing my search terms in Google to "SQL Server get job name from sp_who2 program_name" instead of something more generic, I HAVE FOUND IT!
    CONVERT(VARCHAR(34),master.dbo.fn_VarbinToHexStr(sj.Job_ID))
    This function converts jobID to...
    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
     
     
     
    November 19, 2024 at 3:17 pm
     
    #4485991
         
     
    •  
  •  
     
     Reply To: Object-level permissions on dbo 
     
       
    Oh, nevermind. I think I found it. WHERE sys.objects.object_id > 0 AND sys.objects.object_id < 1042102753.
    Let me know if anyone knows of any other method.
    EDIT: Hrm. Nope. Not quite the solution...
    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
     
     
     
    October 4, 2024 at 2:15 pm
     
    #4465314
         
     
    •  
  •  
     
     Reply To: Object-level permissions on dbo 
     
       
    Following up on this... Will it hurt if I remove system object permissions from the public role?
    Or, alternatively, is there a method to ensure that I only remove user objects...
    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
     
     
     
    October 4, 2024 at 2:05 pm
     
    #4465313
         
     
    •  
  •  
     
     Reply To: Object-level permissions on dbo 
     
       
    No, it was definately object-level permissions on the public role. I revoked them and my regular account no longer could see the database data.
    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
     
     
     
    October 2, 2024 at 11:39 am
     
    #4464476
         
     
    •  
  •  
     
     Reply To: Object-level permissions on dbo 
     
       
    I'm assuming that it only showed for dbo because it was in public. Because it didn't show for dbo on other databases.
    The script I should have used is below:
     
    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
    

                        
    

        
    
            
    October 1, 2024 at 8:03 pm
    
            
    #4464324
    

            
            
                                                
        
    
    



                                                

  • 
    
    
        
    
                        Reply To: Object-level permissions on dbo
        
    

        
    
            
            
                        

            
    Oh, good grief. My check on public securables finally loaded (I had turned away from it and forgotten to close it after taking that screenshot). Apparently it is public, not...
    


    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
    

                        
    

        
    
            
    October 1, 2024 at 7:10 pm
    
            
    #4464317
    

            
            
                                                
        
    
    
    

    • 

                                                

  • 
    
    
        
    
                        Reply To: Object-level permissions on dbo
        
    

        
    
            
            
                        

            
    Script out of user just gives me this:
    


    /****** Object: User [dbo] Script Date: 10/1/2024 2:31:15 PM ******/
    


    CREATE USER [dbo] FOR LOGIN [sa] WITH DEFAULT_SCHEMA=[dbo]
    


    GO
    


    Using this script is where I see...
    


    Attachments:
    You must be logged in to view attached files.
    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
    

                        
    

        
    
            
    October 1, 2024 at 6:38 pm
    
            
    #4464304
    

            
            
                                                
        
    
    
    

    • 

                                                

  • 
    
    
        
    
                        Reply To: Are the posted questions getting worse?
        
    

        
    
            
            
                        

            
    OMG, can I scream yet? This is ... somewhat hilarious and painful and scary all at the same time. Object-level permissions on dbo – SQLServerCentral Forums
    


    HELP!
    


    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
    

                        
    

        
    
            
    October 1, 2024 at 4:53 pm
    
            
    #4464264
    

            
            
                                                
        
    
    
    

    • 

                                                

  • 
    
    
        
    
                        Reply To: Dont want to restart Tempdb  not able to shrink datafiles in ag primary
        
    

        
    
            
            
                        

            
    Additional note: If TRUNCATEONLY isn't working, check min file sizes on the tempdb files. They may be larger than they are supposed to be. ALTER the files to resize and...
    


    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
    

                        
    

        
    
            
    October 1, 2024 at 4:40 pm
    
            
    #4464260
    

            
            
                                                
        
    
    
    

    • 

                                                

  • 
    
    
        
    
                        Reply To: Dont want to restart Tempdb  not able to shrink datafiles in ag primary
        
    

        
    
            
            
                        

            
    So there is an alternative if tempdb has "gone wild" and this isn't ordinary growth.
    


    The commands above will help you, as you surmise, but plans will have be recreated and...
    


    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
    

                        
    

        
    
            
    October 1, 2024 at 4:39 pm
    
            
    #4464259
    

            
            
                                                
        
    
    
    

    • 

                                                

  • 
    
    
        
    
                        Reply To: SSMS 2016 Default Open + Save Path for Scripts
        
    

        
    
            
            
                        

            
    My workplace has made sure I am unable to update the ssms.Application. pkgdef file to fix my save locations. Very annoying because none of us can make changes in that...
    


    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
    

                        
    

        
    
            
    September 20, 2024 at 2:05 pm
    
            
    #4460853
    

            
            
                                                
        
    
    
    

    • 

                                                

  • 
    
    
        
    
                        Reply To: Windows 11 & sudden SSMS sorting nuisance
        
    

        
    
            
            
                        

            
    Probably a good idea.
    


    Anyone else have this problem?
    


    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
    

                        
    

        
    
            
    August 12, 2024 at 8:10 pm
    
            
    #4444290
    

            
            
                                                
        
    
    
    

    • 

                        



            



    

    

    Viewing 15 posts - 76 through 90 (of 9,725 total)