| |
thread by: hardness |
last post Apr 27 '18 by: abeLuna
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...
|
thread by: TimoHa |
last post Apr 24 '18 by: Andrea1701
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(...
|
thread by: IvanH |
last post May 14 '18 by: Andrea1701
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...
|
thread by: AshuD |
last post May 13 '18 by: AshuD
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...
|
thread by: Andrea1701 |
last post May 18 '18 by: IvanH
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...
|
thread by: ImogenPearce |
last post Jun 29 '18 by: LeslieBarrera
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.
|
thread by: dromond |
last post May 28 '18 by: bathtub
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.
...
|
| |
thread by: Andrea1701 |
last post May 24 '18 by: TimoHa
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...
|
thread by: TimoHa |
last post May 25 '18 by: Andrea1701
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.
|
thread by: Andrea1701 |
last post May 25 '18 by: Andrea1701
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?
|
thread by: DSal |
last post Jun 6 '18 by: DSal
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 (...
|
thread by: IvanH |
last post Mar 24 '19 by: Mekas
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?
|
thread by: psammite |
last post Jun 27 '18 by: goshawk
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"
|
thread by: TimoHa |
last post Jun 21 '18 by: IvanH
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?
|
thread by: Nauticalgent |
last post Jun 20 '18 by: Nauticalgent
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
|
| |
thread by: TimoHa |
last post Jun 25 '18 by: Andrea1701
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?
|
thread by: Andrea1701 |
last post Jul 12 '18 by: Andrea1701
I just get an instance, how to access this instance? There no information how to find it (ip adress, ....)
|
thread by: rangelmaria451 |
last post Jul 27 '18 by: psammite
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,
|
thread by: Gobindap |
last post Jul 12 '18 by: Gobindap
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. ...
|
thread by: mishaq |
last post Jul 23 '18 by: mishaq
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...
|
thread by: Nauticalgent |
last post Jul 28 '18 by: Nauticalgent
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...
|
thread by: Nauticalgent |
last post Aug 4 '18 by: Nauticalgent
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...
|
thread by: Botham Ruosh |
last post Nov 29 '18 by: nitish7503
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.
|
| |
thread by: sathish SQLDBA |
last post Nov 2 '18 by: sathish SQLDBA
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.
|
thread by: dannymaros |
last post Nov 26 '18 by: dannymaros
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.
|