sql-server-2014 Questions
9
I'm using SQL Server 2014 and having a problem.
In Task Manager, on Services tab, I found SQLAgent$VILLBE_SQLSERVER (VILLBE is my computer name), right click and Start.
It started and... stopped ...
Holophytic asked 28/3, 2015 at 14:5
4
Solved
We recently migrated from SQL Server 2012 to SQL Server 2014 and all our FOR XML code started throwing errors about non-printable ASCII characters.
I wrote this horrible function to remove non-prin...
Zimmermann asked 31/3, 2017 at 19:59
4
Solved
This might be a very basic question but I just came over it while writing a query.
Why can't SQL Server convert a check for NULL to BIT? I was thinking about something like this:
DECLARE @someVar...
Downstage asked 27/4, 2016 at 11:36
4
Solved
This is my scenario.
SQL Server 2014 Standard edition, I have a database with a collation SQL_Latin1_General_CP437_BIN2 which is case sensitive.
I want to perform a LIKE query which should retur...
Hereby asked 19/10, 2015 at 12:5
9
I am using SQL Server 2014. I am currently trying to combine millions of personnel application records in to a single personnel record.
The records contain the following columns:
ID, First_Name,...
Kerwinn asked 22/8, 2018 at 14:20
3
Solved
I want to assign database name into the declared variable and this is how I tried already:
DECLARE @DBname VARCHAR(100)
SET @DBname = 'PatientTurningSystem'
SELECT TABLE_NAME, TABLE_TYPE
FROM @D...
Comras asked 16/5, 2018 at 6:26
4
Solved
While attaching my .mdf file on my SQL Server database I am getting below error message:
Msg 5120, Level 16, State 101, Line 1
Unable to open the physical file
"C:\Program Files\Microsoft SQL ...
Lampkin asked 25/12, 2015 at 5:9
4
I've created the structure of my database first in PhpMyAdmin and exported it to a .sql file.
Now I'm looking everywhere in SQL Server Management Studio where I can import/add the data in a new dat...
Pled asked 18/3, 2014 at 19:18
4
Solved
Summary: The EXEC sp_executesql @code fails for the content longer than 4000 in the @code, but the @code is not truncated to 4000 unicode characters.
I am observing the problem on SQL Server 2014 ...
Pumpkin asked 29/9, 2016 at 13:16
3
I have a long stored procedure which begins with the following statement:
IF NOT EXISTS (SELECT * FROM sys.databases WHERE name = N'DBNAME')
BEGIN
CREATE DATABASE [DBNAME]
END;
It is expected...
Eindhoven asked 28/11, 2016 at 6:39
4
Solved
I have locations in longitude and latitude coordinates. My goal is eventually to be able to select all rows from myTable Where distance is less than 2km.
How can one use the longitude and latitud...
Sublapsarianism asked 19/5, 2015 at 10:23
1
Solved
I am trying to concatenate comments field per ID separated by ';' from multiple rows into one per ID in SQL Server 13. For the same, I'm using the below query:
--table1 in the table name;
--elemen...
Placia asked 17/4, 2020 at 6:29
7
Solved
Were there any changes in this area with SQL Server 2014? I’ve seen this post Is it possible to restore Sql Server 2008 backup in sql server 2005 and I know that this was not possible as a scenario...
Villeneuve asked 19/7, 2013 at 10:31
6
Solved
I created two tables:
Table tblStaff with columns id (primary key, auto increment), name, age, address
Table tblRoleOfStaff with columns id (primary key, auto increment), StaffId (foreign key to ...
Cassatt asked 19/6, 2016 at 16:19
4
Solved
I have following problem: When I try to deploy my SSAS project (with cube, dimensions and all that jazz) to sql-server, it throws error saying that
You cannot deploy the model because the DB de...
Zsolway asked 7/4, 2016 at 18:6
3
Solved
Why this doesn't work and gives me a "Incorrect syntax near offset command" error
SELECT o.orderdate, o.orderid, o.empid, o.custid FROM Sales.Orders o
ORDER BY o.orderdate, o.orderid
OFFSET 50 ROW...
Social asked 16/2, 2017 at 2:55
5
I am using Visual Studio 2017 and SQL Server 2014. While attaching a database file to Visual Studio, I get this error:
""
After upgrading the file I used this connection string
<connectionStr...
Percentile asked 26/9, 2017 at 15:58
3
Solved
I am trying to attach database file in SQL Server. I am getting the below error. The same error I am getting while trying to attach database from Visual Studio. I am using Visual Studio 2013 and SQ...
Fachanan asked 30/4, 2016 at 6:52
1
Solved
I am building a multidimensional cube using SSAS, I created the partitions based on a date column, and defined a partition for each day. Source data size is bigger than 2 TB.
While deploying and p...
Grindstone asked 23/7, 2019 at 12:2
2
I am trying to grant a user access to export data from SQL Server into an Excel file using OPENROWSET.
The user is getting the following error:
Cannot initialize the data source object of OLE D...
Legg asked 18/6, 2019 at 19:44
2
I've set up a SQL Server service account with permissions to read and write service principal names. When SQL Server starts up I get the expected message in the logs showing that the service accoun...
Chrysalis asked 20/5, 2019 at 9:3
1
Solved
I am working with 2 star schema data warehouses, each data warehouse contains a fact table and the dimensions tables are located in separate databases (one database used by both data warehouses).
...
Balanchine asked 18/3, 2019 at 11:38
3
Solved
I recently upgraded our SQL Server from 2005 to 2014 (linked server) and I am noticing that one of the stored procedures which calls the exec command to execute a stored procedure on the upgraded l...
Prefabricate asked 4/3, 2016 at 15:34
1
Solved
If I have a table like so:
CREATE TABLE MyTable
(
Id INT PRIMARY KEY IDENTITY(1, 1),
FooId INT NOT NULL FOREIGN KEY REFERENCES Foo(Id),
Data NVARCHAR(10) NOT NULL
);
The following observatio...
Beverie asked 23/2, 2019 at 9:7
1
I am trying to link two SQL Servers (2008R2 and 2014) which are running in two separate (!) Active Directory domains.
The problem is that I can login into the remote server only with a Windows Ac...
Exhaustive asked 12/12, 2015 at 12:57
© 2022 - 2024 — McMap. All rights reserved.