Viewing 15 posts - 181 through 195 (of 751 total)
Despite the name, I'm not aware of that being a Microsoft system stored procedure.
Can you provide the relevant body of the stored procedure (obfuscated for security if necessary)?
The error means...
February 20, 2023 at 8:51 am
You can't alter an existing computed column -- it has to be dropped & re-added.
February 17, 2023 at 6:32 pm
Not much to go on. Is the data relational? What database system is it stored in? Do you intend to move it to the same database system? To a self-managed...
February 13, 2023 at 5:11 pm
February 9, 2023 at 10:43 pm
We appreciate the DDL.
Please provide insert scripts with sample data that we can develop & test with, not just bracketed insert templates that fail with errors when executed.
February 3, 2023 at 9:39 pm
You can't guarantee that natural keys will always be a single column.
For artificial integer keys, I recommend using <TableName>ID (where <TableName> is the actual table name)to avoid ambiguity and confusion....
February 1, 2023 at 6:58 pm
We use xp_delete_file with something like this:
declare @daysToKeep int = 3
declare @minDateToKeep date = dateadd(day,-daysToKeep ,sysdatetime());
declare @dateString char(10) = convert(char(10),@minDateToKeep,121);
declare @traceFilePath varchar(30) = 'D:\Audit\';
EXECUTE master.dbo.xp_delete_file 0,@traceFilePath, N'trc',@dateString;
January 26, 2023 at 5:13 pm
The second scenario makes sense -- read-committed snapshot is going to maintain the version store until transaction is completed regardless of the isolation used by that transaction, because reads by...
January 24, 2023 at 9:48 pm
Is ALLOW_SNAPSHOT_ISOLATION on?
January 19, 2023 at 6:47 pm
If all the tables are joined in the same query, then you need to alias Table0 in the join to each table to enabled SQL Server... and you... to resolve...
January 18, 2023 at 9:55 pm
Does the SQL Server agent account have permissions on those other directories?
January 18, 2023 at 2:11 pm
You are using a function in a predicate (e.g., where clause), rendering it non-sargable (can't use index). The following should probably be sargable, & perform better (assuming you have appropriate...
January 17, 2023 at 8:27 pm
Blazor doesn't (necessarily) use React or npm (though they can be used together). You can use Blazor server-side and/or client-side (WASM).
Blazor uses the Razor template engine, which allows C# in...
January 17, 2023 at 4:05 pm
Given that building are likely to have different attributes (beyond position, & fact that crane positions change) than cranes, I'd use separate tables. I'd even recommend a Crane table for...
January 13, 2023 at 5:16 pm
You gave us the DDL for [Hashing].[CreateSha256KeyFromJsonInputSalesCustomer], but the trigger is failing on [Hashing].[CreateJsonInputForSha256SalesCustomer].
January 13, 2023 at 4:14 pm
Viewing 15 posts - 181 through 195 (of 751 total)