Forum Replies Created

Viewing 15 posts - 3,571 through 3,585 (of 3,613 total)

  • RE: Beware to the System Generated Constraint Name

    I started off with SQL 6.5 when Enterprise Manager was given the euphenism Enterprise Mangler therefore we always used TRANSACT SQL and explicitly named every constraint.

    SQL also creates system indices...

  • RE: @@ROWCOUNT problem

    Sorry about the lateness of this post.

    I've found that @@ROWCOUNT gets its knickers in a twist with triggers.

    INSERT DestinationTable(Fields)

    SELECT Source.Fields

    FROM SourceTable

    WHERE Some Clause

    SELECT @@ROWCOUNT

    If DestinationTable has a trigger then @@ROWCOUNT...

  • RE: Worst Practices - Not Using Primary Keys and Clustered Indexes

    On a related subject, should Int IDENTITY columns be deprecated infavour of GUID columns?

  • RE: Microsoft - Love 'em or Hate 'em?

    On the plus side their products tend to aim for usability.

    On the downside is that their are some very powerful features in competitors products that I wish Microsoft would implement.

    Also,...

  • RE: The Case for SQL Logins - Part 1

    How does ORACLE handle authentication?

  • RE: The Case for SQL Logins - Part 1

    We use WA for an Internet solution where no-one is automatically on the domain. This forces users to login to the internet application.

    It is the Windows Group that is...

  • RE: Refactoring: Improving the Design of Existing Code

    What are they using instead of Hungarian?

    Considering the battle to get developers to adhere to standards I don't relish the idea of changing just because MS don't feel like it...

  • RE: xp_logininfo

    Thanks, but my SQL2K box uses OPENROWSET with parameters and it works.

    My extracted code will not work even if I hard code the values of the parameters.

    I've had to get...

  • RE: Refactoring: Improving the Design of Existing Code

    I haven't read this particular book, but my comment is that a book from a different discipline can provide a useful perspective that is applicable to the SQL discipline.

    For example,...

  • RE: Storing Word 2000/ 97 Documents in SQL Server

    I've done it using an ADO Stream object. See Wrox Press ADO 2.6 Programmer's Reference.

    Once you have done it for one sort of file then you can do it...

  • RE: Coding Standards Part 2 - Formatting

    Yes, good ideas here.

    Anything that makes old code easy to read gets my vote.

    Has anyone used sp_addextendedproperty to help comment objects within your databases?

  • RE: Problems changing sa password

    Thanks Andy,

    Using the -SubscriberLogin [mylogin] -SubscriberPassword [mypassword]in the distributor agent sorted it.

    I don't know why it didn't work before, but it works OK now.

  • RE: Problems changing sa password

    I've been having similar problems with replication since changing the SA password.

    I changed the password on both the Publisher/Distributor and on the Subscriber.

    Both have exactly the same password.

    The Distributor job...

  • RE: Results of MCDBA Survey

    The results are very US biased.

    In the UK there are a lot of jobs advertised for DBA's and one of the questions employers ask is "Can you do stored procedures"....

  • RE: Reminiscing

    Warm and Fuzzy!!!!!

    That describes sales pitches and user specs.

    It gives me a warm glow to remember that there is only so much to cock up in 256Kb RAM or a...

Viewing 15 posts - 3,571 through 3,585 (of 3,613 total)