Polybase (SQL2016 CTP2)

RE: Query Analyzer and sysdepends

HELLO BRIAN,Not sure if this is the best way to add on a question to this topic, but could not find alternative...  I just loaded a script with about 20 stored procedures.  they were in alpha order rather than ordered by called procedures prior to the calling procedures.  should I worry that I got this […]

RE: Timestamp on threads

Laughing - there are times I am working with my European collegues and their day starts many (many) hours before mine and ends somewhere within 30 minutes of my first cup of coffee at my desk. When I work with Asian countries I have the opposite issue. By the way, Frank is always on line.....

RE: Failing DTS package

IF you cannot see it and you know it is there CREATE a NEW package....  Only way I know of...

RE: SQL Mail Doesn''''t see any profiles....

I have it working now. I had to go into internet options in control panel and set outlook as the default mail client. Somehow outlook express was the default.... Allan

RE: Interesting ! Update query with alias ?

Interesting AJ! If you read the BOL reference I posted, it specifically states and shows by example that the syntax won't work.Guess that's one of the 'flukes' in SQL Server.-SQLBill

RE: Delete taking too long

If you are absolutely positive that the records that you are about to delete don't have an related records in other tables then, as part of the delete process, try dropping the constraint before you do the delete then re-enable the constraint afterwards.

RE: sql server 2000 trigger for checking duplicate email in a table

Hmmm - not quite sure what you're after. Do you have a 'person' table containing an e-mail field and want to maintain a separate table which contains just e-mail address (and, presumably, a foreign key back to the main 'person' table)? So do you therefore want to migrate your e-mail addresses away from your 'person' […]

RE: New servers - New locations

You need to set some startup parameters before the move....check out http://support.microsoft.com/default.aspx?scid=kb;en-us;224071

RE: How to capture error message

As you mention, the test from sysmessages isn't that helpful. Try this interesting technique, http://qa.sqlservercentral.com/columnists/ajethva/capturingtheerrordescriptioninastoredprocedure.asp