Viewing 15 posts - 31 through 45 (of 7,368 total)
FWIW
This is the sql script I always use to detangle my wait resource:
(as the script serves me for ages by now, the originatin utl's no longer work )
October 17, 2024 at 9:33 am
waitresource="PAGE: 14:1:5803256 "
Blocking spid="298"
Blocked spid="93"
use SP_WHO2 to figure out these connections
October 16, 2024 at 1:32 pm
Actually, if you restore the backup to an instance as a new database, there is no need for a tail-log backup at all !
( this is a flaw in the...
October 16, 2024 at 6:58 am
You've messed up the xml to much !
It doesn't produce a garph anymore !
Use dummy names ( T123 / t124 / ... ) instead of "<table name>" as < and...
October 15, 2024 at 1:22 pm
can you share the xml?
October 15, 2024 at 11:28 am
A tail-log backups only purpose is that you can restore the original database as is was on the target server right before you performed the intended restore.
What's the difference with...
October 15, 2024 at 8:48 am
I requested it to write the TSQL DDL to created the needed tables based on your input.
It came up with this. ( not perfect, but it gets you started )
October 10, 2024 at 7:30 am
fwiw - post this question as input for copilot . microsoft . com and add "Write the tsql stored procedure to process my expenses report per batch"
See what it comes...
October 10, 2024 at 6:42 am
Keep in mind, everybody that can use the linked server, will have the authority of the given "rmtuser" !
That's the reason I only allow read-only accounts to be used in...
October 10, 2024 at 5:36 am
How did you define the security to be followed when using this linked server ?
October 9, 2024 at 12:32 pm
even on SQLMI there are restrictions for CLR stuff:
October 9, 2024 at 9:19 am
is your user profile stored with remote as primary ?
( = wrong implementation of a great concept )
October 8, 2024 at 11:10 am
indeed. Thank you for pointing the subtle difference.
Tried it.
Didn't provide the data I aimed for.
October 7, 2024 at 6:30 am
It did generate the same error as the debug channel at create time.
However, now I see it accepts the create of the event session.
Time to investigate ( for a short...
October 3, 2024 at 12:41 pm
doesn't work !!! ( see OP )
October 3, 2024 at 11:32 am
Viewing 15 posts - 31 through 45 (of 7,368 total)