Your search for "title" returned 100 results:
I am new to data warehousing and SSAS, so forgive me if the answer is kicking me in the face. I am attempting to create a cube from a relational data source and one of my dimensions is giving me a headache over the namecolumn property of one of my attributes. The abbridged data source […]
2008-07-28
106 reads
I currently have SQL2k8 R2 Reporting services on client machine (Windows 7). I created and deployed reports on this machine. Everything works perfect. I need to move everything to Server machine (W2k8 R2). I installed SQL2k8 R2 and copied the solution have that I have on client machine. I can open rdl files on server […]
2013-03-21
5,908 reads
Hi, I need help to deploy the reports on report server. I have the following below given error. TITLE: Microsoft SQL Server Report Designer ------------------------------ Could not connect to the report server http://localhost/ReportServer. Verify that the TargetServerURL is valid and that you have the correct permissions to connect to the report server. ------------------------------ System.Web.Services.Protocols.SoapException: The […]
2012-06-05
4,804 reads
Hi, I have one SSIS packages, everything is fine, but I just want to find what is the reason for the below error. Earlier to this error I added one filtercondition in the sql command. please find the details as below. Thanks in advance, Prabhu
2014-08-18
3,157 reads
Hi, I need some help with a function - well 3 actually - to pull out the require parts of a string. I have a field called strFiDesc_FD that contains customer names in the format "LastName FirstName Title" all separated by a space. I can work out how to get the LastName and FirstName, but […]
2006-03-04
27 reads
I move a SSIS database and other user databases from SQL server 2017 to a new server 2019. Other databases work fine. SSISDB does not work as expected. I restore the SSIS database and master key, successfully. But When I try to run database upgrade from SSMS by right click SSISDB Database upgrade I got […]
2020-06-29
4,016 reads
Good afternoon ladies and gentlemen. We recently set up our first SQL2005 test box in house and began slowly restoring old SQL 70 databases to this machine for testing. Everything was working fine as of last week. However, this week I went in to change the compatibility mode on one of the databases and received […]
2006-04-03
2,624 reads
Hi, I am trying to write a SQL statement to find related videos in a video site for a particular video. The TAG terms under a video goes as a query to this SQL statement to find related videos. Following SQL statement returns only the same video (single video) that has the exact tags. How […]
2008-03-20
1,881 reads
I have 3 tables - Book, Author, BookAuthorReference A book can have multiple authors, and when I do straight query I get multiple rows per book SELECT <columns> FROM Book b, Author a, BookAuthorReference ba where ba.BookId = b.BookId and ba.AuthorId = a.AuthorId I want to get the results as ONE row per book, and […]
2015-01-10
42 reads
Hi Full message below but basically I have tried all the DCOM things in this article and still no joy https://social.msdn.microsoft.com/Forums/sqlserver/en-US/8833d78b-a4c9-4743-ad0b-a3d17bdd3598/connecting-to-ssis-through-ssms-without-built-in-administrator?forum=sqlsetupandupgrade Using Windows Server 2012 & SQL Server 2012 Enterprise I'm a Domain Admin and SQL sysadmin so not sure what the issue is. Any help greatly appreciated. Rich TITLE: Connect to Server ------------------------------ Cannot […]
2016-03-23
4,246 reads
A couple of weeks ago, a developer came to me and wanted to know...
By SQLPals
Database Property LastGoodCheckDbTime to Get the Last Successful DBCC CHECKDB on a Database As one...
When you develop data pipelines in Microsoft Fabric (the Azure Data Factory equivalent in...
Comments posted to this topic are about the item Baseball Everywhere
I am working on a small test script on SQL server 2022 using python...
Upgrade to SQL2019 from 2012 Query is taking time, Need Query Optimization steps and...
I want to use the ADD SENSITIVITY CLASSIFICATION DDL to mark some columns in my SQL Server 2022 database as PII. Can I use this code?
ADD SENSITIVITY CLASSIFICATION TO dbo.sales.price,
dbo.sales.discount
WITH (
LABEL = 'Highly Confidential',
INFORMATION_TYPE = 'Financial',
RANK = 'INTERNAL ONLY'
); See possible answers