FYI, you have to quote the color, "red" in the color tag.

Hah, this is straight out of the Question of the Day for July 23rd, 2007 that I just answered:

Correct answer:

Start the instance in single user mode and connect as...

I interview Drexel seniors all the time who have senior projects just like this.

As to the matter of conformance to standards...

For...

Jeff, good article and good response. I also agree that the tone of some of the comments was unnecessary and inappropriate.

That said, there are two things that I would...

Ultimately, to do this you will need to use dynamic SQL, like so:

Create PROC insert2img

as

Begin

Declare @img1 as varbinary(max)

Declare @dircmd as varchar(max)

DECLARE @filename varchar(100)

DECLARE @filepath varchar(100)

DECLARE @maxRowID int

DECLARE @count int

DECLARE...

The [font="System"]'data_file'[/font] argument to OPENROWSET(.. BULK.. ) must be a quoted string literal, it cannot be a variable or an expression.

Although Help and BOL are not entirely consistent, usually when...

select name from table1 where position='developer''s'

Sounds like you've got bad data. One or more of your image fields may not be all text.

Can you show us the query plans for both?

thanks

happy to help.

Title says "Don't look this up in BOL..." Does this mean that we can look up answers to the other questions in BOL? Because I have been doing...

Harveysburger (3/14/2008)

---

thanks for the reply,

so let's say I go with scenario #3...

Knowing that in one of the two tables TranTypeID will always be the same. (In the table...

Again, I am pretty sure that TempDB is always like this. The smaller values are the *Initial* sizes that SQL Server uses when it creates TempDB on startup. ...

Adam Bean (3/14/2008)

---

Look at my SSMS ... sysaltfiles vs sysfiles ...

Then compare the properties window of tempdb, vs. the size on disk.

Two different sets of sizes being reported for...