Viewing 15 posts - 16 through 30 (of 65 total)
Exactly. I found a select * from AdventureWorks.dbo.DatabaseError was a good test. It's been a pain in the rear, but this whole process is really teaching me a lot about...
March 24, 2006 at 7:41 am
I downloaded the Ethereal packet sniffer (looks like a great product, BTW) and gave it a shot. I don't know networking very well, so I'm not sure I was looking...
March 24, 2006 at 7:34 am
There are definitely some things I really like about the product (I call it ManStud, BTW). But there definitely are the small gripes. For example, I'm not a fan that...
March 24, 2006 at 6:01 am
I'll have to give it a try. Now off to find a packet sniffer! Thanks.
March 22, 2006 at 1:04 pm
Named pipes is disabled. The only two libraries enabled are TCP/IP and shared memory.
My fellow DBA was able to connect to it via ManStud and QA without the certificate installed.
March 22, 2006 at 8:08 am
BTW, it's running on Windows Server 2003 SP1. There is no Certification Authority running.
Could this have anything to do with the certificate being self-signed?
March 21, 2006 at 1:30 pm
Thanks for the reply!
Running it from the DTS designer or calling the proc directly from a job doesn't make a difference. They both behave the same. But I'm going to...
March 10, 2006 at 6:19 am
Right, I see what you mean. However, these are individual DDL statements, not group events. ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/ca518b24-6451-445c-952d-101fccef87fa.htm defines that there are two types of events: one or more particular DDL statements...
December 20, 2005 at 8:51 am
Yes, I'm using RTM. My BOL indicates that it actually is a server-scope ddl. It's parent is DDL_SERVER_SECURITY_EVENTS. I'm ultimately trying to capture that ddl group, but I've narrowed down...
December 20, 2005 at 8:11 am
Wierd ... it got rid of all my indentation (spaces). Sorry about that.
December 19, 2005 at 12:53 pm
Question: Have any of you gotten this to work with Outlook Express? I'm pretty sure I read that full-blown Outlook is required. If so, that's tragic.
I am excited about...
November 23, 2005 at 7:58 am
I think that the decision of the column order in the composite index should also be informed by the other indexes on the table.
If the column is already in...
October 28, 2005 at 8:35 am
Check out this article: http://www.databasejournal.com/features/mssql/article.php/3483421. It may help.
Also, consider using Merge replication instead of transactional. It will suit your needs well, I think. You can fully replicate...
September 5, 2005 at 10:31 pm
This is exactly right. When you say "ess-que-el", you are beginning with a vowel sound. When you say "sequel", you are beginning with a consonant sound. English language/grammer dictates (with...
June 3, 2005 at 9:36 am
Right. Exactly. I would personally opt for a more permanent solution, such as having a check constraint or even a trigger which updates it to upper case. Could also have...
June 2, 2005 at 9:48 am
Viewing 15 posts - 16 through 30 (of 65 total)