Skip to content
July 2, 2022
  • Subscribe
  • Twitter
  • LinkedIN Group (Forum)
  • Facebook Group (Forum)
  • Facebook Page
  • YouTube
  • Telegram Group (Forum)
SQLServerGeeks

SQLServerGeeks

SQL Server Education (by the geeks, for the geeks)

Free Live Training Virtual Symposium DPD banglore
  • Blogs
    • Subscribe To Our Newsletter
    • SQLServerGeeks Bulletin Index
    • The Scripts Garage
    • All Blog Posts
    • One DMV a Day Series
    • Accidental DBA Series
    • One Operator a Day Series
    • One Trace Flag a Day Series
  • Magazine
  • Events
  • Videos
    • SSG Videos Lobby
    • SQL Server Tutorials & Demos
    • Webinar Recordings
    • SQLShighra Recordings
    • Virtual Symposium Recordings
      • SQL Server & Azure SQL – May 2021
      • SQL Server 2019 & Azure SQL – May 2020
    • Geek Talks
  • RESOURCES
    • SQL Server Resources
    • SQL Server Notes
  • Social
    • Subscribe To Our Newsletter
    • Twitter
    • LinkedIN Group (Forum)
    • Facebook Group
    • Facebook Page
    • YouTube Channel
    • Telegram Group (Forum)
  • About Us
    • Subscribe To Our Newsletter
    • SSG Team
    • Join Us
    • Speakers
    • Blog With Us
    • Contact Us
    • Write a Guest Post
    • Testimonials
    • Join DataPlatformGeeks community
  • Log In
  • Join Now
Main Menu

Tag: sp_configure

SQL Server / SQL Server Accidental DBA Series

Enable CLR in SQL Server

February 22, 2015December 20, 2019 - by SQL Geek - Leave a Comment

The Common language runtime (CLR) feature allows you to write stored procedures/trigger/functions in .NET managed code and execute the same from SQL Server. However, in order to enable the execution of …

Enable CLR in SQL Server Read More
SQL Server / SQL Server Accidental DBA Series

SQL Server Error Message 6263 – Enable SQL Server for CLR Support

February 17, 2015December 20, 2019 - by SQL Geek - Leave a Comment

The SQL Server Error Message 6263 occurs when you try to execute a CLR/.Net procedure and it is disabled.  The complete error message somewhat looks like as below Msg 6263, Level …

SQL Server Error Message 6263 – Enable SQL Server for CLR Support Read More
SQL Server / SQL Server Accidental DBA Series

Recursive triggers in SQL Server

February 14, 2015December 20, 2019 - by SQL Geek - Leave a Comment

In this blog we’ll look at Recursive triggers in SQL Server. Triggers are said to be recursive/nested when a trigger on a table calls another trigger on same or different table …

Recursive triggers in SQL Server Read More
SQL Server / SQL Server Accidental DBA Series

Get SQL Server configuration information

January 1, 2015December 20, 2019 - by SQL Geek - Leave a Comment

The sys.configurations view can be used to get SQL Server configuration information. Let’s analyze the output of sys.configurations view. As shown in above snapshot, the sys.configuration view lists down different server …

Get SQL Server configuration information Read More
SQL Server / SQL Server Accidental DBA Series

T-SQL script to delete files

July 23, 2014December 23, 2019 - by SQL Geek - 1 Comment

Many a times need arises to access/modify windows folder structures from SQL server. Though SQL Server is not meant for this purpose, however here is a T-SQL script to delete files …

T-SQL script to delete files Read More
SQL Server

SQL Server: What all changes require a restart of SQL Service?

December 23, 2011July 5, 2014 - by admin - 4 Comments.

Question of the day: What all changes require a restart of SQL Service? Let’s say you get a request to change a SQL Server setting and you don’t know whether it …

SQL Server: What all changes require a restart of SQL Service? Read More

Subscribe to SQLServerGeeks

Ad

Virtual Symposium

master classes

SSG_linkedin

SSG_fb

About Us

  • Core Team
  • Authors
  • Blog With Us
  • Testimonials
  • Contact Us
  • Join DataPlatformGeeks Community

Subscribe To Our Newsletter

loader

Virtual Symposium

Copyright © 2019 SQLServerGeeks. Community initiative by Amit Bansal | Anti-Harassment Policy
Powered by WordPress and HitMag.