Your search for "title" returned 100 results:
Hi everyone, I am a complete noob in SQL but not in programming. I am trying to teach myself to be proficient in SQL but I find that the configuration part is hard to get past before the actual lessons. I just installed MS SQL Server 2008 Management Studio Express from here https://www.microsoft.com/en-ph/download/details.aspx?id=7593. Opening the […]
2015-05-01
2,806 reads
All, I'm working a short-term contract for a client that has SQL Server 2008 running on Windows Server 2008. The client has asked me to make changes to existing cubes and create new cubes. There is no dev/test environment, so I decided to create a new database. My idea was to create a new database […]
2010-12-08
3,388 reads
I have an LDAP query that runs perfectly. However, as soon as I introduce a LIKE into the WHERE clause it breaks. The error (Msg 7321, Level 16, State 2, Line 1) seems to be generic rather than to do with my syntax so I'm not sure what is the issue. I have googled and […]
2019-04-09
516 reads
Comments posted to this topic are about the item
2015-09-06
97 reads
The users within a particular domain group are having trouble accessing all the appropriate databases via their SQL Server Management Studio client. They receive the error message, “The database is not accessible. (Object Explorer). Am I lacking some permissions. All the related databases are in a Multi_User mode, Normal Status. I'm using SQL Server 2005 […]
2008-03-19
46,393 reads
This might not be the fastes script, in the world but it takes care of the McDonalds, O'Brian's, MacPherson's and the Jens-Michael's of the world.
2005-09-05 (first published: 2005-08-31)
281 reads
I am getting this error in SQL Server Express 2017 when trying to script a table out to a new query. I can open it in design mode, run queries and so on but not generate scripts for tables... Attempt to retrieve data for object failed for Server '(LocalDB)\MSSQLLocaDB'. (Microsoft.SqlServer.Smo) Additional Information Invalid Urn filter […]
2020-03-24
5,975 reads
Hi all, Apologies in advance if I am asking something really obvious but I have an XML file that is provided daily, from which I need to extract the data and import it into a table in SQL Server. I think the issue I am having is down to namespaces but I don't fully understand […]
2017-07-31
39 reads
Hello Database Experts !! I have to write a query using "AdventureWorks Database" which joins HumanResources.Employee table to the Person.Person table so that you can display the FirstName, LastName, and HireDate columns for each employee and JobTitle along with a count of employees for the title. So, i have written the following query But, i […]
2017-09-01
24 reads
Hi, I am working on this discussion forum, same like this one. I have created two tables - one to store the parent messages, ie., the first message in a thread, and second table to store all the child messages or the replies. This is the table design. ForumParents - threadid, userid, title, message ForumChildren […]
2007-03-09
95 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