I don't know anything about the StarSQL driver, but I have seen similar issues using DTS against ODBC (specifically Firebird). Sometimes it seemed to work and sometimes it didn't,...

🙁 I was hoping to learn a new word today!

Chad

I'm afraid mine has no foreign key constraints. Helps with creativity and problem solving and spews out some hillarious "stream-of-consiousness" conversations. Well, at least I think they're hillarious,...

Shucks.

I assumed based on the question wording that it was asking if the table statistics (not the index statistics) were updated. Guess I read "on the table" as the...

sp_MSForEachTable replaces the question mark directly, so what you ended up with was:

Update Statistics "[dbo].[zipcode]" with FULLSCAN

If you remove the double quotes from your query, it should work.

Hope this helps!

Chad

Hmmm... I got the error below, which wasn't one of the options, so I couldn't select it:

Msg 7736, Level 16, State 1, Line 2

Partition function can only be created in...

Do you have any suggestions on how to search for posts with few replies without providing any keywords? That doesn't give a definitive list of open questions, but if...

Yes, I was thinking for the writers. I guess the best thing to do is search as best we can and submit it. Thanks Steve!

Chad

This would be a nice option - to be able to mark your question as "answered" by closing the thread. I'm not the best at answering, but do like...

There are a few options, but using a SP may not be the best for you. Take a look at this article: http://support.microsoft.com/kb/321686. If the Excel file...

I don't know if this will work for your situation, but I have implemented something in a similar using TOP.

I created a job to move records slowly from one table...

Look for a bunch of exec sp_reset_connection calls - a pooled connection will call this proc when it wants to reset a connection pulled from the pool. If you...

If we win the book will it be autographed?

:w00t:

Chad

Does this get you started in the right direction?

DECLARE @myvar AS XML

, @XMLDoc int

SELECT @myvar = '

&ltMovement xmlns="" Context="Acquire"&gt

&ltOperationCollection&gt

&ltOperation Name = "Execute"&gt

&ltOptionCollection&gt

&ltOption Name="Execution.Capability"&gt(Synchronous,Asynchronous)&lt/Option&gt

&ltOption Name="Execution.Preference"&gt(Asynchronous)&lt/Option&gt

&ltOption Name="Origin.Status.Criteria"&gt(Fail)&lt/Option&gt

&lt/OptionCollection&gt

&lt/Operation&gt

&ltOperation Name="ConnectorContext"&gt

&ltOptionCollection&gt

&ltOption Name="Connector.MerchantIdentifier"&gt56500&lt/Option&gt

&ltOption Name="Connector.Alias"&gtCC_01&lt/Option&gt

&ltOption Name="Connector.Wallet.TransactionIdentifier"&gt(wirecard:Transaction)(00000000000000000000000001xP2)()&lt/Option&gt

&ltOption...

I agree completely!

Chad