Viewing 15 posts - 226 through 240 (of 382 total)
Great bit of code here. Just had a single error log reach 14.5 GB. Killed our testing environment. owner found it when he came in and deleted...
September 1, 2009 at 9:49 am
Abhay,
It worked!!!!!!!!
Funny thing is, the only thing that you did differently than I did was the certificate start_dates. I wonder why that made a difference?
Oh well, maybe...
June 23, 2009 at 10:41 pm
Abhay,
Thanks for the detail reply. I did almost everything you did, but there are a couple I didn't. I will give it a try and let you know...
June 22, 2009 at 9:32 pm
oded.raz (6/21/2009)
Why do you need certificates.Does all of the server connected to the same domain.
Take a look at this tutorial - http://www.dbsnaps.com/articles/sql_mirror_1/%5B/url%5D
Oded
Oded,
Nice little demo. However, I have two issues....
June 22, 2009 at 9:22 pm
oded.raz (6/21/2009)
Why do you need certificates.Does all of the server connected to the same domain.
Take a look at this tutorial - http://www.dbsnaps.com/articles/sql_mirror_1/%5B/url%5D
Oded
Oded,
Nice little demo. However, I have two issues....
June 22, 2009 at 9:20 pm
oded.raz (6/21/2009)
Why do you need certificates.Does all of the server connected to the same domain.
Take a look at this tutorial - http://www.dbsnaps.com/articles/sql_mirror_1/%5B/url%5D
Oded
Oded,
Nice little demo. However, I have two issues....
June 22, 2009 at 9:15 pm
Glad to hear that you got it figured out. Would like to take some credit for leading you there, but from what it sounds like, you didn't need it.
😀
Fraggle
June 20, 2009 at 11:11 am
Are you saying that each of the columns below must have unique values or that a combination of the two columns must be unique?
If each column has to be unique,...
June 19, 2009 at 11:05 pm
Gila,
Thanks for the assist.
Fraggle
June 15, 2009 at 9:13 am
Gila,
When using the SET STATISTICS_XML ON, you get an xml execution plan for the query that was just executed. When this xml string is clicked on in 2008, it...
June 15, 2009 at 8:52 am
Actually, I was able to figure out the error thanks to help from a .NET guy (embarrassing ain't it). :ermm: TEXT() should be text(). The only thing he couldn't...
June 1, 2009 at 1:11 pm
Jayoub1,
Sorry for not getting back with you sooner. Here are the two things I would recommend.
1) Setup a perfmon counter that watches avg. disk queue, reads/sec, writes/sec, and transfers/sec....
April 21, 2009 at 7:56 pm
Need some more information to really make a connection.
When you say the DB crashed, can we get a little more detail on what you mean? (log filled up the...
April 15, 2009 at 10:05 pm
Have you trying using the Data Conversion task in the Data Flow tab. Should be up to the task.
Fraggle
April 15, 2009 at 9:58 pm
I will have to take a look at this to see if there is a better way, but it is going to be a couple of days. Initially it...
April 15, 2009 at 9:55 pm
Viewing 15 posts - 226 through 240 (of 382 total)