Viewing 15 posts - 1,606 through 1,620 (of 2,860 total)
One way to do this would be to have a stored procedure with EXECUTE AS in it. This way, you can set the stored procedure to run as sysadmin then...
July 30, 2020 at 2:02 pm
you say that the system needs to be pluggable into "any SQL database" then talk about using reading from the data page and the transaction log files. Not sure I...
July 29, 2020 at 8:26 pm
heh... now you have me second guessing myself on that atom file thing... Been forever since I used that as I found it to be unreliable and annoying to work...
July 29, 2020 at 6:57 pm
As far as I know, if a row has no guaranteed way to be unique, SQL adds a hidden column onto the end to make it unique. Since you didn't...
July 29, 2020 at 5:29 pm
Disadvantage to exporting to Excel from the SSRS site is that you get a static output of the report. Nice thing of Power Pivot is you can click a button...
July 29, 2020 at 4:01 pm
I forgot about one - power pivot inside Excel. Using that you can pull the data from the SSRS server into Excel. Still technically uses the SSRS web stuff and...
July 29, 2020 at 3:40 pm
If you are running Windows 10 and have it stored in your profile, that could be your problem. I've had files (not specifically dtsx files, but pictures) just disappear on...
July 28, 2020 at 9:49 pm
to reproduce the error, set strType to a value other than AAA or BBB. This is easy to do in the debugger (breakpoint, add a watch on "strType" and change...
July 28, 2020 at 5:43 pm
That I am not entirely sure. Best guess - I am wrong on how it is matching things up with the recursive query which I was actually able to prove...
July 28, 2020 at 5:26 pm
Nice! Thanks for the followup!
Only thing I see that may be of concern is that if cmd.ExecuteScaler() throws an exception, that exception is going to be passed back to the...
July 27, 2020 at 9:54 pm
To confirm, you SEE this blocking? The reason I ask is that a SINGLE SQL query, even a recursive one, will use the SAME SPID for the lifetime of the...
July 27, 2020 at 9:41 pm
did you get this sorted out?
July 27, 2020 at 9:20 pm
looking at the graphs doesn't mean much if you don't have a reasonable scale. your scale of 0 to 100 doesn't really tell us much as 0 to 100 bytes...
July 27, 2020 at 9:18 pm
Looking at the execution plan images (as we have no actual execution plan to review) your biggest hitters are the DELETE and the INSERT, so I too am wondering if...
July 27, 2020 at 8:02 pm
First step to troubleshooting this is to look at the error message.
Can you post that?
Doing a differential backup should be very similar to a tlog backup or a full backup,...
July 27, 2020 at 7:19 pm
Viewing 15 posts - 1,606 through 1,620 (of 2,860 total)