Viewing 15 posts - 4,891 through 4,905 (of 49,571 total)
It's completely irrelevant how many rows the thing returns. It could well read half the DB to return no rows.
Don't just look at indexes (and indexing foreign key probably won't...
August 28, 2015 at 3:41 am
You get the creation script for it (from source control or the developers), remove the WITH ENCRYPTION line and then run the modified ALTER FUNCTION
August 27, 2015 at 3:06 pm
I don't mind, and lots of people here call me "Gila". Couple people here call me "Monster", which I find a little weird. "Sir" I stopped getting annoyed at years...
August 27, 2015 at 1:39 pm
Hang on...
A logon trigger fires when someone logs in to the server, not when a login is created. You'd need a server-scope DDL trigger to fire on CREATE LOGIN. Which...
August 27, 2015 at 11:41 am
Ok, you're going to have to explain far more what you're doing, because a select cannot cause an error updating. So, details???
August 27, 2015 at 10:48 am
Jo6205 (8/27/2015)
'll keep looking around on the internet.
Or you could answer my question.
August 27, 2015 at 10:39 am
*sigh* It would have helped if you''d explained that it was part of a query...
IF is a control flow, it's used outside of queries only. Hence my previous post was...
August 27, 2015 at 10:36 am
IF @JobStatus = 'O'
SELECT JobStatus FROM JCJM WHERE JobStatus = 1
IF @JobStatus = 'C'
SELECT JobStatus FROM JCJM WHERE JobStatus > 1
You don't need to...
August 27, 2015 at 10:15 am
tthoman77 (8/27/2015)
August 27, 2015 at 10:09 am
If you're got disparate versions, backup/restore isn't going to work for what you want. Try transactional replication.
August 27, 2015 at 9:23 am
You're going to have to fix that trigger, it can't handle multiple rows being inserted in a single operation. To do that, you need to find out (from the other...
August 27, 2015 at 9:21 am
That code cannot throw the error you've posted.
Is there a trigger on the table? Does the trigger have a subquery in it?
I suspect you're got a badly written trigger...
August 27, 2015 at 8:47 am
Jeff Moden (8/27/2015)
JaybeeSQL (8/27/2015)
GilaMonster (8/27/2015)
JaybeeSQL (8/27/2015)
Should the system databases be best moved in any particular order?
To be honest, other than TempDB, I'd probably leave the others alone for now. Moving...
August 27, 2015 at 7:55 am
Viewing 15 posts - 4,891 through 4,905 (of 49,571 total)