SSIS trace end of iteration in container - In SSIS I have a container with a few tasks inside. The container iterates through a rowset or files (does...
sysdatabases vs sys.databases - Currently we have a query that re-indexes all databases but fails when it gets to a "read-only" database since it...
Deadlock with two update statements - Hi Guys, I am getting a deadlocks recently on one of my instance of SQL Server. Below are the two statements...
Uninstallation Logs - Hi All, Is there any way we can find who has uninstalled SQL Server. I have checked Windows logs but could not...
Help with SQL Loop Query - Hi Guys, I am using below While Loop Syntax but for some reason, I can't update the records or it...
Still driving me nuts: selecting several timelines from several lines from multibale tables - So, I called in your help a week ago on this post: https://www.sqlservercentral.com/Forums/1869218/Driving-me-nuts-selecting-valid-timelines-from-several-lines-in-a-table It helped me out for a first part, but...
Database mail error - SQL Server 2012 . I have set up a profile and account. use msdb GO EXEC
Giving Access to Only One View - I have created a user and a server role and assigned the role to the user. I can now connect...
Index analysis is not working in my SQL sentry tool , Any experts ? - Index analysis is not working in my SQL sentry tool , Any experts ?
creating new partition files on table - hello all, I have a table that has 2,948,231,398 billion rows...I know...last week I had to figure out how to...
SQL Server core usage - Hi all I've been doing a bit of a check on some our servers and found something odd in the logs. I've...
Convert name field from Colunm1: FirstName LastName to Column2 as LastName, FirstName - I have a column FullName with data as follows: John Doe Joe Doe Jane Doe I want a result in a new...
INSERT INTO, EXCLUDING ONE COLUMN - Hi Is there a way I can: INSERT INTO TableA SELECT * FROM TableB but exclude one column from TableB? My TableB has ID which is...
database not restoring to original physical names ndf files in backup - Hi All, I have a backup db and running RESTOREFILELISTONLYFROM
Is High availability group the way to go? - Hello, We have developed four azure databases. As we are planning the production environment, I have been given some requirements. 1. Highly available. 2. ...
parameters list: Allow multiple values not working - I have a parameters (drop down list) containing all text values that I built by manually providing the values in...
Carriage return in sql is not working when exporting to SSRS - This is just a part of my sql function. I am inserting carriage return for getting next line behaviour. But...
XQuery error - I am trying the following: declare @packXML XML = '<Pack> <PackID>1</PackID> <Item> <ItemNumber>1</ItemNumber> <Qty>1</Qty> </Item> </Pack> <Pack> <PackID>2</PackID> <Item> <ItemNumber>1&
SSIS 2016 Installation fails - Hi Folks, I have an installation of SQL Server 2016 CTP3 on my laptop, a Windows 10 machine, as a test...
Insert PowerBI graph into Powerpoint - Inserting Excel objects into PowerPoint is easy... Any idea how to insert a PowerBI graph in there? Don't know if...