Forum Replies Created

Viewing 15 posts - 91 through 105 (of 1,079 total)

  • RE: link to a mdf database

    olafurpetursson - Wednesday, May 24, 2017 8:13 AM

    So I created a MS SQL db , but now I cannot link to...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: Process to Prevent Email Spam

    amy26 - Wednesday, May 24, 2017 8:09 AM

      I wouldn't put it on the mail items table instead?

    Yes you can, it might...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: Problem with net framework 3.5 installing sql 2012 server

    antocasu - Wednesday, May 24, 2017 7:36 AM

    I've done it.

    I also tried to force the net framework 3.5 using the dism command...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: Process to Prevent Email Spam

    you could create an INSERT trigger on the sysmail_log table, to evaluate the count of rows in the last minute, and if more than example 20, send mail to admin. 

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: Problem with net framework 3.5 installing sql 2012 server

    You need to add .Net 3.5 as a Feature using the Windows Server Manager.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: Msg 8181 - Text for 'MyProcedureName' is missing from the system catalog.

    Do you see anything in the syscomments table for your procedure when running:
    select * from syscomments
    where text like '%proc name here%'

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: Unable to RDP into the server or login through SSMS

    newdba2017 - Tuesday, May 23, 2017 12:40 PM

    I am not sure how to telnet to port 80/1443

    ensure telnet client is installed on...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: Unable to RDP into the server or login through SSMS

    Firewalls maybe enabled on the server?
    Can you telnet to port 80/1443?

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: Download SQL Server 2014 evaluation edition.

    Download the ISO from here https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2014-sp2
    You can mount/extract the ISO and run setup from there.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: Help with Performance on select count(*) SQL Server 2014

    zouzou - Tuesday, May 23, 2017 10:17 AM

    I have backed up DEV db and restored it on TEST server  and then i...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: Help with Performance on select count(*) SQL Server 2014

    zouzou - Tuesday, May 23, 2017 9:52 AM

    they are virtual and i think its not environment related since i have restore the...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: Help with Performance on select count(*) SQL Server 2014

    zouzou - Tuesday, May 23, 2017 9:30 AM

    Similar servers and memory is more on Test which doesnt make sense either

    Are both SQL...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: Help with Performance on select count(*) SQL Server 2014

    zouzou - Tuesday, May 23, 2017 9:25 AM

    Have 2 same databases one on test and one on dev in different servers. Whilst...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: Log ship primary DB has log 2x large as datafile

    what is the status of this database when checking 

    Select name, log_reuse_wait_desc from sys.databases

    is the log shipping backup job succeeding?

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: Question about DBMail

    Well, SQL won't *just* send out alerts. You need to set them up. 
    Configuring SMTP relay in a mail profile is the first step. 

    Here is how to set...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

Viewing 15 posts - 91 through 105 (of 1,079 total)