Forum Widgets
Latest Discussions
SQL Server
Hi everyone, so its my first time downloading SSMS and SQL Server. I have download the SSMS, but when I tried download SQL Server it always error. I have tried to re-install, deleted all SQL Server reference, and follow this guide https://www.sqlcoffee.com/Tips0026.htm My last error saying Can you help me to figure and fix the error? I have attached the detail and summary txt in the drive link https://drive.google.com/drive/folders/1GSCok73nLQUaplbfDulumgGJlI2mN0f9?usp=sharinglicaliceJan 12, 2025Copper Contributor17Views0likes1CommentSSRS subscription
Hi all, I hv a question about SSRS subscription under mssql 2022 STD, I saw when i subscript to a report, it will create a job under SSMS jobs. I would like to manage the report subscription not run on the specified date store in some table in the database. Is it possible to run another job to use sp_update_job to disable the job when date is find in the table, and enable the job when the date is not find in the table. Because the SSRS's job contain a remarks that "modify this job will make database incompatible", im not sure is it work. thanks in advance.Joey1974Jan 10, 2025Copper Contributor5Views0likes0CommentsAssistance Required for Downloading SQL Server 2014 ESU Patch for Standalone Installation
Hi Microsoft Support Team, I am reaching out for assistance regarding an issue I am encountering while trying to download the SQL Server 2014 Extended Security Updates (ESU) patch for a standalone installation. Despite several attempts, I am unable to download the necessary patch from the Microsoft Update Catalog or any other available resources. Here are the details of the issue: Product: SQL Server 2014 Problem: Unable to download the ESU patch for standalone installation. Steps Taken: I have searched for the appropriate SQL Server 2014 ESU patch in the Microsoft Update Catalog, but I was unable to locate the correct patch for manual download. This patch is critical to maintain the security of our systems, and I would appreciate your assistance in either providing the download link or helping resolve this issue so I can successfully install the necessary security updates. Could you please guide me on the correct procedure or provide an alternative download method for the SQL Server 2014 ESU patch? If there are any eligibility requirements for accessing this patch, kindly let me know how to verify or fulfill those requirements. Thank you for your prompt attention to this matter. I look forward to your guidance and resolution.jimmykhohJan 09, 2025Copper Contributor37Views0likes2CommentsSQL Server 2022 Error -2068052377
Hi everyone, so its my first time downloading SSMS and SQL Server. I have download the SSMS, but when I tried download SQL Server it always error. I have tried to re-install, deleted all SQL Server reference, and follow this guide https://www.sqlcoffee.com/Tips0026.html My last error saying Can you help me to figure and fix the error? I have attached the detail and summary txt in the drive link https://drive.google.com/drive/folders/1GSCok73nLQUaplbfDulumgGJlI2mN0f9?usp=sharinglicaliceJan 08, 2025Copper Contributor6Views0likes0CommentsEvaluation expired SQL Server
Hello, We are dealing with an issue where the evaluation version. We will be upgrading it but i dont have access to billing, in the interim am i able to run it as developer? what are the differences in running it as developer when previously it was evaluation? Thanks.ShaunMcJan 07, 2025Copper Contributor34Views0likes2CommentsSingle pane of glass to look at all of my SQL Servers
I just got back from SQL Pass Summit 2024 and I was told that I could ARC enable all of my SQL Servers so I would have a single pane of glass to view and scan logs, configurations, view best practices etc. Unfortunately, when I got home, I realized that since we have SQL Servers on Azure VMs we can't use Azure ARC to manage them. Unsupported configurations Azure Arc-enabled SQL Server doesn't currently support the following configurations: ... Multiple instances of SQL Server installed on the same host operating system with the same instance name. SQL Server in Azure Virtual Machines. An Always On availability group where one or more replicas is on a failover cluster instance. Since all our Azure VMs have the SQL Agent installed how can we unify our management experience in Azure?Mike_LemayJan 05, 2025Copper Contributor25Views0likes1CommentSQL Server Management Studio fails to recognize the table
Hi, ALL, 'm C/C++ developer who is trying to write some application that will talk to SQL Server. I have the server running and I have MS installed. In the MS I opened a tab for a new query and issue: CREATE TABLE "abcattbl"(abt_os tinyint, abt_tnam nchar(129) NOT NULL, abt_tid integer, abt_ownr nchar(129) NOT NULL, abd_fhgt smallint, abd_fwgt smallint, abd_fitl char(1), abd_funl integer, abd_fstr integer, abd_fchr smallint, abd_fptc smallint, abd_ffce char(18), abh_fhgt smallint, abh_fwgt smallint, abh_fitl char(1), abh_funl integer, abh_fstr integer, abh_fchr smallint, abh_fptc smallint, abh_ffce char(18), abl_fhgt smallint, abl_fwgt smallint, abl_fitl char(1), abl_funl integer, abl_fstr integer, abl_fchr smallint, abl_fptc smallint, abl_ffce char(18), abt_cmnt nchar(254) ); CREATE UNIQUE INDEX abcatt_x ON abcattbl( abt_os ASC, abt_tnam ASC, abt_ownr ASC ) WITH (IGNORE_DUP_KEY = ON); I executed those and got "Completed successfully" I refresh the table list and I see the table named abcattbl in the list. Next I opened another tab and tried to issue following: /****** Script for SelectTopNRows command from SSMS ******/ IF NOT EXISTS(SELECT * FROM abcattbl WHERE abt_tnam='abcatcol' AND abt_ownr='dbo') INSERT INTO "abcattbl" VALUES( 0, 'abcatcol', (SELECT object_id FROM sys.objects o, sys.schemas s WHERE s.schema_id = o.schema_id AND o.name = 'abcatcol' AND s.name = 'dbo'), '', 8, 400, 'N', 0, 0, 34, 0, 'MS Sans Serif', 8, 400, 'N', 0, 0, 34, 0, 'MS Sans Serif', 8, 400, 'N', 0, 0, 34, 0, 'MS Sans Serif', '' ); And I got "Invalid object name: abcattbl" and the table name is highlighted with the red squiggly, So on one hand the table is created successfully, but trying to use it gives an error? How to override this? My system for development is dated - I;m on Win8,1 with SQL Server 2012 and SQL Server MS 11.0. I have another problems with C++ code I'm wriiting, but its different and needs another thread... Thank you,oneeyeman1Jan 04, 2025Copper Contributor29Views0likes1CommentDisaster Recovery and with existing replication
Is there any Disaster Recovery plan for SQL Server that can also handle existing replication. In this case: I have an on-premise server with 9 TB in 18 user databases and existing replication with publications from 2 user databases to multiple on-premises subscribers. I have an Azure IaaS server with an identical SQL Server install and local disk allocations. My questions are: For a Basic Backup & Restore DR plan: Can existing replication be handled. The DR server has a new name? Can you restore the distribution database to another server. Can replication continue to the existing subscribers? Or is re-initializing all replication the only option? I never seen existing replication in documented in any DR plan. Does any DR documentation factor in existing replication. I know that when I restored user database in the past to another server that had existing replication, is was impossible to clean up that replication. And a full re-initial from scratch was the only option. For an Availability Group DR plan: Would Availability Groups, and making these two servers part of a WSFC handle existing replication any better? The distribution database is a system database, and I am not sure it can be handled any better with an AG. Would a complete re-initial of any existing replication be required after a failover?SolvedDBATonyJan 03, 2025Copper Contributor36Views0likes2CommentsMoving SQL Reporting Services Native Mode
I am trying to move a SQL Reporting Services database from a 2016 server to 2022. No problem, done this many times before. But on this one the source server in Reporting Services Configuration manager shows as Native, but once restored on the new server. When I run Reporting Services Configuration manager it pops up as Sharepoint. Anyway to set it back to native mode? Please advise. Thanks! JGLongTimeGPandSLJan 03, 2025Copper Contributor23Views0likes2Comments
Resources
Tags
- Data Warehouse64 Topics
- Integration Services58 Topics
- sql server45 Topics
- Reporting Services43 Topics
- SQL36 Topics
- Business Intelligence35 Topics
- Analysis Services29 Topics
- Business Apps22 Topics
- Analytics18 Topics
- Big Data11 Topics