Your search for "title" returned 100 results:
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,650 reads
I've just set up a new instance of SSRS 2012 and I'm unable to connect to it through Management Studio. The error is: It is a native report server. Reporting Services is running on a separate server to the reporting databases (but I doubt if this matters). I can connect to the management URL fine. […]
2012-11-19
2,144 reads
I am practicing sql server 2008, i want to ask if there is any way to find the title more sold in the database Pubs without using cursor (obviosuly i hve to use tables titles and sales ) Thank you in adavance
2011-09-25
2 reads
Hi When I try to create a new Transactional Publication with Updatable Subscriptions I get this error message when it should create the Publication. TITLE: New Publication Wizard ------------------------------ SQL Server could not create publication 'MyDatabaseName'. ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ The specified '@notify_level_email' is […]
2008-08-13
390 reads
While i'm creating a folder in Integration service catalog - SSISDB i'm getting an error as below, TITLE: Microsoft SQL Server Management Studio ------------------------------ Operation 'Create' on object 'CatalogFolder[@Name='dev']' failed during execution. (Microsoft.SqlServer.Management.Sdk.Sfc) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=11.0.3000.0+((SQL11_PCU_Main).121019-1325+)&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ An error occurred […]
2016-04-07
10,232 reads
I am learning to work with SQL server 2019. During the installation I got some errors. TITLE: Microsoft SQL Server 2019 Setup ------------------------------ The following error has occurred: Cannot find the user 'DESKTOP-QGVGUB6\PdwComputeNodeAccess', because it does not exist or you do not have permission. Changed database context to 'DWConfiguration'. Script version: 107 Version_History table created. […]
2021-08-05
2,370 reads
I have a problem with some jobs, disabled since not useful, which I cannot drop. The message returned is TITLE: Microsoft SQL Server Management Studio ------------------------------ Drop failed for Job 'copiaPS.Subplan'. (Microsoft.SqlServer.Smo) ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ The DELETE statement conflicted with the REFERENCE constraint […]
2009-01-28
4,969 reads
Hi, I have report with 10 columns and column #4 is column group, all columns are different width, so depending of number of groups I 'm getting bad or good results? Is there any solution to make it work? I dont' have enough space to put all titles, params in a box that wide up […]
2014-07-23
77 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,167 reads
Hello I have a SSRS Report which shows the revenue made on each day in the month from 1st Business day till the previous business day which runs everyday around noon. I attached the screenshot of the SSRS Report (Dashboard_On_11182014.xls). My concern is with the title/Header alignment. Because the number of previous business days grows […]
2014-11-19
185 reads
In the data-driven landscape of 2024, advanced SQL isn't just a nice-to-have, it's a...
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...
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