Viewing 15 posts - 436 through 450 (of 7,503 total)
Start an appropriate XE session to monitor that sproc's execution
You need to debug this sproc, because it will hit some error somewhere and may not hand it over to the...
May 3, 2023 at 5:26 am
You already made my day, Jeff !
Visualising your figurative speech.
Guess what: our auditors are always charmed by the 2 year migration rule ( that is already active for 10 years...
May 3, 2023 at 5:22 am
Eeasiest would be to start adding a partition for the new month and go from there on.
You'll need to handle the 6-month partition adequately in your cleanup process. ( Leave...
May 2, 2023 at 12:44 pm
O, this is a nice solution track.
It will need some fiddling with, because it spews a load of "ole%" events.
I've ended up with this to start discovering it all:
May 2, 2023 at 12:39 pm
indeed.
Been there, did that.
You can bring a horse to the water, but you cannot make it drink.
May 2, 2023 at 9:34 am
These are SQL 2005 instances on Win 2003 ( to be retired in the next 2 years, for the last 10 years )
From systems maintenance perspective, we don't touch these...
May 2, 2023 at 6:20 am
Once you go to SQL2019, the minimum database level is 100 !
That may break some stuff if you were to migrate the db and have your app use it on...
April 28, 2023 at 2:06 pm
April 28, 2023 at 11:37 am
No we only have named instances on our SQL2005 clusters.
ClusteredSQLServerName\InstanceName is being used to connect with.
Connections which provide the correct port number workt fine
( ClusteredSQLServerName, portno OR ClusteredSQLServerName\InstanceName,portno )
April 28, 2023 at 8:14 am
It must be a SQL2005 issue.
All newer Clustered SQL Server instances work are getting connected to without an issue.
April 28, 2023 at 6:14 am
It returns the sql server full instance name allright.
April 28, 2023 at 6:06 am
local firewall active?
April 26, 2023 at 8:31 am
Why is this left join used in your "WHERE NOT EXISTS " parts?
...
April 12, 2023 at 9:57 am
Why is this left join used in your "WHERE NOT EXISTS " parts?
...
April 11, 2023 at 1:45 pm
Viewing 15 posts - 436 through 450 (of 7,503 total)