Viewing 15 posts - 76 through 90 (of 1,199 total)
You don't need to, but you can change the CATCH handler to:
BEGIN CATCH
ROLLBACK
; THROW
END CATCH
; THROW reraises the error message exactly...
October 8, 2020 at 6:41 am
Obviously, we cannot answer any questions without knowledge of what is going on. Wait until you have the issue again and use my beta_lockinfo and share the output so we...
October 7, 2020 at 12:46 pm
Yes, string_agg is much more straightforward to use.
There are a few things that have been removed since SQL 2008, but not a lot. The COMPUTE BY clause, which I hope...
October 7, 2020 at 6:37 am
There is one alternative. But it is worse than the CLR. You can call extended stored procedures from SQL functions, so you can call xp_cmd.... I think I stop there.
(I...
October 6, 2020 at 6:45 pm
So have you tried troubleshooting the issue with my beta_lockinfo yet? http://www.sommarskog.se/sqlutil/beta_lockinfo.html.
There is no one here can answer what is going on without access to your system - or...
October 6, 2020 at 1:55 pm
If you look at my example, you see that I have a binary column, you have a string column. When you encrypt data with any of the cell-level encryption methods,...
October 5, 2020 at 4:29 pm
Why are you starting a new thread on the same question?
Why lock on one particular table is not released(in our case extended property update query)?
Do you seriously believe that anyone...
September 30, 2020 at 11:06 am
Your concerned about the performance in .NET? Didn't you complain that the query you had crafted from Brian's input was very slow? Or were you able to resolve that?
My position...
September 29, 2020 at 8:01 pm
I only write C# left-handedly, so I may not be the best person to ask. Then again, how difficult can it be? You have a data table - transform it...
September 29, 2020 at 7:00 am
Scott, with that kind of stack dump, it is clear that "IT Researcher" is working from a GUI and not a query window. In any case, the error details makes...
September 28, 2020 at 3:23 pm
You can use my beta_lockinfo to find out about locks and blocking in the system, http://www.sommarskog.se/sqlutil/beta_lockinfo.html.
September 28, 2020 at 11:37 am
I don't what you did, but I did this. On my SQL 2008 instance I ran:
CREATE TABLE objects(id int NOT NULL, name varbinary(400) NOT NULL)
INSERT objects...
September 25, 2020 at 1:00 pm
Best is probably to do the pivoting client-side. In that case there will be no risk for SQL injection!!
As it happens, I also have some text about how to write...
September 25, 2020 at 7:46 am
You create a certificate and sign the procedure with the certificate. Then you create a user from the certificate and grant that user SELECT permission on the table in question....
September 25, 2020 at 6:38 am
And how do you expect us to be able to help you when you don't share any information at all? Permit me to point out that this is a forum...
September 19, 2020 at 8:41 am
Viewing 15 posts - 76 through 90 (of 1,199 total)