According to Buck Woody of Microsoft at a talk I went to earlier this year, deprecation is deprecated.  What I think he meant is that they're not deprecating features any...

You've discovered the hard way why it's not a good idea to store dates in a char column.  That's not a criticism of you - I'm sure it's not your...

That suggests to me that the data isn't being retained in the cache.  How does the amount of RAM and the max server memory  setting compare between the two servers? ...

Yes, of course.  That's the intention, anyway!

John

I hope your assertion that most triggers are single-row triggers is incorrect, although it certainly does appear to be a mistake that a lot of developers make!

Something like this should...

Why do you want to avoid using a case expression?  Why are you not allowed to share the script?

Seriously, if you're asking for help with what appears to be a...

Debugging dumps is advanced stuff.  I'd raise a call with Microsoft, if I were you.  They're likely to be able to pinpoint the cause much faster than you can.

John

Yes.  You can use dynamic SQL.  Make sure you understand what SQL injection is and how to prevent it before you play with this.

DECLARE @DBName sysname;
DECLARE @SQL...

• This reply was modified 5 years, 11 months ago by John Mitchell-245523.

Mark

You're welcome.  You should consider Luis's or Des's variations as well - I think they're right not to fiddle about with temp tables.  My solution was cobbled together in five...

Something like this?

CREATE TABLE #MedalMetals (Metal varchar(25), MedalRank int);
INSERT INTO #MedalMetals
VALUES
('Performance Standard', 1),
('Bronze', 2),
('Silver', 3),
('Gold', 4);

DECLARE @PP_Medal varchar(25) = 'Bronze';
DECLARE @SU_Medal varchar(25) = 'Silver';
DECLARE @QAS_Medal varchar(25) =...

Maybe the logging needs to be more detailed?  It's been a while since I've used SSIS, so I can't remember how you do that.  Also, if it's only happening intermittently,...

Unfortunately, you can't create a synonym for a schema, only for individual objects.  The reason you didn't get an error when you created the synonym is that the name...

• This reply was modified 5 years, 11 months ago by John Mitchell-245523.

Sounds as if you have a permission on something that the SQL Server Agent account doesn't.  Do you have any logging set up in your package?

John

It's a poorly worded question.  I can think of two reasons why the statement could be construed as being wrong:

(1) It's the rows that are stored in sorted order, not...

To answer your original question, sa has permission to do everything in SQL Server (if anyone knows something it can't do, please don't flame me).  Best practice is to rename...