Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x

Microsoft SQL Server

159K

Solutions

49K

Contributors

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Share tech news, updates, or what's on your mind.

Sign up to Post

We are moving a database from a Mssql 2008 server to a Mssql 2012 server. And we noticed after we brought it up that it had the previous users under the database\security\Users however, under the Mssql server's Security settings there is nothing there. Will this be an issue and will we have to recreate all the users under the Mssql server's Security settings? Also, if we do try to create a user that is currently under the database\security\Users  it says it already exists. If I remember right we had to delete it from the database\security\Users then recreate it in Mssql server's Security settings (does this sound correct?). Thanks
0
Enterprise Mobility and BYOD For Dummies
LVL 4
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

I am looking for hosting server recommendations.

Our project will involve:

ASP.NET framework
SQL Server database
Xamarin mobile app

Load Balancer
Firewall

Recommendations?

Thanks!
0
I'm running SQL Server 14 (x64) on a Windows 7 Pro (x64) computer.

I've just spent the last two days resolving issues which prevented me from uploading a CSV file into SQL Server and finally got all of the server settings and syntax correct, only to find that because I'm using the Microsoft.Ace.OLEDB.16.0 driver it will only upload 255 columns.  Unfortunately, I'm getting these csv files, many of which contain over 500 columns from a client and need to be able to read these into a SQL Server database.

So, what I need to figure out is:
1.  Can I create an SSIS package which will upload a CSV file with over 255 columns into SQL Server.
2.  Can I create a script that will allow me to pass the name of the file (varies each time) to SSIS, would then execute the SSIS package, and then return the list of column names to my calling application?
0
Hi,
I have an insert trigger that uses a CLR function to retrieve values to insert in.

If I try the insert outside the trigger, it runs fine or retrieves data using the CLR function.

But when I create a trigger with the CLR function within, get a timeout error.

Why won't it work within a table trigger?  And works just fine by itself?

Permissions issue?

Thanks

Error getting -
Msg 6522, Level 16, State 1,
System.Net.WebException:  The operation has timed out

Database - Sql Server 2008
0
Hi,

 I am trying to get output from this following query. But i got the syntax error in the left join

select CASE WHEN ipaddress like '%10.4.xx%' or ipaddress like '%10.4.xx%' or ipaddress like '%10.4.xx%' or ipaddress like '%10.4.139%'  or ipaddress like '%10.4.178%' THEN 'DEV'
 WHEN ipaddress not like '%10.4.xx%' or ipaddress not like '%10.4.xx%' or ipaddress not like '%10.4.xx%' or ipaddress not like '%10.4.xx%'  or ipaddress not like '%10.4.xx%' THEN 'PROD'

END AS is_Prod_or_Dev

,    o.hostname
,      o.ipaddress
,      CASE WHEN o.hardware_servicetag like '%000%' THEN '' ELSE o.hardware_servicetag END as hardware_servicetag
,      o.oracle_sizeofd02
,      o.oracle_spacedused_d02
,      o.is_virtual
,      o.lsbdistdescription
,      o.uptime
,      o.productname
,      o.processorcount
,      o.memorysize
,      o.appname

,   max(w.warrantyEndDate) as LeaseEndDate
,   max(m.value) as crowdstrike
,   max(n.value) as tibslastlogin
,   max(p.value) as reportdate

from oraclehosts o
left join hostwarranty w on w.hostname = o.hostname  
left join puppetdb_certname_factss p
on p.certname = o.hostname where p.fact = 'reportdate'
left join  puppetdb_certname_factss m
on m.certname = o.hostname where m.fact = 'crowdstrike'
left join  puppetdb_certname_factss n
on n.certname = o.hostname where n.fact = 'tibslastlogin'


group by
    o.hostname
,      o.ipaddress
,      o.operatingsystem
,      o.hardware_servicetag
,      o.oracle_sizeofd02
,      o.oracle_spacedused_d02
,      o.is_virtual
,      …
0
We have a SQL Server 2014 instance in our DR environment (so there is no traffic) that is restarting every half hour (just SQL Server services, not the server).  The error log in every case contains the following error just before shutdown: E:\TempDB\templog.ldf: Operating system error 112(There is not enough space on the disk.) encountered.
However, there is more than enough space on the disk which is currently only half full.  I am able to shrink and grow any of the tempdb files without issue.
I tried shutting down SQL Server, deleting the tempdb files, restarting SQL Server.  The tempdb is successfully rebuilt (indicating it is not a permissions issue) then it gets the same error next time it reaches the original half hour mark. (the "timer" is not reset when SQL Server restarts).
I thought it might be that specific disk so I moved tempdb to a different disk but didn't create any files.  Restarted SQL Server.  Tempdb was rebuilt successfully but it errored again at the original half hour mark.
I had our VMWare expert look at it.  He rebooted the server.  The only thing that accomplished was it reset the "timer" so the restart occurs at a different set of half hour marks.
There are no SQL Agent jobs running.  There is no user activity at all other than me trying to figure this out.  
Has anyone encountered a similar issue?  Any ideas what could be causing this?
0
Good Afternoon,

I am having an issue attempting to add the sa account to one of my databases within SQL Server.

For about 2 years now we have been using a server for Mcafee ePolicy Orchestrator (ePO) with the database saved on the same box using SQL Server 2008 R2. Everything has been working fine including the SQL Server Maintenance Plan.

Just recently we changed our networks domain name and thought we made all the necessary adjustments to reflect the new name, with the user accounts etc. However while our ePO server is functioning correctly, we’ve noticed that the SQL Server Maintenance plan is not, as the sub plans are failing.

SQLError
The log is showing SQL Server Error: 15404, the user name we see being used for the plan is the old domain account (OLD_DOMAIN\Administrator), which has since been removed and the new account added (NEWDOMAIN\Administrator).

Upon researching this issue on the net, I’ve read that maintenance plans should really be using the ‘sa’ account and that there is a bug in SQL Server which sometimes does not allow another account to be used. Which at first I found odd because I was using another account for the maintenance plan before we changed the domain name and it was working fine for all of that time.

Anyways, so I attempted to map the ‘sa’ account to the database for the maintenance plans but am unable to do so and receive the below error.

sa mapping
sa mapping error
Below are the …
0
I am looking for idea. I need to grab locations , some of the lcoations have the same name but different locationID.

I need to create a location drop down with a unique locations. And then do the search by these locations. The question  is if I do make a drop down of unique locations thne in my search I will be searching by name instead of locationID
0
Hi Experts

In SQL I have this:
(Cast( SUM( Case when ActionableResult = 0 THEN 1 ELSE 0 END)  as float) /Count(*)) *100 as PercentCompliant

Open in new window


Which comes out good on the column in SQL
Example:
Pass/All
364/4425 *100 = 8.225988

But in SSRS:
I get 822.60%

I have tried:
=Fields!PercentCompliant.Value
=Sum(Fields!PercentCompliant.Value)
even:
=(sum(Fields!Pass.Value) /sum(Fields!All.Value) * 100)
=(Fields!Pass.Value /sum(Fields!All.Value) * 100)


What am I doing wrong?

Please help and thanks
0
I have created a package that uses CDC. We are running SQL Server 64 bit Standard Edition. We have applied SP 1 to release the functionality of CDC for  the Standard edition.

Debugging in BIDS works fine, but when running on the server via schedules task, we get the following error:
CDC Control Task cannot run on the installed version of Integration Services. It requires Enterprise Edition or higher.
Anyone know a way around this?

Any help would be appreciated

Thanks
0
Survive A High-Traffic Event with Percona
LVL 3
Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

Hi

Is there any simple way to configure Sybase Adaptive Server Enterprise PC Client 15.7 .0.8 on MS SQl 2014 server?

Please advice, M
0
I need to make SSRS 2012 reports available to users on a mini ipad.
What would be the best way to implement?
0
Hi EE,

I have the error occurring on 1 of the SQL agents on SQL server. I have tried the steps in the following post:

https://blog.sqlauthority.com/2015/08/19/sql-server-login-failed-for-user-reason-token-based-server-access-validation-failed-with-an-infrastructure-error/

No luck.

Any suggestions as always all assistance is welcome.

Thank you.
0
I have a query, when I try to run it commenting a logic defined below, it runs fine.

But I need to include this logic and run the query, the query is taking hell lot of time. 2 hours for 1 lakh record.

PLEASE HELP ME CHAMPIONS.


SELECT
--CASE WHEN (select distinct  1
--from TBL c            
--where EXISTS (SELECT 1 FROM TBL1 leave            
--               WHERE convert(date,c1.DT) = leave.DT
--                 ))
--IS NOT NULL THEN 1 ELSE 0 END AS LEAVE

FROM (select *,
case when test= 'A' then DATEADD(hour,8,Date)  
     when test=  'B' then DATEADD(hour,2,Date)  
     when  test= 'C' then DATEADD(hour,-4,Date)
     else Date end as DT

 from STAGING c
 ) c1
0
I have jobs running in two different servers, using a query or SP I want to know if any of these jobs are running on these 2 servers.

How can I achieve it ?
0
Hi All,

In a table I have a date column, I want to calculate Month and Quarter start days and End days dynamically whenever I load the table or append new records. I have attached the excel on the same. In the sample I have given a series of sorted date but in my actual, it is not sorted.
Month-Quart-Start-End.xlsx
0
Hi,
I need to create a report in SharePoint 2013 , on premises , There is a custom SharePoint list which has username, Manager and Status. say it SPLIst
I have created another SharePoint list as external content type using SQL procedure which returns all all active users. In this second list say DBList I have username and their department.
My requirement is , I need to compare the two lists and whoever is not found in SPList, should be marked as "Not Started".

Could you please help me to achieve this?

Thanks in advance.
Azra
0
i have a asp.net mvc application.

I'm using the Employees table of the SQL Server Northwind database

My table looks like this:

table
Right now my dropdownlist displays  the EmployeeID

My razor code on my view looks like this:

@Html.DropDownListFor(model => model.EmployeeID, "Please Select an Employee: ", new { @class = "employeeclass1", @id = "EmployeeDDL" })


How do i set the default value on page load for my DDL to be 0?
How do I add a "ALL" text to my DDL so if someone selects that then the selected value for that is -2.

So then the only options my DDL would have are:
"Please Select an Employee:"  and the default selected value for this would be 0
"All" and the selected value for this would be -2
The other choices they would have are EmployeeID 1 through 9 which I already have and come from my model.
0
Hi,

I have delphi10.
And during insert procedure in MSSQL, sometimes I get exception...

Access violation at address 5D3CD9A2 in module  MSADO15.dll. Read of address 00000000.

Can somebody help...

Thank you
0
Nothing ever in the clear!
LVL 1
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

We are having an issue on our SQL server where jobs that send out a lot of emails send some emails but not all of the them.  In going through the logs the emails are sending fine and report 'Mail successfully sent' and then all of a sudden the error comes up with 'The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2017-09-18T12:16:43). Exception Message: Cannot send mails to mail server. (The operation has timed out.).).  It seems to fail at different intervals.

On the failure emails, the last_mod_user in the sysmail_event_log is 'sa' and the account_id is NULL.  However, on the successfully sent emails, the last_mod_user is 'DOMAIN\Administrator' and the account_id is 1.  It almost appears as if the Administrator looses connection and then the mail starts failing thereafter.

The same activity seems to happen regardless of running the proc manually or having the agent job initiate it.

The mail settings are (we use AuthSMTP.com to send):

Server Name: mail.authsmtp.com
Port: 2525
SSL: required
Basic Authentication with our AuthSMTP credentials.

Database Mail Executable Minimum Lifetime (seconds) = 600

Does anyone know why this would occur?  

Thank you.
0
Hi All

My Company is implementing SFB 2015 Ent Edition. We have 2 SQL Servers in cluster. The SQL Servers is easily getting connected through SSMS via cluster. But when I am trying to publish the topology it s giving error. Please find below the error:

****Creating DbSetupInstance for 'Microsoft.Rtc.Common.Data.XdsDatabase'****
Initializing DbSetupBase
Parsing parameters...
Found Parameter: SqlServer Value dccluster.gsi.gov.in.
Found Parameter: SqlFilePath Value C:\Program Files\Common Files\Skype for Business Server 2015\DbSetup.
Found Parameter: DatabaseType Value .
Found Parameter: FeatureName Value CentralMgmtStore.
Found Parameter: DatabaseNames Value System.Collections.Generic.List`1[System.String].
Found Parameter: Publisheracct Value GSI\RTCUniversalServerAdmins.
Found Parameter: Replicatoracct Value GSI\RTCUniversalConfigReplicator.
Found Parameter: Consumeracct Value GSI\RTCUniversalReadOnlyAdmins.
Found Parameter: Role Value master.
Trying to connect to Sql Server dccluster.gsi.gov.in. using windows authentication...
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidOperationException: Cannot open Service Control Manager on computer 'dccluster.gsi.gov.in'. This operation might require other privileges. ---> System.ComponentModel.Win32Exception: The RPC server is unavailable

Please help to solve the error. All firewall service is disabled in all servers and we are using …
0
I am try to connect conquestdicomserver with sql Server 2008 R2 manually and also trying to editing "dicom.ini" file.. but this is not working..

Any One can help me..please.... Thanks in Advances

Here is DICOM.INI file code .

i am using window32

Sql Server Name :- GMDahri-PC
databse    Name :- conquest
login         Name :- conquest
password            :- conquest1415
sa                        :- 123




# This file contains configuration information for the DICOM server
# Do not edit unless you know what you are doing

[sscscp]
MicroPACS                = sscscp

# Network configuration: server name and TCP/IP port#
MyACRNema                = NICVDPACS
TCPPort                  = 5678

# Host(ignored), name, username and password for ODBC data source
SQLHost                  = localhost
SQLServer                = conquestpacs_s
Username                 = conquest
Password                 = conquest1415
DoubleBackSlashToDB      = 0
UseEscapeStringConstants = 0

# Configure server
ImportExportDragAndDrop  = 1
ZipTime                  = 05:
UIDPrefix                = 1.2.826.0.1.3680043.2.135.736588.40949073
EnableComputedFields     = 1

FileNameSyntax           = 4

# Configuration of compression for incoming images and archival
DroppedFileCompression   = un
IncomingCompression      = un
ArchiveCompression       = as

# For debug information
PACSName                 = NICVDPACS
OperatorConsole          = 127.0.0.1
DebugLevel…
0
Hello everyone!

I am running with TFS 2015.3, and SQL Server 2016 SP1, in separate servers.

Recently, I change our production TFS Database from 32 bit to 64 bit (for updating purposes), and I believe we loose some database configuration and permissions.

This week (after the change), we are having some issues with some Jobs, related to Warehouse and Coverage Analysis:

-Work Item Tracking Warehouse Sync
-Test Management Warehouse Sync
-Team Foundation Server Coverage Analysis

The error that is shown is:

Microsoft.TeamFoundation.Framework.Server.DatabaseOperationTimeoutException: TF246018: The database operation exceeded the timeout limit and has been cancelled. Verify that the parameters of the operation are correct. ---> System.Data.SqlClient.SqlException: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception: The wait operation timed out --- End of inner exception stack trace --- at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)…
0
Hi,

I have a requirement daily database refresh at 4.00 am and i schedule this job, now need to download .bak file from ftp site daily basis so that SQL job can restore the .bak file from local drive.

Please help!
0
As per the limitation of Amazon RDS not being able to do Distributed Queries (i.e. Linked Servers) to OnPremise MSSQL host (as per https://aws.amazon.com/blogs/database/implement-linked-servers-with-amazon-rds-for-microsoft-sql-server/ documentation), I want to know if its possible to setup something of a 'reverse proxy' for allowing a MSSQL RDS instance, connect to said proxy and send SQL calls to an OnPremise SQL host instead?

As per Amazon support -- "It’s an internal IP resolution and routing issue.  When the SQL Server is inside a VPC, the SQL Server isn’t able to use the customer provided DNS entries. This causes DNS lookup failure.  Additionally, the server’s routing tables don’t allow the server to see the customer’s VPC Gateway meaning, there’s no routing path for traffic back to your on-prem servers even if lookup succeeded (or used IP addresses). // If the IP address doesn’t appear in the VPC, we will not route the traffic through the correct network interface, and on-premise database servers would fall into this category." (As per support as well -- "There’s an open enhancement request to fix this but honestly, it’s pretty old and hasn’t gotten much traction for prioritization.")

To get around the limitation of what Amazon has done with the internal IP resolution / routing, primarily with RDS and the TDS Protocol outside of a VPC, I would like to 'trick' the Amazon MSSQL RDS instance into thinking that it is communicating with a Windows EC2 instance running…
0

Microsoft SQL Server

159K

Solutions

49K

Contributors

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.