Steve nailed it. I said backup, but what I meant was escalation. That's how we handle it.

I also agree on getting a realistic time frame. It takes five minutes for...

Why is that we're always going to decide, on the flip of a coin, to swap out the database server so we need to not use any of the functionality...

I suspect he's suggesting that the "we don't need no stinking procedures" school is going to drive your database to extinction, not the other way around.

We use generated code in...

It can't possibly be caused simply by the number of rows. Inserting one row or one million, neither one changes the schema of the table. That procedure you're calling has...

You're trying to generate an estimated execution plan. You can't with the temp tables. Generate an actual execution plan instead, which means running the query, so make sure you're not...

The one thing I would absolutely demand is a backup. Make darn sure that you have a secondary oncall person. Otherwise, in theory, you can't go out & get groceries,...

Indianrock (2/21/2008)

I'll have to dig for solid evidence...

Yep. It's actually worse because the introduction of...

From a security stand point, less is more. Here's a great white paper from MS that details all sorts of security best practices, not the least of which is masking...

Sorry. I'm not terribly familiar with bcp.

There is no immediate if statement in TSQL. You'll need to create some other mechanism, probably a CASE statement to get the same effect.

SELECT CASE WHEN CurrentSickTerm= 'LT'

THEN 'Long Term'

ELSE...

It's probably a permisssions issue. XP_commandshell is going to run under the security context of the sql server instance where as your command prompt is going to run under your...

First, why are you using dynamic sql here?

You can simply do this:

ALTER PROCEDURE sp_Sample

(

@Empid nvarchar(100)

)

AS

Begin

SELECT * from Employee WHERE empid= @Empid

end

Go

But, if there really is a reason to...

Holy moly. Referring back to my statement, after having seen this code, I wish to refine my original estimate.

Nope. Won't scale. Next.

BTW, I reformatted the query so I could actually...

Well, first, seperate derived tables & CTE's from temp tables & table variables. They are totally different critters. Derived tables & CTE's are constructs that exist within a query statement...