Your search for "title" returned 100 results:
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,871 reads
I an trying to enable transactional replication on some of my databases. I try to create the publication and get the following error message when it is trying to creat it. TITLE: Publisher Properties ------------------------------ An error occurred while saving publication database. Do you want to continue saving other changes? For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=Microsoft.SqlServer.Management.UI.PubshrPropertiesErrorSR&EvtID=ErrorSavingPubDB&LinkId=20476 ------------------------------ […]
2010-04-21
2,147 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,793 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
24 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,136 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,607 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
3,973 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
In many ways job titles matter, just not when telling a stranger what you do for work.
2018-07-30
174 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,877 reads
This June, LearnSQL is throwing down the gauntlet with a fresh SQL Practice challenge....
By Steve Jones
I delivered a talk today on database deployment best practices at the Denver Dev...
By Steve Jones
desanté – n. the brooding delirium of being sick, which makes time slow to...
Comments posted to this topic are about the item On Being an "Expert"
Advice on how to script out existing Azure (logical) SQL Server logins and mapped...
Hi I have a sequence container which contains an execute package task which loads...
I have a query that is being tracked in the SQL Server 2022 Query Store. I want to add a hint to this query to ensure that the MAXDOP for this query is one. How can I do this with minimal code changes
See possible answers