Microsoft SQL Server Forum

I'm not a very specialist in SQL Server 2012, but just only some hours ago something unpleasant has happened. My .mdf easy denied opening.

HI, I have developed a project for a trading Company using C# 2.0 and SQL Server 2008R2. My project is working properly. No issue regarding the code. But I am worried about one thing. Daily so many records are inserted, around 5000 above records are entered in different tables per a day. hard disk size is 1TB.

I have a SQL table with a field that has a length of 1. The field is named Status and has a value of I (inactive) or A (active). Status varchar(1). I want to show either Inactive or Active instead of just an I or A. Is this possible?

Some days ago, I tried to open database and got – SQL Server Table Corruption Error. I used SQL Server Management Studio, but it didn’t assist. What could I do for opening database?

In the source code repository of the Container Registry, the code project could not be automatically built after its name was changed in Alibaba Cloud Container Service.

About secondary partitioning on Alibaba Cloud ECS system disks and data disks. How many partitions are there after I perform secondary partitioning on a data disk and perform snapshot rollback?

When I use SFTP to log on to an ECS Linux server, I receive this error: Received unexpected end-of-file from SFTP server.

Help! Dead computer and all the information. The computer was preinstalovat formatting (otherwise cut it). With the help of file recovery programs managed to pull out SQL database files (.mdf). But on the other computer, this file does not accept. Writing error. 've tried everything. How to recover this file? Work there for 2 years.... HELP

I am writing select query with IN clause and I want data in same order which I have passed in "IN" clause. I am using SQL server 2012 as database.

My good friend asked me about problem in SQL Server 2005 database. He can't open it cause of pop up error: The header for the file 'Worker5.mdf' is not a valid database file header. I've no idea how to help to him, I'm using SQL Server 2017 and I didn't see such issue.

I have an Alibaba Cloud ECS system server (10Mbps) and another ECS database server (0Mbps). How can I install databases on the database server? The two servers are both Windows Server 2012R2. Can SQL Server 2012 be used? I can't access the database server via remote connection. What's the most convenient installation mode?

Very new to all of this, I have a simple search that shows all invoice information for a client. I need to be able to search for part of the client name rather than an exact match. In Access i know a * will wildcard a search. How do I do it in SQL here is the code SELECT dimOrganisation.Name ,dimInstructions.FILENO ...

I've tried squid, dante, and shadowsocks, but the established proxies all fail to access the VPC. However, proxies established under another classic network with the same configuration have no access problems. I'm confused. Why can't the proxies access the VPC? Please help me solve this problem. I've set the security policy properly, the proxy...

I have a table that is still SQL 2005. This table has a field defined as an int RECD_NUMBER int I want to perform a search on that field using the Like function. SELECT *

I want to replace an apostrophe with a space in a SQL field. I have tried this bit does not work: Update .. Set contents = replace(contents, ''''', ' ') where status='Destroyed' and format='L'; What am I doing wrong? Thanks

Reporting on embedded list, the report builder returns only the first item

I have an integer field that contains values from 1 to whatever. When it contains a 0 value, it means an unknown value. Can I display this in SQL Number ------- 1 24 Unknown 876 instead of this

Alibaba Cloud Container Service defines the quantity of CPU resources according to the total number of kernels of multiple nodes. For example, if there are two nodes, then the total shares cannot exceed 200. In the case of different nodes, for example, if there are two nodes with two kernels in my cluster, I can allocate a total of 400 shares to...

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 failed" After the installation was complete, the message indicated that all components were installed successfully. Please help...

If a newly created Alibaba Cloud ECS instance name does not match its instance id, the following error is reported when installing Kubernetes (if you specify Alibaba Cloud as the cloud provider): kubelet_node_status.go:73] Unable to construct v1.Node object for kubelet: failed to get external ID from cloud provider: instance not found The...

Hello, I am currently attempting a small project to create an installer to add IIS files to a Windows 2008R2 server and a SQL database to a Windows2008R2 /SQL2008R2 server instance. version of AI = 7.6.1.Our network requires the use of Windows/Domain based accounts for all SQL connectivity, as such SQL server only logins are disabled and the...

I have a question about OSS python SDK. Does a directory exists, and if so, how can I represent the directory? path_exist = bucket.object_exists('release/plugins/') I wrote the code above, but the returned result states that it does not exist.

I have attached my query. Please help me how to inserting one by one records with different tables. From that query I have to passing 3 parameter values remaining values same. Can you plz write the Java code with looping which I mentioned in attached file. Here is the contents of the file: declare tel1 number :=4152795147;

I'm novice database administrator in my new working place. I don't have any experience with sql databases. But I hope someone of local users had similar issues The header for the file 'Jio3.mdf' is not a valid database file header. And I hope you know how to handle this.

We all know about the ERR_SPDY_PROTOCOL_ERROR that only affects the Google Chrome Internet browser. It always shows This webpage is not available. Chrome users can’t access certain websites affected by this error. To solve this follow the steps:- 1. Launch Chrome browser. 2. On the corner click on three dots. 3. Go to More Tools > Clear...