Viewing 15 posts - 1 through 15 (of 28 total)
Am trying to keep track of some triggers in a new database I just inherited in order to troubleshoot some issues, I would like to know the start time, end...
August 12, 2015 at 6:16 am
It worked. I was able to modify the script you provided for archiving also.
Thanks for your help.
February 4, 2015 at 10:24 am
I will try it and get back. Thanks!
February 4, 2015 at 9:21 am
Here is the first table with a date column:
CREATE TABLE [dbo].[Log](
[LogID] [int] IDENTITY(1,1) NOT NULL,
[EventID] [int] NULL,
[HandlingInstanceId] [uniqueidentifier] NULL,
[UserId] [uniqueidentifier] NULL,
[Priority] [int] NOT NULL,
[Severity] [nvarchar](32) NOT NULL,
[Title] [nvarchar](256) NOT NULL,
[Timestamp]...
February 4, 2015 at 9:03 am
What other detail do you want me to provide? I will provide.
February 4, 2015 at 8:47 am
I don't really know what information you want me to provide but here is what I did. I took the full backup of the principal and restore it on the...
November 4, 2012 at 7:06 am
name = abcdatabase,
user_access_desc = multi_user,
state_desc = online,
recovery_model_desc = full
November 4, 2012 at 5:59 am
Thanks again for helping!
I was able to view the synchronization status and I discovered that the tables are being populated and the second publisher's synchronization status is show that the...
October 3, 2012 at 2:23 pm
Ok. We're getting somewhere.
Re: missing tables-You will need to create a subscription to the second publication to get those tables. Each subscription can only subscribe to one publication.
Re: empty...
October 3, 2012 at 1:40 pm
Thanks for replying!
I didn't create any table all were replicated
Publisher is 2005 while subscriber is 2008 r2
October 3, 2012 at 1:34 pm
I am getting the table from one publication but some of the tables are empty, I'M NOT getting any table from the second publication at all.
October 3, 2012 at 1:05 pm
Thomas Stringer (5/7/2012)
You don't need to use a subquery.
update client
set uniqueID =
SUBSTRING(lname,1,2)+ SUBSTRING(fname,1,2) +
replace(convert(varchar,dob,10),'-','')
WHERE uniqueID IS NULL
Thank you so much, you...
May 7, 2012 at 12:53 pm
Geoff A (5/7/2012)
its because your query (SELECT SUBSTRING(lname,1,2)+ SUBSTRING(fname,1,2) +replace(convert(varchar,dob,10),'-','') from client
WHERE uniqueID IS NULL) returns more than 1 result.
I know, how do you fix that bcos I would like...
May 7, 2012 at 12:40 pm
SQLKnowItAll (4/25/2012)
deebabat (4/25/2012)
SQLKnowItAll (4/25/2012)
Lynn Pettis (4/25/2012)
Okay, it looks cleaner, but does it work? If so, is there another problem?
I think the OP is saying that this is the source...
April 25, 2012 at 1:13 pm
Viewing 15 posts - 1 through 15 (of 28 total)