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)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy