Yes

Lynn Pettis (7/17/2012)

---

Mostly requests for assistance, but I have tried to engage him where I think...

GilaMonster (7/17/2012)

---

Steve Jones - SSC Editor (7/17/2012)

---

Gail? When she's got the three...

You use NULL, as Scott mentioned.

create PROCEDURE [dbo].[spUpdateTableA]

@TableAPK int, --only required parameter

@ColumnA nvarchar(50) = NULL,

@ColumnB int = -1

as

begin

SET NOCOUNT ON

SET XACT_ABORT ON

declare @ErrorMessage nvarchar(4000);

begin try

--Start the transaction

begin transaction

update TableA

set ColumnA...

Gail? When she's got the three of us in the dojo?

Scott has a good idea. Can you show some pseudocode or some real code that explains how this should work for you, takilroy? It seems as though you're honing in...

My guess, and it's that, is that you are transferring over the index definition to SQL Server for the PK, trying to parse it, and it's failing because there are...

Not sure what's broken, but in SQL Server, only 16 fields allowed for primary keys.

If you have really wide ranging items, perhaps a lookup tables makes sense.

Personally, I never would use NULL in the field as an update. If someone wanted to remove data...

Do you want to remove the tags in the data, or remove them once you've selected things?

Attempting to reactivate my Yahoo ID

#$%^#$#$# Yahoo

What is migrate? Backup and restore can migrate to the new instance.

Also, what have you done or think you should do?

This is such an open ended question that it's...

Repair with setup? If that didn't work, you should open a call with CSS. Or even uninstall, reinstall. Script out your jobs, principals (sp_help_revlogin), and then detach databases.

I haven't had...

Revenant (7/16/2012)

---

L' Eomot Inversé (7/15/2012)

---

Thanks to "El" Jerry, Jason, Lynn, Paul, Stefan, Gianluca, Bex, Grant, Brandie, Greg, Kiara, Revenant, Sean, Craig, Rodders, Dwain, Ray, Jeff, Jack, Wayne, Jan, and Gus...

Chad Crawford (7/12/2012)

---

Steve, will there be a SSC Party at Summit again this year? If so, can I put in an early plug for a non-gambling reduced/free entry...