Viewing 15 posts - 76 through 90 (of 9,244 total)
Regardless of indexes with only a handful of rows a table scan is likely
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 11, 2024 at 3:12 am
If you want a more secure response, open up the SQL Configuration Manager on the target SQL Server and right click>properties for Protocols for MSSQLSERVEER under "SQL Server Network...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 10, 2024 at 6:15 pm
do you have more info on what this table is used for and how frequently its updated.
for the idpool it sounds like its a value youre using elsewhere and maybe...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 10, 2024 at 8:18 am
Thanks
double checked this and it’s not supported with sql db, managed instance supports restoring the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 9, 2024 at 10:55 pm
What information does replication monitor show if you drill into the detail?
what type of publication are you using and where is the distributor located?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 9, 2024 at 10:43 pm
Any failover cluster instances or just availability groups and standalone instances?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 9, 2024 at 10:39 pm
I thoroughly recommend you read all the documentation but see below
Hi
I am New To Azure Sql. Can some one please share
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 8, 2024 at 10:24 am
Have you read the MS documentation firstly?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 7, 2024 at 11:06 pm
I have never come across synonyms.
they're big in oracle, synonyms are very popular and also useful in sql server
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 7, 2024 at 11:04 pm
If doing it the way you wish check the user owning the job has permission to the spa in ssis catalog
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 7, 2024 at 4:15 pm
The error above does suggest that the package itself is attempting to change execution context which doesn’t fit to well with the sp execution type.
Any idea what the package is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 7, 2024 at 1:47 pm
Yes you’re running the package aren’t you or have I misread that
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 7, 2024 at 12:46 pm
What events are you capturing in the trace?
as pointed out already the sql server error log or windows application log will contain details, the error log event in the default...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 7, 2024 at 12:39 pm
You haven’t specified whether there are any keys or referential integrity on the tables, do they contain any?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 7, 2024 at 12:26 pm
Have you looked at creating a credential and an ssis sql agent proxy then running the step under this proxy
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 7, 2024 at 12:18 pm
Viewing 15 posts - 76 through 90 (of 9,244 total)