Forum Replies Created

Viewing 15 posts - 61 through 75 (of 359 total)

  • RE: Removing Cascade Deletes

    exec sp_MSforeachtable 'ALTER TABLE ? CHECK CONSTRAINT ALL'

    Turns them back on.

  • RE: Removing Cascade Deletes

    exec sp_MSforeachtable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'

  • RE: A very Intriguing question

    Maybe it's just me on a Friday afternoon, but this schema is more complex than necessary. It would work. A consideration would be that you must use joins for everything....

  • RE: Compare two NTEXT columns

    There are third-party applications that can help - SQL Data Compare 3.

    There is a t-sql reserved word - readtext - that might help.

  • RE: SP name

    I posted a script here that did just that. I had to do it so that the scripts created by developers would run in the test environment.

  • RE: VB code vs. Stored procedures

    Laughing.

    Your boss is not a DBA; he just plays one in his office. Thanks for the laugh - "because you can just send the customer a new .exe. instead...

  • RE: Naming Conventions and You

    Ok...

    Wie gehts - isn't that "how are you?" or something like that?

    I usually use google.fr, and I know what you mean.

  • RE: SQL Statement Help

    I just coalesce when I'm in meetings with clients. It makes me sound important and dba-ish.

  • RE: Naming Conventions and You

    Laughing...

    I kept jumping to German sites...then I realized, ah, they are Frank's links. Where else would they be?

    Deutschland, Deutschland, uber alles.... Wie gehts?

    Yes, I have used the camel notation....

  • RE: Desesperately seeking help !

    From BOL (ERROR message severity levels):

    When a level 17, 18, or 19 error occurs, you can continue working, although you might not be able to execute a particular statement.

    Severity...

  • RE: To Certify or Not to Certify

    Laughing....

    Ciao means goodbye in Italian.

    Yes, my copy of Kalen's book is beaten, stained (probably coffee) and worn. It is always within arm's reach.

    I checked my shelves at home,...

  • RE: Adding Column to a Table with Desired Order

    When you talk of the wolf, you will see it's tail.

    Laughing - the Venkman quote is from Ghostbuster I -

    [Dana has described seeing a terror dog in her refrigerator]

    Dr....

  • RE: To Certify or Not to Certify

    Laughing. "Product exposure" would be a better term.

    Yes, the best option is to work with the system. Understand your tools - EM, QA, Profiler, etc.

    Learn T-SQL. My mentor...

  • RE: Date Selection Nightmare

    Laughing. No sense getting frustrated about it. It's how we learn. You don't know how many times I've been quizzed by developers when I tell them a SQL integer is...

  • RE: Adding Column to a Table with Desired Order

    I agree with Frank - moving columns by changing syscolumns sounds vaguely suicidal (or is that datacidal?).

    You are better off with the solution of copying the data to a...

Viewing 15 posts - 61 through 75 (of 359 total)