Viewing 15 posts - 61 through 75 (of 359 total)
exec sp_MSforeachtable 'ALTER TABLE ? CHECK CONSTRAINT ALL'
Turns them back on.
November 19, 2004 at 4:11 pm
exec sp_MSforeachtable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'
November 19, 2004 at 4:09 pm
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....
November 19, 2004 at 4:05 pm
There are third-party applications that can help - SQL Data Compare 3.
There is a t-sql reserved word - readtext - that might help.
November 19, 2004 at 1:23 pm
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.
November 19, 2004 at 1:11 pm
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...
November 18, 2004 at 10:30 am
Ok...
Wie gehts - isn't that "how are you?" or something like that?
I usually use google.fr, and I know what you mean.
November 18, 2004 at 10:20 am
I just coalesce when I'm in meetings with clients. It makes me sound important and dba-ish.
November 18, 2004 at 8:11 am
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....
November 18, 2004 at 8:07 am
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...
November 17, 2004 at 7:12 am
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,...
November 15, 2004 at 7:52 am
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....
November 12, 2004 at 2:57 pm
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...
November 12, 2004 at 2:07 pm
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...
November 12, 2004 at 1:39 pm
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...
November 12, 2004 at 1:36 pm
Viewing 15 posts - 61 through 75 (of 359 total)