Forum Replies Created

Viewing 15 posts - 1 through 15 (of 82 total)

  • Reply To: SQL Art: I Made a Christmas Card In SSMS

    Need to select Spatial data between Results and Message tab.

    ______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂

    December 24, 2025 at 9:39 pm

    #4707022

  • Reply To: SQL Art: I Made a Christmas Card In SSMS

    I tried to email this for more fun but got the below error message.

    Failed to initialize sqlcmd library with error number -2147467259.

    ______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂

    December 24, 2025 at 9:38 pm

    #4707021

  • Reply To: How to delete secondary data file by moving it's data to Primary data file

    Hope i can use this... but still hesitant to use it in production...

    USE [dbname]

    GO

    DBCC SHRINKFILE (N'dbname_Data2' , EMPTYFILE)

    GO

    ______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂

    October 5, 2020 at 3:14 pm

    #3792914

  • Reply To: How to delete secondary data file by moving it's data to Primary data file

    sorry for adding my reply to this old thread.

    am using SQL Server 2019 and created a secondary file to fix the disk full error. Unfortunately, the secondary file is created...

    ______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂

    October 5, 2020 at 3:09 pm

    #3792913

  • Reply To: AG readonly database after failover

    Dear All,

    In spite of having a listener am getting read-only databases in the secondary during the failover. Not sure where it goes wrong. Any help is highly appreciated. Thank you.

    ______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂

    June 5, 2019 at 2:24 pm

    #3650435

  • RE: How to Become a MCDBA ?

    Hi Gail,

    Am aware that am posting on years old thread. Sorry for that.
    Would you please let me know the recent link on the certification and how to...

    ______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂

    November 9, 2018 at 3:14 pm

    #2013038

  • RE: Data synchronization state of some availability database is not healthy

    I got the same warning and error. Please let me know the solution if you did solve it. 

    Many thanks in advance.

    ______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂

    January 9, 2018 at 8:40 am

    #1975090

  • RE: Certifying Schools

    University education need not make Developers or DBAs. They need to teach on how to handle life positively in spite of profit or loss. Basically, education centers should educate the...

    ______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂

    November 30, 2017 at 5:14 am

    #1970017

  • RE: Certifying Schools

    Fact. In most of the countries education is seen as profit earning business only. Respective governments should focus more on the syllabus and make sure children are grown with necessary...

    ______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂

    November 29, 2017 at 10:51 pm

    #1969989

  • RE: Creating Maintenance plans in SQL Server 2016 SSMS

    Yes. Permission is not a problem. 

    Thanks

    ______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂

    October 13, 2017 at 12:56 am

    #1963498

  • RE: Creating Maintenance plans in SQL Server 2016 SSMS

    The error comes in primary cluster. Am able to create\edit management plans in the secondary server of the cluster. However structure in both the server's "

    ______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂

    October 13, 2017 at 12:11 am

    #1963494

  • RE: Creating Maintenance plans in SQL Server 2016 SSMS


    1. Am not able to find the folder "SQL Server Developer Tools" in the path "C:\Program Files (x86)\Common Files\Microsoft Shared\"

    2. Is it a new install of...

    ______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂

    October 12, 2017 at 11:42 pm

    #1963492

  • RE: grant execute overrides user permissions

    Sorry for posting on three year old thread.

    Just curious to know if there's any solution for a similar situation. I have an archive database in which the stored procedures...

    ______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂

    October 17, 2016 at 6:49 am

    #1906840

  • RE: Network Fluctuation and procedure cache

    Thank you Sartori. If you can show some proof it will be great. Please share links if you find'em online.

    ______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂

    June 28, 2016 at 2:51 am

    #1887207

  • RE: Network Fluctuation and procedure cache

    Thanks for your reply. But my doubt still remains. I want to know if the network fails and comes back, is it not equal to a server restart and all...

    ______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂

    June 28, 2016 at 2:36 am

    #1887202

    • Viewing 15 posts - 1 through 15 (of 82 total)