Viewing 15 posts - 466 through 480 (of 1,065 total)
I don't think it's specifically a replication mechanism... that is the way SQL Server handles some updates.
It makes itself visible in replication because SQL Server constructs the replication commands...
September 10, 2009 at 5:11 am
Have a look at this article http://support.microsoft.com/kb/238254
A while ago, when looking at a replication issue, I discovered that if the update makes changes to the primary key or any column...
September 10, 2009 at 3:20 am
Paul White (9/9/2009)
Ian,Cool. Thanks for the exchange - great stuff. And it's 3am. Time for me to hand over to the next time-zone... 🙂
Holy S**t, you're in...
September 9, 2009 at 9:04 am
Paul White (9/9/2009)
As soon as you put that comma in (after the INT NULL) the DFx constraint is no longer a column constraint - it's a table constraint.
Ahhh... which...
September 9, 2009 at 8:52 am
KB (9/9/2009)
KB (9/9/2009)
ALTER TABLE dbo.myTable ADD CONSTRAINT DF_myTable_Q DEFAULT(0) FOR Quotacurrently the Quota column is "int NULL"
how to change it to "int NOT NULL" ?
-
KB
alter table dbo.myTable alter column Quota...
September 9, 2009 at 8:21 am
Paul White (9/9/2009)Is that better? I did try!
Yup. I think!
The comma denotes the end of the column definition, and the beginning of any table constraints, so
alter table dbo.myTable ADD...
September 9, 2009 at 7:51 am
Why would you want to create a full text index on an Image data type... doesn't it contain binary data?
September 9, 2009 at 7:29 am
Paul White (9/9/2009)
September 9, 2009 at 7:24 am
As you've posted this in the SQL Server 7,2000 forum, your error may be that BEGIN TRY... isn't supported in either of those versions of SQL Server.
September 9, 2009 at 7:08 am
Paul White (9/9/2009)
The only bit I think I didn't quite get across was the "how would one add a column at the same time as a table constraint" bit. The...
September 9, 2009 at 6:53 am
I wrote a detailed reply to this, but it got lost when the website went down, and I couln't summon the enthusiasm to write it all again.
I'm quite surprised the...
September 9, 2009 at 5:57 am
I'm not sure what your question is either, but I suspect you may get what you are after by looking at the SQL in these stored procedures in msdb sp_get_schedule_description,...
September 9, 2009 at 4:42 am
Paul White (9/9/2009)
ALTER TABLE dbo.myTable ADD CONSTRAINT DF_myTable_Q DEFAULT(0) FOR Quota WITH VALUES
WITH VALUES only works when you are also adding the column at the same time. Just adding the...
September 9, 2009 at 4:33 am
Ian Hockaday (9/3/2009)
but those 2 not in the index...
September 4, 2009 at 5:07 am
Viewing 15 posts - 466 through 480 (of 1,065 total)