I was fighting an error that was very rare to appear. I originally put a post on a MS forum
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.sqlserver.replication&tid=57229124-0a5a-4ec3-9055-a06b7869b872&cat=&lang=&cr=&sloc=&p=1
The...
2008-07-02
4,439 reads
Yesterday, I was fighting with an error I have never seen in the replication and not much info can be obtained via...
2008-06-03
16,125 reads
This is an old topic and well documented, just google it and I believe you will get a lot,
However,...
2008-04-22
2,214 reads
In my last post, I talked about what prompted me to give a deep thought to documentation work. Documentation, to me,...
2008-03-17
1,001 reads
As a DBA, documentation work is unavoidable, we need to do documentation about things we have done, for example, what...
2008-03-01
1,060 reads
In DBA world, usually two types of DBA are defined depending on what a DBA is focusing on, i.e. development DBA...
2008-02-29
1,883 reads
Last week, in our production, we noticed some records are missing in the subscriber side while existing on the publisher...
2008-01-15
918 reads
The other day, I was trying to find out which partition is on which filegroup for a a partitioned table....
2007-12-12
1,575 reads
From time to time, I need to dump out the result from a SP, such as sp_lock or sp_who.
Traditionally,...
2007-11-29
1,397 reads
I solved an "interesting" issue today. It is about distributed transaction. When I set up transactional replication with immediate updating...
2007-11-21
3,616 reads
By Steve Jones
ecstatic shock – n. a surge of energy upon catching a glimpse from someone...
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
Comments posted to this topic are about the item Find Invalid Objects in SQL...
Email..dmtworld2@gmail.com Telegram..@jemsscott237 Vaping DMT makes it considerably more advantageous when contrasted with really illuminating...
If I want to track which login called a stored procedure and use the value in an audit, what function can I use to replace the xxx below?
create procedure AddNewCustomer
@customername varchar(200)
AS
BEGIN
DECLARE @added VARCHAR(100)
SELECT @added = xxx
IF @customername IS NOT NULL
INSERT dbo.Customer
(
CustomerName,
AddedBy
)
VALUES
(@customername, @added)
END See possible answers