Gaining insight into my SQL Server standard and Windows logins has historically been a challenge in terms of determining password changes, failed login attempts, etc. I have noticed that you have experienced the same issue with your tip entitled 'When was the last time the SQL Server sa password changed' and I have noticed some information in the forums on the topic as well.
2008-04-21
3,407 reads
We have been discussing SQL Server 2005 Express Edition replication-specific features, investigating authentication mechanisms that are available in order to accommodate connection attempts from remote clients interacting with SQL Server-based distributor via Internet Information Services. We will continue coverage of this topic here.
2008-04-21
1,679 reads
Some of the features that seem to make LINQ very attractive also seem to require granting table level access to data, something Steve Jones doesn't like.
2008-04-21
36 reads
Some of the features that seem to make LINQ very attractive also seem to require granting table level access to data, something Steve Jones doesn't like.
2008-04-21
42 reads
Some of the features that seem to make LINQ very attractive also seem to require granting table level access to data, something Steve Jones doesn't like.
2008-04-21
27 reads
What happens if you allow people to be in control of their own computers? Are we putting the inmates in charge of the asylum?
2008-04-20
34 reads
What happens if you allow people to be in control of their own computers? Are we putting the inmates in charge of the asylum?
2008-04-20
29 reads
What happens if you allow people to be in control of their own computers? Are we putting the inmates in charge of the asylum?
2008-04-20
28 reads
Part 2 of new T-SQL enhancements from Srinivas Sampath. SQL Server 2005 contains a number of enhancements designed to allow you to write more powerful queries while keeping the code structured in a way that makes development and understanding it easier. Building on his first look at Common Table Expressions, Srinivas now looks at recursive queries with CTEs.
2008-04-18 (first published: 2005-03-03)
94,416 reads
This paper summarizes the different ways that developers can integrate SQL Server 2005 Reporting Services capabilities in their applications.
2008-04-18
10,171 reads
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Comments posted to this topic are about the item Database security permissions save script
I have a SQL Agent job for backing up a set of Analysis Services...
Comments posted to this topic are about the item SQL Server 2025 Backup Compression...
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers