Jeff Moden (8/4/2008)

---

I'll just bet a plugged nickel that there isn't an IDENTITY column in the table...

CREATE TABLE #MyHead (RowNum INT, Something VARCHAR(20))

INSERT INTO #MyHead (Something)

VALUES ('Test...

One thing that's recommended by privacy experts and such is to periodically do various "vanity searches" in Google, Yahoo, etc. Plug in your own name, see what comes up....

There has to be more surrounding that simple statement. Either that, or the code is never getting run in those cases.

The fastest way I know to do this is with a "running totals" solution:

create table #Descriptions (

ID int identity primary key nonclustered,

ProdNo varchar(50),

[Description] varchar(50),

ConcatDescription varchar(max))

create clustered index CID_ProdNo on #Descriptions...

Because of the nature of the query, a lot of what it does will depend on the content of the database when it's run. I don't see any way...

It is possible. Just use the install disk, and select the tools and deselect the engine when you get to what features to install.

ApexSQL also has some.

I use Management Studio for most of my SQL work.

Why would some people not have access to it? You can install it on any number of...

Are you using NChar/NVarchar for all of the data that's supposed to be that way?

The problem is not with @@Identity (though that does have problems). The problem is that no row is being inserted. That means some other problem with the code...

I don't think you can make sa not be an owner for every database on the server.

If I had to crawl in a hole every time I spent too much effort on something that turned out to be easy, I don't think I'd ever see daylight....

For the SSIS package, you use File, Save Copy of SSIS Package to... in BIDS.

bodhilove (8/2/2008)

---

Ok.. I will try to attack this from another viewpoint. My SQL server 2000 box say I am using Latin1_General_CI_AS server collation. I may be wrong but because...

SQL Server 2005 Bible by Paul Nielsen is great.

You can do that by adding an e-mail notification step.

On success of step 1, have it to go step 2. On failure of step 1, have it go to...