Viewing 15 posts - 271 through 285 (of 853 total)
What type of replication is this?
Transactional
Can you see job history. when the job last ran?
January15
What is the latency between the primary and subsriber?
How can I find that?
Run dbcc opentran on...
February 18, 2011 at 6:55 am
Thank you, but what I need if I enter data from t1 to t2 and there is a record like that in t2 don't enter and insert next one.
Thank you
February 17, 2011 at 11:56 am
insert into table2
SUN_DB, CODE, [NAME]
select
SUN_DB, CODE, [NAME]
from table1
February 17, 2011 at 10:44 am
table2 structure:
[SUN_DB] [nchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[nchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[NAME] [nchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
CONSTRAINT [PK_SUN_Vendors] PRIMARY KEY CLUSTERED
(
[SUN_DB] ASC,
ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
)...
February 17, 2011 at 10:35 am
You manage the actual SSIS service from Windows management tools (there are a number of ways to get into that).
Are you trying to do one of those things?
Yes, how...
February 9, 2011 at 9:11 am
This is an error message I get when I try to modify my maintance plan:
This maintenance plan has been modified using a tool other than the maintenance plan designer. You...
February 9, 2011 at 8:43 am
How can I check what package I have?
Thank you
February 9, 2011 at 6:45 am
I only see clean up history on server connection
February 8, 2011 at 1:51 pm
I don't see process id 2096 and is sql agent and sql server needs to be running under the same accounts?
Also, there is no opt file between 2/7 1300...
February 8, 2011 at 1:40 pm
I can't specify there where my backups
February 8, 2011 at 11:36 am
The issue that my admin re strted sql agent in the 730 a.m and for some reason sql agent was shut down between 730 and 956. I also just found...
February 8, 2011 at 11:33 am
Viewing 15 posts - 271 through 285 (of 853 total)