.Net SqlClient Data Provider Queries "Stuck
We started to notice that a bunch of client-side exe apps that run simple SQL queries (Insert, delete) are stuck. When we copy the query and run it manually it completes in seconds, but it seems like all these jobs are stuck. Any ideas why and/or what…
Visual Studio C# 2012, MS Sql Server Express 17
OK Folks, I've been developing code in Visual Studio C# V12, using MS Sql Server Express V2017 for a year. -No Problems. Code compiled, and I could test and deploy code. -I added a database in MS Sql Server Express V2017 -total unrelated to my…
BCP date format
I am attempting to import data using bcp. The data contains dates formated as Jan 03 2019 12:00:00:00.000000AM. BCP rejects this data, saying this is an invalid date format. I believe BCP expects a date formatted as 2019-01-03 12:00:00:00.000000. …
How to Process Cubes on Different Server?
Hi guys, I am trying to process SSAS cubes on server"B" by kicking SSIS on server"A" with the EffectiveUserName option. The job executing user is an AD user whitch has admin authority on both server "A" and…
Heterogeneous Logreader encountered an error in call to LoadReplCmds when processing state 'SYNCINIT_FETCH'
We are having a Oracle as Publisher and distributor and subscriber is SQL SERVER. My Log reader Agent is getting failed showing below error : Error messages: Query timeout expired (Source: MSSQLServer, Error number: 0) Get help: http://help/0 …
MDX code to get today's date
Hello, I created a query for Excel in Power Pivot using the visual designer. I currently have to change the dates every month. I need to modify it so it automatically returns the data for January from the current year until the current month. …
Global variables using in other forms
I am making a software i want a global variable so that i can use across one form to other so basically i want to call roll no. that is written in an event datagridview row header event: Roll_No =…
Database trigger and there is login fail on the sql errorlog
I have the following trigger database trigger and then there is a error in the errorlog why is that ?
Index Optimization job stuck - Sql 2008R2
Hello, We have Sql 2008R2 and we are running Index Maintenance job (Index optimization) part of Ola's maintenance Solution but during job was running and Sql server Shutdown/Restarted and job still showing as in 'Progress'. This is a Sql Agent job we…
SQL Server 2019 Highly Available Cluster - Setup
I have a Hyper-v Cluster and would like a recipe for adding a highly available SQL role
SQL Server 2014 table compression
Hello, planning on running a SQL Agent Job to compress some Prod Tables which looks like will take a couple of hours to finish. Is it correct to say that during this Tables (only) compression job just the target tables will be unavailable/locked and…
MECM/WSUS - SQL option collocate or remote SQL?
Hi All Wanted to bounce my thoughts with fellow members. I am about to embark on a mini project for a customer. It's for a small experiment and a new network and infrastructure environment will be created on-premises. Unfortunately for this piece of…
Updating a table based on values in the table
I have a temp table #XX that looks like this" ID KWID NAME ORDER 1447 1144 SW_6368_58_55.png NULL 1450 1145 SW_6942_58_55.png NULL 1451 1147 Arb3_43_55.jpg NULL 1452 1147 Arb1_43_55.jpg NULL 1453 1147 Arb2_43_55.jpg NULL 1598 1152…
Actual Execution plan for query store
is it possible to capture actual execution plan inside query store ? or else need to use back xevent ?
Test if any SQL Server related questions already exist
I checked all 4 forums under SQL Server and I see 0 posts. However, I think I saw a thread somehow where I saw Uri has an answer. How come I don't see any questions in relation to SQL Server?
SQL Server Reporting Services -- Deploying report fails -- The operation has timed out
HI All, I am getting an error today that I have not received before. When using Visual Studio to deploy a report to my SSRS 2017 Report Server, I am getting the error "The operation has timed out." I am using SSDT and Visual Studio…
SSRS - STORED PROCEUDURE WITH TABLE VALUED PARAMETERS
Hi, How can we use Stored Procedure with Table Valued Parameter in SSRS Dataset ? CREATE TYPE DBO.MultiFilter AS TABLE ( filterVal VARCHAR(200) ) CREATE PROCEDURE DBO.USP_multiFilterTest @position DBO.MultiFilter READONLY …
Lookup do not bring amount
Hello There I have to datasets one for expenses and one for revenues, it is partially working because the lookup is bringing one value from the datasource therefore I am out balance. The money is sitting there but my lookup is not bringing both…
Description=[Microsoft][ODBC SQL Server Driver] [SQL Server] Invalid object name 'databaseproperty'
Hello, A good friend of mine runs a tech support business from his home and is in the hospital for an unforeseeable amount of time. I've run a disk repair for his son but whatsup isn't loading properly (i kept poking at it and admit every time I fix…
Managing MDF Files
I have a database MDF file with 800Gb, and the disk is almost full. I'd like to get the best practice to grow create new files to my database. So, I have some options to do this: Create a new drive, create a new MDF file with autogrowth, and…