Format to title case
I need to convert all the columns in a table from upper case to title case. Does anyone know how to do this? I know Access has a format function but I haven't found a way to do this in SQL. Thanks Angela
2003-01-29
1,846 reads
Search results for "title"
Your search for "title" returned 100 results:
Adding Report parameter to Chart Title
Not sure whether it’s possible in SSRS 2005 to add Report parameter (like Customer name) to Chart Title? Thanks
2007-12-13
678 reads
SQL Data puller - good job title?
Hi all! I'm having some trouble finding the correct terminology for the job that I do. Basically, I use sql to pull and organize data for a team of analysts. We are called Data Analysts here, but looking around the job world, that's not really what we do. Dats Puller isn't a popular title with […]
2017-02-02
96 reads
how do I show sub report title on the main report?
I sure hope this makes sense: I have one main report with three sub reports. There are three links on the main report to each of the sub reports. Clicking one of the links will display that sub report within the main report and only one sub report can be displayed at a time. I […]
2018-08-01
337 reads
Chart Title font-different styles (SSRS)
Just got new request from Management- apply different fonts (size/color) for different Chart Title parts. For example, chart title is "Report Chart Title". Can we show word "Title" in different color and size? There is function button but frankly I have no clue how can I use it in this case? Any help is much […]
2010-08-04
155 reads
Restarting SQL Server Instance from SSMS Error
Just installed a new SQL Server 2014 instance. When I try to restart the sql server instance in SSMS by right-clicking and choosing restart, I get the following error: TITLE: Microsoft SQL Server Management Studio ------------------------------ Unable to restart service MSSQL$SQLSERVER on server SQLSERVER. (mscorlib) ------------------------------ ADDITIONAL INFORMATION: The object invoked has disconnected from its […]
2016-10-14
1,511 reads
Backup/Restore permission
Hi there, I want to dedicate a person (eg. 'BackupManager') who can only performce backup and restore certain databases. At BackupManager's properties I had checked db_backupoperator. When I login using BackupManager and perform backup, at the add backup destination I receieve an error message like below (similarly to restore), Can anyone help? TIA
2008-06-30
8,497 reads
Missing SSISDBBackup.bak
Hello Team, My concern is as followed:I've built a project with SSDT 2015 then I would like to deploy the package it in SSMS 2016. However, the error message was that there was no SSISDB.I went to SSMS2016 to create the catalog (right-clicking - Integration Services Catalog). The error message was: TITLE: Microsoft SQL Server Management […]
2017-05-08
21,106 reads
Transactional Replication :: Error Creating New Publication
Attempting to create a new publication and received this error: Ran a DBCC OPENTRAN on both the server that's creating the publisher and on the distribution server - there were no open transactions. Any ideas out there?
2011-12-16
4,349 reads
2018-04-04
389 reads
Blogs
Check Azure SQL DB Space Used
A couple of days ago I was doing some cleaning on some Azure SQL...
Use a slicer to filter a visual based upon a measure in Power BI
Have you ever wanted to filter a visual by selecting a range of values...
Deleting Stale Local Database Git Branches with SSMS–#SQLNewBlogger
By Steve Jones
I wrote a post recently about pruning branches in git. That’s part of the...
Forums
SQL Server software and windows version compatibility level
Is there a specific platform or website where I can verify the compatibility between...
Truncate tables where Referential Integrity exists
Comments posted to this topic are about the item Truncate tables where Referential Integrity...
Blocking question
Hi all, We have a SSIS package that does 2 things in parallel: moves...
Question of the Day
Post Restore Tasks for the Resource Database
I backup the Resource database from my SQL Server 2022 instance. I then install CUs 1, 2, 3, and 4. I have an issue and need to restore my Resource database from backup. Is there anything I need to do after restoring this database?
See possible answers