Fix for SSIS SP1 "service failed to start" issue
I was catching up on my blog reading and found the following post from Jamie Thomson:
SSIS: Another SP1 problem
The post...
2006-04-28
1,443 reads
Databases – Infrastructure – Security
Issues with SQL Server 2005 SP1
There have been reports of some issues with SQL Server 2005 SP1, especially
with SQL Server Integration Services not starting as...
2006-04-27
1,619 reads
When life intrudes
I have MVP Raymond Lewallen in my list of blogs to follow. I read with great sadness the following blog...
2006-04-26
1,455 reads
Issues tracking members of the sysadmin fixed server role
I received an email from another DBA asking how to track a user who is
probably mapping into SQL Server via...
2006-04-25
1,584 reads
Determining if it's a SQL login, Windows Login, or Windows group
A recent question on the forums asked how to determine if a database
user was a Windows user or group and...
2006-04-06
3,761 reads
Kerberos Delegation with SQL Server Reporting Services and SQL Server
I've been dealing with Kerberos delegation setup with respect to
Microsoft's CRM 3.0 product and while the process isn't difficult, if
you...
2006-04-05
2,123 reads
March/April 2006 Edition of SQL Server Standard Available
The March/April 2006 edition of SQL Server Standard magazine is now
available. This issue focuses on Transact-SQL for SQL Server 2005.
Though...
2006-04-03
1,504 reads
12-inch grass stem?
Those of us in technology are very, very used to automated systems,
batch jobs, etc., all which run without human interaction...
2006-03-29
1,348 reads
Internet Explorer Vulnerability
If you're using Internet Explorer, be advised Microsoft has released a
security advisory for Internet Explorer. This would allow an attacker
to...
2006-03-28
1,546 reads
Rights within the database
This is a follow-on to my post What are the actual rights?
First and foremost, I want to include membership in...
2006-03-14
1,412 reads
Blogs
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file...
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Announcing SQL Server 2025
Comments posted to this topic are about the item Announcing SQL Server 2025
Running Steve's Code
Comments posted to this topic are about the item Running Steve's Code
New SQL Server 2022 Functions
Comments posted to this topic are about the item New SQL Server 2022 Functions
Question of the Day
Running Steve's Code
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers