Forum Replies Created

Viewing 15 posts - 301 through 315 (of 321 total)

  • RE: Please fix the word wrap

    I noticed the line wrap problem in the daily message dated 9/25 titled Replication Statement Delivery Options - Part 2 (SQLServerCentral.com 9/25/2007) from SQLServerCentral.com [subscriptions@sqlservercentral.com].

    I'll try to forward the message...

  • RE: Die Access, Die

    Thank you Steve. (Got it back!)

  • RE: Die Access, Die

    Hate to beat a dead horse, or maybe I just need to get in the last word… Today I had to listen to yet another anti-Access rant based on hearsay...

  • RE: Wide index

    Related question--if a table needs a multi-column index as a primary key (to ensure uniqueness) should (some of) the same columns need a different index to support queries on those...

  • RE: Die Access, Die

    MS Access is a very powerful and useful application. I have never seen it bashed by anyone who has used it extensivly -- except for the DBAs which are not...

  • RE: Comparing Two stored Procedures

    FWIW, the text of stored procedures is available in the sys.objects view as ObjectDefinition.

    The below is a procedure I run daily to capture any changes in my stored procedures/functions/etc....

  • RE: SSIS Is Not Just for SQL Server

    A really dumb beginners question re Public Sub Main:

    Where (and in what language) is this defined?

    Where is the object Dts created?

  • RE: pitfalls when using joins on distributed queries?

    I have seen no performance impact between joins across DBs within the same server v joins within the same DB.

    I have seen severe performance problems with joins involving multiple servers....

  • RE: SSMS SQL editor problem

    I've stopped using Query Designer myself; the first problems I noted were creating/and checking my own SQL statements.  If you have not seen the spurious whitespace errors, it must be something...

  • RE: bcp rows missing or out of order

    I have been bit several times (but few enough that I remember the lesson) when I try to rely on a row order that I KNOW  is correct. I think the...

  • RE: Solutions, Projects, and Save AS

    Thanks for the registry key information!

  • RE: Solutions, Projects, and Save AS

    Thanks for your post!

    Are you registered? I was unable to send you a private message.

    (Just wanted to note that you had typed "fisically" when you probably meant "physically". It's...

  • RE: View always sorts by PK ????

    It's easy to be deceived.  If you have an order by clause in a view, the view editor adds the top 100 % foolishness to the query. So when you...

  • RE: Beginning Administration

    I'd like to see a dummy's guide to assigning permissions to a (new) view for a new user. In particular, defining the logon, creating a group, adding needed permissions for...

  • RE: Changing column order in Table

    I don't disagree with anything you say, except for your comment about select * which was not part of the original discussion.

    I'm talking about the order in which columns are...

Viewing 15 posts - 301 through 315 (of 321 total)