{"id":256609,"date":"2024-06-10T08:31:36","date_gmt":"2024-06-10T08:31:36","guid":{"rendered":"https:\/\/namso-gen.co\/blog\/?p=256609"},"modified":"2024-06-10T08:31:36","modified_gmt":"2024-06-10T08:31:36","slug":"how-to-capture-return-value-of-xp_logininfo","status":"publish","type":"post","link":"https:\/\/namso-gen.co\/blog\/how-to-capture-return-value-of-xp_logininfo\/","title":{"rendered":"How to capture return value of xp_logininfo?"},"content":{"rendered":"<p>The xp_logininfo is a system stored procedure in SQL Server that provides information about a login within the current SQL Server instance. It can be used to retrieve details such as the login&#8217;s permission levels, default database, and other relevant information. However, capturing the return value of xp_logininfo requires a specific approach. In this article, we will discuss the process of capturing the return value and address some common questions related to it.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_62 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/namso-gen.co\/blog\/how-to-capture-return-value-of-xp_logininfo\/#How_to_Capture_the_Return_Value_of_xp_logininfo\" title=\"How to Capture the Return Value of xp_logininfo\">How to Capture the Return Value of xp_logininfo<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/namso-gen.co\/blog\/how-to-capture-return-value-of-xp_logininfo\/#Frequently_Asked_Questions\" title=\"Frequently Asked Questions\">Frequently Asked Questions<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/namso-gen.co\/blog\/how-to-capture-return-value-of-xp_logininfo\/#1_How_to_capture_the_return_value_when_using_xp_logininfo\" title=\"1. How to capture the return value when using xp_logininfo?\">1. How to capture the return value when using xp_logininfo?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/namso-gen.co\/blog\/how-to-capture-return-value-of-xp_logininfo\/#2_What_does_the_return_value_of_0_mean_in_xp_logininfo\" title=\"2. What does the return value of 0 mean in xp_logininfo?\">2. What does the return value of 0 mean in xp_logininfo?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/namso-gen.co\/blog\/how-to-capture-return-value-of-xp_logininfo\/#3_How_can_I_handle_specific_errors_returned_by_xp_logininfo\" title=\"3. How can I handle specific errors returned by xp_logininfo?\">3. How can I handle specific errors returned by xp_logininfo?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/namso-gen.co\/blog\/how-to-capture-return-value-of-xp_logininfo\/#4_Is_it_possible_to_capture_the_return_value_in_a_table\" title=\"4. Is it possible to capture the return value in a table?\">4. Is it possible to capture the return value in a table?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/namso-gen.co\/blog\/how-to-capture-return-value-of-xp_logininfo\/#5_How_do_I_interpret_return_values_other_than_0_in_xp_logininfo\" title=\"5. How do I interpret return values other than 0 in xp_logininfo?\">5. How do I interpret return values other than 0 in xp_logininfo?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/namso-gen.co\/blog\/how-to-capture-return-value-of-xp_logininfo\/#6_Can_I_use_xp_logininfo_without_specifying_a_login_name\" title=\"6. Can I use xp_logininfo without specifying a login name?\">6. Can I use xp_logininfo without specifying a login name?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/namso-gen.co\/blog\/how-to-capture-return-value-of-xp_logininfo\/#7_Is_it_possible_to_capture_the_return_value_in_a_stored_procedure\" title=\"7. Is it possible to capture the return value in a stored procedure?\">7. Is it possible to capture the return value in a stored procedure?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/namso-gen.co\/blog\/how-to-capture-return-value-of-xp_logininfo\/#8_What_are_some_possible_errors_returned_by_xp_logininfo\" title=\"8. What are some possible errors returned by xp_logininfo?\">8. What are some possible errors returned by xp_logininfo?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/namso-gen.co\/blog\/how-to-capture-return-value-of-xp_logininfo\/#9_Does_xp_logininfo_provide_information_about_Windows_logins\" title=\"9. Does xp_logininfo provide information about Windows logins?\">9. Does xp_logininfo provide information about Windows logins?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/namso-gen.co\/blog\/how-to-capture-return-value-of-xp_logininfo\/#10_Can_xp_logininfo_be_used_in_Azure_SQL_Database\" title=\"10. Can xp_logininfo be used in Azure SQL Database?\">10. Can xp_logininfo be used in Azure SQL Database?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/namso-gen.co\/blog\/how-to-capture-return-value-of-xp_logininfo\/#11_How_can_I_suppress_the_output_of_xp_logininfo\" title=\"11. How can I suppress the output of xp_logininfo?\">11. How can I suppress the output of xp_logininfo?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/namso-gen.co\/blog\/how-to-capture-return-value-of-xp_logininfo\/#12_Can_xp_logininfo_be_used_to_retrieve_user-defined_roles\" title=\"12. Can xp_logininfo be used to retrieve user-defined roles?\">12. Can xp_logininfo be used to retrieve user-defined roles?<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"How_to_Capture_the_Return_Value_of_xp_logininfo\"><\/span>How to Capture the Return Value of xp_logininfo<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>**To capture the return value of xp_logininfo, you need to execute the procedure and store the result in a variable. Here&#8217;s an example:**<\/p>\n<p>&#8220;`<br \/>\nDECLARE @result INT;<\/p>\n<p>EXEC @result = master.sys.xp_logininfo &#8216;YourLogin&#8217;, &#8216;all&#8217;;<\/p>\n<p>PRINT &#8216;Return value: &#8216; + CAST(@result AS VARCHAR(10));<br \/>\n&#8220;`<\/p>\n<p>By executing the xp_logininfo procedure within the master database, we pass the login name (&#8216;YourLogin&#8217; in this case) as the first parameter and &#8216;all&#8217; as the second parameter to retrieve all available information. The return value will be assigned to the @result variable, and we can then use it as needed.<\/p>\n<p>It&#8217;s important to note that the return value is an integer and can have different meanings depending on the value returned. Generally, a value of 0 indicates success, while other values may indicate specific errors or warnings. Refer to the SQL Server documentation for a detailed explanation of different return values.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Frequently_Asked_Questions\"><\/span>Frequently Asked Questions<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"1_How_to_capture_the_return_value_when_using_xp_logininfo\"><\/span>1. How to capture the return value when using xp_logininfo?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nTo capture the return value of xp_logininfo, execute the procedure and store the result in a variable, as shown in the example above.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_What_does_the_return_value_of_0_mean_in_xp_logininfo\"><\/span>2. What does the return value of 0 mean in xp_logininfo?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nA return value of 0 in xp_logininfo indicates a successful execution without any errors.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"3_How_can_I_handle_specific_errors_returned_by_xp_logininfo\"><\/span>3. How can I handle specific errors returned by xp_logininfo?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYou can utilize conditional statements within your SQL code to handle different return values and perform specific actions accordingly.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"4_Is_it_possible_to_capture_the_return_value_in_a_table\"><\/span>4. Is it possible to capture the return value in a table?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can capture the return value of xp_logininfo in a table by creating a table variable or a temporary table and inserting the result into it.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"5_How_do_I_interpret_return_values_other_than_0_in_xp_logininfo\"><\/span>5. How do I interpret return values other than 0 in xp_logininfo?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nReturn values other than 0 in xp_logininfo indicate possible errors or warnings. Refer to the SQL Server documentation or relevant resources to understand the specific meaning of each return value.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"6_Can_I_use_xp_logininfo_without_specifying_a_login_name\"><\/span>6. Can I use xp_logininfo without specifying a login name?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can use xp_logininfo without specifying a login name. However, it will only return information about the currently logged-in user.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"7_Is_it_possible_to_capture_the_return_value_in_a_stored_procedure\"><\/span>7. Is it possible to capture the return value in a stored procedure?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can capture the return value of xp_logininfo within a stored procedure by declaring a variable and assigning the result to it.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"8_What_are_some_possible_errors_returned_by_xp_logininfo\"><\/span>8. What are some possible errors returned by xp_logininfo?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nPossible errors returned by xp_logininfo include invalid login names, insufficient permissions to execute the procedure, or problems accessing the underlying system information.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"9_Does_xp_logininfo_provide_information_about_Windows_logins\"><\/span>9. Does xp_logininfo provide information about Windows logins?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, xp_logininfo provides information about both SQL Server logins and Windows logins.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"10_Can_xp_logininfo_be_used_in_Azure_SQL_Database\"><\/span>10. Can xp_logininfo be used in Azure SQL Database?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nNo, xp_logininfo is not available in Azure SQL Database. Instead, you can utilize Azure Active Directory (AAD) for managing logins and permissions.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"11_How_can_I_suppress_the_output_of_xp_logininfo\"><\/span>11. How can I suppress the output of xp_logininfo?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nTo suppress the output of xp_logininfo, you can use the SET NOCOUNT ON statement before executing the procedure. This will prevent the row count from being returned.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"12_Can_xp_logininfo_be_used_to_retrieve_user-defined_roles\"><\/span>12. Can xp_logininfo be used to retrieve user-defined roles?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nNo, xp_logininfo does not provide information about user-defined roles. However, you can use other system stored procedures or queries to retrieve information about roles assigned to a login.<\/p>\n<p>In conclusion, capturing the return value of xp_logininfo requires executing the procedure and storing the result in a variable. By following this approach, you can effectively utilize xp_logininfo and retrieve the desired information about logins within your SQL Server instance.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The xp_logininfo is a system stored procedure in SQL Server that provides information about a login within the current SQL Server instance. It can be used to retrieve details such as the login&#8217;s permission levels, default database, and other relevant information. However, capturing the return value of xp_logininfo requires a specific approach. In this article, &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to capture return value of xp_logininfo?\" class=\"read-more button\" href=\"https:\/\/namso-gen.co\/blog\/how-to-capture-return-value-of-xp_logininfo\/#more-256609\">Read more<span class=\"screen-reader-text\">How to capture return value of xp_logininfo?<\/span><\/a><\/p>\n","protected":false},"author":65,"featured_media":107420,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[86279],"tags":[],"class_list":["post-256609","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-learn","no-featured-image-padding"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to capture return value of xp_logininfo?<\/title>\n<meta name=\"description\" content=\"The xp_logininfo is a system stored procedure in SQL Server that provides information about a login within the current SQL Server instance. It can be used\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/namso-gen.co\/blog\/how-to-capture-return-value-of-xp_logininfo\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to capture return value of xp_logininfo?\" \/>\n<meta property=\"og:description\" content=\"The xp_logininfo is a system stored procedure in SQL Server that provides information about a login within the current SQL Server instance. It can be used\" \/>\n<meta property=\"og:url\" content=\"https:\/\/namso-gen.co\/blog\/how-to-capture-return-value-of-xp_logininfo\/\" \/>\n<meta property=\"og:site_name\" content=\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/synchronyfinancial\" \/>\n<meta property=\"article:published_time\" content=\"2024-06-10T08:31:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2024\/03\/faq.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Timothy Mathis\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@synchrony\" \/>\n<meta name=\"twitter:site\" content=\"@synchrony\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Timothy Mathis\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-capture-return-value-of-xp_logininfo\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-capture-return-value-of-xp_logininfo\/\"},\"author\":{\"name\":\"Timothy Mathis\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/ffa5be155490b2344e28f672fcc1e318\"},\"headline\":\"How to capture return value of xp_logininfo?\",\"datePublished\":\"2024-06-10T08:31:36+00:00\",\"dateModified\":\"2024-06-10T08:31:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-capture-return-value-of-xp_logininfo\/\"},\"wordCount\":677,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#organization\"},\"articleSection\":[\"Learn\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/namso-gen.co\/blog\/how-to-capture-return-value-of-xp_logininfo\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-capture-return-value-of-xp_logininfo\/\",\"url\":\"https:\/\/namso-gen.co\/blog\/how-to-capture-return-value-of-xp_logininfo\/\",\"name\":\"How to capture return value of xp_logininfo?\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#website\"},\"datePublished\":\"2024-06-10T08:31:36+00:00\",\"dateModified\":\"2024-06-10T08:31:36+00:00\",\"description\":\"The xp_logininfo is a system stored procedure in SQL Server that provides information about a login within the current SQL Server instance. It can be used\",\"breadcrumb\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-capture-return-value-of-xp_logininfo\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/namso-gen.co\/blog\/how-to-capture-return-value-of-xp_logininfo\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-capture-return-value-of-xp_logininfo\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/namso-gen.co\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to capture return value of xp_logininfo?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#website\",\"url\":\"https:\/\/namso-gen.co\/blog\/\",\"name\":\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\",\"description\":\"In Namso gen blog you can get many tips regarding to Credit cards, VCC, Credit card security etc. You can generate credit cards by using Namso-gen.co\",\"publisher\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/namso-gen.co\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#organization\",\"name\":\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\",\"url\":\"https:\/\/namso-gen.co\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png\",\"contentUrl\":\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png\",\"width\":500,\"height\":164,\"caption\":\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\"},\"image\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/synchronyfinancial\",\"https:\/\/twitter.com\/synchrony\",\"https:\/\/www.youtube.com\/synchronyfinancial\",\"https:\/\/www.instagram.com\/synchrony\",\"https:\/\/www.linkedin.com\/company\/synchrony-financial\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/ffa5be155490b2344e28f672fcc1e318\",\"name\":\"Timothy Mathis\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g\",\"caption\":\"Timothy Mathis\"},\"description\":\"Guest author Timothy Mathis has meticulously crafted and revised this article to the best of their knowledge and understanding. Readers are strongly advised to exercise caution, verify information independently, and rely on their own judgment when considering the information provided. Read more articles on Namso Gen here.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to capture return value of xp_logininfo?","description":"The xp_logininfo is a system stored procedure in SQL Server that provides information about a login within the current SQL Server instance. It can be used","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/namso-gen.co\/blog\/how-to-capture-return-value-of-xp_logininfo\/","og_locale":"en_US","og_type":"article","og_title":"How to capture return value of xp_logininfo?","og_description":"The xp_logininfo is a system stored procedure in SQL Server that provides information about a login within the current SQL Server instance. It can be used","og_url":"https:\/\/namso-gen.co\/blog\/how-to-capture-return-value-of-xp_logininfo\/","og_site_name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","article_publisher":"https:\/\/www.facebook.com\/synchronyfinancial","article_published_time":"2024-06-10T08:31:36+00:00","og_image":[{"width":1200,"height":630,"url":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2024\/03\/faq.png","type":"image\/png"}],"author":"Timothy Mathis","twitter_card":"summary_large_image","twitter_creator":"@synchrony","twitter_site":"@synchrony","twitter_misc":{"Written by":"Timothy Mathis","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/namso-gen.co\/blog\/how-to-capture-return-value-of-xp_logininfo\/#article","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-capture-return-value-of-xp_logininfo\/"},"author":{"name":"Timothy Mathis","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/ffa5be155490b2344e28f672fcc1e318"},"headline":"How to capture return value of xp_logininfo?","datePublished":"2024-06-10T08:31:36+00:00","dateModified":"2024-06-10T08:31:36+00:00","mainEntityOfPage":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-capture-return-value-of-xp_logininfo\/"},"wordCount":677,"commentCount":0,"publisher":{"@id":"https:\/\/namso-gen.co\/blog\/#organization"},"articleSection":["Learn"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/namso-gen.co\/blog\/how-to-capture-return-value-of-xp_logininfo\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/namso-gen.co\/blog\/how-to-capture-return-value-of-xp_logininfo\/","url":"https:\/\/namso-gen.co\/blog\/how-to-capture-return-value-of-xp_logininfo\/","name":"How to capture return value of xp_logininfo?","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/#website"},"datePublished":"2024-06-10T08:31:36+00:00","dateModified":"2024-06-10T08:31:36+00:00","description":"The xp_logininfo is a system stored procedure in SQL Server that provides information about a login within the current SQL Server instance. It can be used","breadcrumb":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-capture-return-value-of-xp_logininfo\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/namso-gen.co\/blog\/how-to-capture-return-value-of-xp_logininfo\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/namso-gen.co\/blog\/how-to-capture-return-value-of-xp_logininfo\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/namso-gen.co\/blog\/"},{"@type":"ListItem","position":2,"name":"How to capture return value of xp_logininfo?"}]},{"@type":"WebSite","@id":"https:\/\/namso-gen.co\/blog\/#website","url":"https:\/\/namso-gen.co\/blog\/","name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","description":"In Namso gen blog you can get many tips regarding to Credit cards, VCC, Credit card security etc. You can generate credit cards by using Namso-gen.co","publisher":{"@id":"https:\/\/namso-gen.co\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/namso-gen.co\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/namso-gen.co\/blog\/#organization","name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","url":"https:\/\/namso-gen.co\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png","contentUrl":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png","width":500,"height":164,"caption":"Namso Gen Blog - Free Credit Card Generator [100% Valid]"},"image":{"@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/synchronyfinancial","https:\/\/twitter.com\/synchrony","https:\/\/www.youtube.com\/synchronyfinancial","https:\/\/www.instagram.com\/synchrony","https:\/\/www.linkedin.com\/company\/synchrony-financial"]},{"@type":"Person","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/ffa5be155490b2344e28f672fcc1e318","name":"Timothy Mathis","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","caption":"Timothy Mathis"},"description":"Guest author Timothy Mathis has meticulously crafted and revised this article to the best of their knowledge and understanding. Readers are strongly advised to exercise caution, verify information independently, and rely on their own judgment when considering the information provided. Read more articles on Namso Gen here."}]}},"_links":{"self":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts\/256609","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/users\/65"}],"replies":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/comments?post=256609"}],"version-history":[{"count":0,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts\/256609\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/media\/107420"}],"wp:attachment":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/media?parent=256609"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/categories?post=256609"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/tags?post=256609"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}