Microsoft SQL Server Forum

Good day! I downloaded and installed MS SQL server Express (Advanced) x64 on Windows server 2008 R2 SP1 x64. When you try to start MS SQL Management Studio, you receive the following error message: "the operation could not be completed" After the installation is complete, the message indicates that all components have been installed...

Error was reported every time I used more than one expression in the coalesce function: FAILED: ODPS-0130071:Semantic analysis exception - Expression not in GROUP BY key : line 8:9 ''$.table'' The SQL statement is as follows: SELECT md5(concat(aid,bid)) as id ,aid , bid , sum(amountdue) as amountdue , coalesce(...

As title, can I integrate ActionTrail with CloudMonitor? Look closer, what I want to know is sending ActionTrail Logs to CloudMonitor to facilitate the real-time and historic activity logging based on user , API, resource and provides opportunity to establish alarms and notifications for anomalous or sensitivity account activity. e.g. Ensure...

Following SQL statement is running fine with VB 6.0 application while using sql server driver (SQL SERVER/SQLSRV32.DLL) but when changing the sql serve driver to (ODBC 11 driver for SQL Server/MSODBCSQL11.DLL), it is showing the error message "Could not find the stored procedure 'GO'" during execution. SQL Command is below GO Alter table test...

We can't access the https:// version of our company website. (http:// is accessible). We have looked at the certification, it is valid and working correctly. We have looked into the Bindings, it looks good. https://www.alibabacloud.com/forum/attachment/thumb/1803/thread/32_5311_05b4dc187c156b0.png...

I applied for technical support, but she has been silent for a long time. Time is running out, and I may have problems because of this. The base on which I worked hard for a month, stopped opening after the last unsuccessful editing - Error of metadata corruption. I can't do without the data from this file.

Good day! I downloaded and installed MS SQL Server Express (Advanced) x64 on Windows Server 2008 R2 SP1 x64. When you try to start MS SQL Management Studio, you receive the following error: "the operation could not be completed" After the installation was complete, the message indicated that all components were installed successfully. ...

From my understanding, in order ECS within same VPC (intranet) to communicate between them we need to put them in the same security group. By default firewall policy for inbound is deny all and outbound is allow all. Someone can verify this? My question is if there is incoming external connection to communicate with one ECS only (lets say using...

As I know the intranet bandwidth limit is 5GBps or equal to 40Gbps which is available at certain region by refering to this link: https://www.alibabacloud.com/help/doc-detail/58760.htm?spm=a3c0i.o32459en.b99.64.759c3181PyY5nq Does 5GBps is applicable for both inbound and outbound? Or just for one way traffic only.

I have noticed that sometimes the services consoles (ECS, RAM, ...) are unreachable. Error in Chrome is: "{URL} is taking too long to respond". Only the console home is always reachable. Is anyone experiencing the same? Do you have any advice to share?

I am trying to figure out the solution using co-related sub-query but somehow getting stuck with 'odd-dates' instead of # of max(concurrent users) and sessions for particular applications. Any help would be really appreciable. Below is the reference query and output snapshot:- SELECT ExtensionID, ClientCode, LoginTime, LogoutTime FROM (...

I have Webhosting. My Domain is with another company and i have set the NAMESERVERS to ns7.alidns.com ns8.alidns.com What else do i have to do?

Error trying to start MS SQL Server 2008 R2 server service ""The SQL Server service could not be started on SQL SERVER. Details are provided in the system event log. If this service is not developed by Microsoft, contact the developer of the service, and report the error code 17051 specific to this service"

I have some ECS that I created with auto-renew monthly. I want to cancel the auto-renew but dont see the option. How can I do that?

I received this article via e-mail subscription today. Good stuff! https://accessexperts.com/blog/2018/06/19/designing-a-t-sql-trigger/?utm_source=feedburner&utm_medium=email&utm_campaign=Feed%3A+accessexperts%2Ffeedburner+%28Microsoft+Access+with+SQL+Server+Tips%29

Thinking of setting up an email server for my guys in China, not sure how to do it with AC, I can get an ECS image running with postfix/courier etc, ok, but is there a better way? Does Alibaba Cloud offer a managed mailbox service that I could just use instead?

I just get an instance, how to access this instance? There no information how to find it (ip adress, ....)

what caused this error? it seems to be a failure was not, and cleaning antivirus. Database error in vBulletin 3.8.4: Invalid SQL: SELECT IF(votenum >= 1, votenum, 0) as votenum, IF (votenum >= 1 and votenum > 0, votetotal/ votenum, 0) AS voteavg, post.pagetext AS preview,

Hi, am trying to develop a .Net program using MS Sql server Using calculation in user-end made my application too slow. So I am trying to make such calculation in server and just call dataTable in use-end For this I need a sql query that is able to generate following desired View. Primary information about basic Tables are as follows. ...

I have an Ecommerce/Online Shopping site with around 2 million items(MS SQL Server DB). It has various products and i want to implement a search functionality for it. The search could be anything like "White shirt" , "Black Shoes", "Leather Belt" so on. How do i implement the search mechanism ? The site is expected to grow in years. I know...

Quick question but some background first. I use MS Access with SQL Server as my BE (tables). The main source of my new and updated records come from a linked Outlook Public Folder which get parsed with Access and then "stuffed" into their respective tables. Although this method works, it has become slow and seems a bit cumbersome. Is...

Good morning Bytes, I have posted this question in some other forums - I am casting a wide net because I need some good advice. We have recently upgraded from SQL Server 2008 to 2014 two days ago and the smoke has finally settled. I thought about making a post about the pit-falls (error 44447 and 44446) but since there are NO entries on this...

Hi All, We have a program which will generate output dynamically, after each minute, in excel files, the requirement is to upload these files to SQL database automatically. Is it possible for SQL server to pick the files from a specific folder and write the database tables after each minute? Thanks in advance.

Dear Professionals, SQL Server 2014 instance Log shipping stand by mode not working in some of the databases but no errors in backup,copy and restore jobs. i checked in Errorlog seems Error 9004 . Also Note same database working perfectly in NO Recovery Mode.

Is there any solution to import PST files from EML file format as I have many EML files which I want to convert safely in PST format.