Viewing 15 posts - 601 through 615 (of 7,191 total)
When you ran it outside your statement you should have seen what the problem is. The subquery returns more than one value of Email. Which of those values do you...
November 1, 2018 at 9:02 am
Keep them all on one drive. You're doing this to reduce contention on the header page (that's not a technical term - I can't remember what it's actually called), of...
November 1, 2018 at 4:16 am
Create a calendar table with all dates from 1st April 1789 to the present day. Then join your table of presidents to that on calendar date between StartDate and DiedDate,...
November 1, 2018 at 2:57 am
Well, you said that the "Proxy account ... has all the permissions to access the files in the folder". Just do the same thing for the SQL Server Agent account...
October 31, 2018 at 10:42 am
It's just saying that the PersonEmail column has a different collation from the Person Name column. Use a COLLATE clause on one of them to match it to the collation...
October 31, 2018 at 10:28 am
That second screenshot only shows that a.cust_po exists, not b.cust_po.
John
October 31, 2018 at 10:20 am
The only thing I can think of is that, despite the proxy account, the file enumeration is being performed in the context of the SQL Server Agent account. Might be...
October 31, 2018 at 10:01 am
October 31, 2018 at 9:58 am
I agree with Thom. However, given that you have comedy limited values in your column(s), you're already in a bit of a pickle. If you absolutely have to do this,...
October 31, 2018 at 9:42 am
Willem
Still a little too vague, really. If you're always replacing the same character with the same other character (S with R), use REPLACE. If you're always changing the...
October 31, 2018 at 9:22 am
I assume that changing the stored procedure is an option? If so, get rid of the @idSubsytem parameter and put an INSERT INTO Subsystem DEFAULT VALUES statement (I'm doing this...
October 31, 2018 at 8:27 am
If I've understood correctly, all you need to do is to INSERT DEFAULT VALUES into subsystem and use an OUTPUT clause to get the ID, which you can use in...
October 31, 2018 at 6:23 am
No, that's nothing to do with it. .BAK is just a convention: you can give the file any extension you like and it will still work. This really does point...
October 31, 2018 at 5:48 am
No, you should still be able to run RESTORE HEADERONLY even if the backup is from a newer version. In any case, I'd be surprised if your app could do...
October 31, 2018 at 5:15 am
October 31, 2018 at 3:08 am
Viewing 15 posts - 601 through 615 (of 7,191 total)