Viewing 15 posts - 316 through 330 (of 1,790 total)
Nope, transactional replication can definitely handle it. If you start running into latency give a post back and we can work through that.
February 23, 2011 at 1:25 pm
Krasavita (2/23/2011)
Microsoft SQL Server Management Studio9.00.4035.00
Microsoft Analysis Services Client Tools2005.090.4035.00
Microsoft Data Access Components...
February 23, 2011 at 12:44 pm
Definitely agree, PSS is the way to go here. Please post back with what you find.
February 23, 2011 at 8:37 am
Great. I was beginning to wonder if that was the issue which is why I posted that last query. Glad you got it working and thank you for updating.
February 23, 2011 at 6:57 am
I'll have to write my perceptions on remote working but will say that I have been working remotely either part or full time for the last 5 years with the...
February 23, 2011 at 6:55 am
Is it occurring consistently or sporadically? If consistently then there is probably something seriously wrong with the SAN, either in the communication layer or the controller and possibly at the...
February 22, 2011 at 8:26 pm
If you are going to continue to restore the log backups then you are going to have to leave it in recovery making it unusable as well.
Have you read...
February 22, 2011 at 2:50 pm
Yes, that is a log shipping scenario. Is there a reason you wouldn't just use Log Shipping rather than building this up yourself?
February 22, 2011 at 2:32 pm
GilaMonster (2/22/2011)
If your code is that valuable, the only option that will protect you is to host the SQL server yourself and never give the clients the databases. Anything else...
February 22, 2011 at 1:22 pm
something like this should work;
select object_name(id) from syscolumns where name = 'col1'
February 22, 2011 at 12:36 pm
sdffdfad faadffad (2/22/2011)
February 22, 2011 at 10:49 am
yuanyelss (2/18/2011)
The issue scales with volume anyway and the particular query is largely irrelevant. A query that runs <1 sec on the test box takes 23 seconds on Prod...
What are...
February 18, 2011 at 10:07 pm
Sean Lange (2/18/2011)
David - yours is about half as much typing as mine but has a lot more +1 -1 than mine. They both certainly work equally well. :hehe:
Yeah -...
February 18, 2011 at 3:27 pm
Sean - you beat me and I think yours looks cleaner but I'm posting anyway. 🙂
DECLARE @string VARCHAR(50)
SET @string = 'IA_JOOWEN_1-F3D9NN'
SELECT SUBSTRING(@string, CHARINDEX('_', @string, 1) + 1, ( LEN(@string) -...
February 18, 2011 at 3:21 pm
Can you verify that this query returns 0 rows when run in your publication database;
SELECTsp.name AS publication_name,
ss.srvname AS subscriber_name,
sa.name AS table_name
FROMsyssubscriptions ssJOIN sysarticles sa
ON ss.artid = sa.artid
JOIN syspublications...
February 18, 2011 at 2:05 pm
Viewing 15 posts - 316 through 330 (of 1,790 total)