Ask Question

Community
SQL Server

SQL Server Questions & Answers

Get a modern-day SQL Developer Training that will help you learn the basics of database querying, Microsoft SQL and the best-practices of Database Management to gain confidence with our Online SQL Certification and surmount a trending career field

1.4KDiscussions

1.7KAnswers

0Waiting for an answer

Ask a SQL Server Question →

What is the best way to quickly and effectively drop a database and delete all files?

If I set a Microsoft SQL Server database to offline and drop it, it will be deleted, but the log and data files will remain. If I do it in online…

SQL Server

1 Answer · 1.2K Views · Answered ✓

Asked by: Abhishek Shukla · 5 years ago

How can I solve SQL Server EXECUTE AS trouble?

I'm missing something while trying to make my stored procedure use EXECUTE AS. The stored procedure is reading data from source_db, aggregates it and…

SQL Server

1 Answer · 1.3K Views · Answered ✓

Asked by: Ankesh Kumar · 5 years ago

Following up on my comment, you have to select ENU\x64\SQLEXPRADV_x64_ENU.exe to solve sql server reporting services 2012. Then run the installation package and follow instructions until you get the feature selection page. Follow the rest of the steps and complete the installation. Now Verify the RS installation : Note: You must be logged in as a member of the local administrators group on the computer where SQL Server 2012 Express is installed. Navigate to Start -> All Programs -> Microsoft SQL Server 2012 -> Configuration Tools -> Reporting Services Configuration Manager. In the RS Configuration Connection dialog, make sure that your local report server instance (for example SQLExpess) is selected and click Connect. In the RS Configuration Manager left pane, select Web Service URL. Make sure that the Virtual Directory parameter is set to ‘ReportServer_’ (‘ReportServer_SQLEXPRESS’ for the SQLEXPRESS instance), and that the TCP Port is set to 80. Click Apply. In the Reporting Services Configuration Manager left pane, select Database. On this page, ensure that the SQL Server Name and Database Name fields contain correct values. If not, click the Change Database button and complete the Report Server Database Configuration wizard. In the Reporting Services Configuration Manager left pane, select Report Manager URL. On this page, ensure that the Virtual Directory parameter is set correctly, and that the URL is valid. Click Exit to close the RS Configuration Manager. Well, I hope my answer helps you!

From this Microsoft doc,+ n defines the string length and can be a value from 1 through 8,000. max indicates that the maximum storage size is 2^31-1…

SQL Server

1 Answer · 644 Views · Answered ✓

Asked by: Ben PHILLIPS · 5 years ago

What is the best solution for 'CONCAT' is not a recognized built-in function name?

A client reported that they were running on SQL Server 2012, and we delivered some test queries for testing prior to a final delivery,…

SQL Server

1 Answer · 8 Views · Answered ✓

Asked by: Brian Kennedy · 5 years ago

Step 1: Log In with Remote Desktop Step 2: Run Microsoft SQL Server Management Step 3: Checking the Server Authentication Mode Step 4: Restart the SQL Service Step 5: Checking SQL User Permissions Step 6: Mapping the User to the Database

I am working on a live SQL Server database. It was just recently migrated from another server. In the old server, the backup was done using a job…

SQL Server

1 Answer · 5 Views · Answered ✓

Asked by: Anna Ball · 5 years ago

How to Use Table-Valued Parameter as Output parameter for stored procedure ?

Is it possible to Table-Valued parameter be used as output param for stored procedure ? Here is, what I want to do in code/*First I create MY type */…

SQL Server

2 Answers · 3.3K Views · Answered ✓

Asked by: Aswini Lobo · 5 years ago

How to use SQL server foreach loop?

In powershell I use foreach to run a function through a list of targets. I was wondering that if there is any thing similar to foreach in sql, so I…

SQL Server

1 Answer · 1.1K Views · Answered ✓

Asked by: Caroline Brown · 5 years ago

Communications link failure: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException

want my database to communicate with my java programs Can anyone provide me with a sample program using JDBC? I’m getting an error…

SQL Server

1 Answer · 3.1K Views · Answered ✓

Asked by: Aaditya Srivastva · 5 years ago

[rejected] master -> master (fetch first) - Git Giving “fetch first” error when trying to push

I am having my first introduction to git through a class I am taking. I have a number of files in a directory on my computer and am able to stage and…

SQL Server

1 Answer · 8.8K Views · Answered ✓

Asked by: Dominic Poole · 5 years ago

git fetch all branches- How to fetch all Git branches?

I cloned a Git repository, which contains about five branches. However, when I do git branch I only see one of them:$ git branch* masterI know that I…

SQL Server

1 Answer · 1.5K Views · Answered ✓

Asked by: anu rhea · 5 years ago

Conditionally Remove Dataframe Rows with R

Using R, how can I write the following logic into the data frame: IF column A = B and Column E = 0, delete row.Using R, how can I write the following…

SQL Server

1 Answer · 1.2K Views · Answered ✓

Asked by: Graham Cook · 5 years ago